DBConnect - unknown error when validating oracle database connection.

[yong_ly]

Trying to connect to an oracle database via DBconnect but it keeps giving me a unknown error when trying to validate the connection. I know that the port, username and db names are right as I can connect using TOAD.

dbx.log entry:

2014-05-05 14:55:10.736 dbx6855:ERROR:BridgeSession -

Exception occured while executing
command:
java.lang.ArrayIndexOutOfBoundsException:
7
java.lang.ArrayIndexOutOfBoundsException:
7 at
oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:989)
at
oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)
at
oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:508)
at
oracle.jdbc.driver.T4CConnection.(T4CConnection.java:203)
at
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at
java.sql.DriverManager.getConnection(DriverManager.java:620)
at
java.sql.DriverManager.getConnection(DriverManager.java:200)
at
com.splunk.dbx.sql.type.impl.AbstractDatabaseType.connect(AbstractDatabaseType.java:138)
at
com.splunk.dbx.sql.type.impl.Oracle.connect(Oracle.java:48)
at
com.splunk.dbx.sql.Database.connect(Database.java:522)
at
com.splunk.dbx.sql.Database.validateConnectionParameters(Database.java:436)
at
com.splunk.dbx.sql.validate.DatabaseValidator.invoke(DatabaseValidator.java:29)
at
com.splunk.bridge.session.BridgeSession.call(BridgeSession.java:92)
at
com.splunk.bridge.session.BridgeSession.call(BridgeSession.java:30)
at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at
java.util.concurrent.FutureTask.run(FutureTask.java:166)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at
java.lang.Thread.run(Thread.java:636)

It's strange, I know the DB connect app works fine since I've got other oracle connections set up working properly..

[yong_ly · Accepted solution]

Found the answer. I simply downloaded an older JDBC version and copied it into the lib folder and it just seems to have worked fine.

[yong_ly]

so I think it has something to do with the fact that these databases are on oracle 8i, but the JDBC driver is ojdbc6.jar which isn't compatible.

Now, how do I add a new .jar file for an older JDBC driver.. one that's comptaible with JDK 1.6??