OracleConnections

Oracle Community Network

Oracle Driver Error - ArrayIndexOutOfBoundsException

I have recently changed my Oracle 9 databse to a new database (still Oracle 9). I have an application that connects to the database. I have changed the configuration file to point to my new databases IP address. When I load my application I get the error below. Based on my research, it seems the issue is an out of date driver. My application used to use classes12_01.zip. I have now replaced this driver with ojdbc14.jar. I am still getting this error. I believe I am able to create the driver correctly. The issue happens when My driver tries to find my new database in the connection pool. It says it doesn't exist.

Has anyone got a solution to my problem.

2 members like this

▶ Reply to This

Replies to This Discussion

Permalink Reply by Humberto Deboer on May 7, 2013 at 10:52am

Your driver ought to be the best match of JDK and Oracle version you can find.

ojbbc14.jar is still very much out of date. JDK 7 is the standard today.

WebLogic is certified with a particular JDK version when you install it. Which version of WebLogic are you using? Which JDK is it certified for? Which version of Oracle?

With all three of those answers in hand, you can select a JDBC driver. But not before. Both of your classes12 and ojbdc14 choices are likely to be incorrect.

I'm guessing that WebLogic is using JDK6, so you should get ojdbc6.jar for your version of Oracle.

▶ Reply

Permalink Reply by Monty Comeau on May 7, 2013 at 10:54am

Without seeing the code, the only thing I can think of is to check that each connection is being accessed in a thread safe manner. The Oracle drivers are usually pretty solid. The only time I've seen weird internal errors like that is when you've got more than one thread accessing the same connection instance and doing weird stuff with it. They aren't thread safe, and should be kept to one per thread.