Oracle metadata DB Connection Error as java.lang.RuntimeException: java.lang.ArrayIndexOutOfBoundsException: -1

[paresh1]

Hi,

Earlier Oracle db was successfully connecting by creating metadata db Connections in DI studio when doing a Test Connection.

But unfortunately I don't know how this error came

when doing a

Test Connection as I have not changed any parameters of the connection.

tOracleConnection component and getConnection(url) string are running fine and fetching the rows from oracle

but issue is in the metadata connection.

Any kind of advice is appreciated.

Below is the exception given when doing a Test Connection on the metadata db Connection created

and attached is the error screenshot.

Connection failure. You must change the Database Settings.

 java.lang.RuntimeException: java.lang.ArrayIndexOutOfBoundsException: -1

   at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:208)

   at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1146)

   at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)

   at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:290)

   at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:4208)

   at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:1)

   at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)

   at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)

   at java.util.concurrent.FutureTask.run(FutureTask.java:266)

   at java.lang.Thread.run(Thread.java:748)

 Caused by: java.lang.ArrayIndexOutOfBoundsException: -1

   at oracle.jdbc.driver.T4CTTIoauthenticate.setSessionFields(T4CTTIoauthenticate.java:1068)

   at oracle.jdbc.driver.T4CTTIoauthenticate.<init>(T4CTTIoauthenticate.java:261)

   at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:565)

   at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:715)

   at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385)

   at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30)

   at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564)

   at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)

   at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:199)

   ... 9 more

[paresh1 · Accepted solution]

So no answers.

I got rid of it by upgrading jdk8 to jdk.11.0.8 and reinstalling TOS DI.