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

paresh1 — Sat, 16 Nov 2024 01:54:27 GMT

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

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

paresh1 — Fri, 17 Jul 2020 08:14:38 GMT

So no answers.

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