tOracleOutput - java.lang.ArrayIndexOutOfBoundsException: -32703

[manueld]

Hello all,
Just started to use Open Studio Version: 6.2.0
https://community.talend.com/t5/Design-and-Development/tOracleOuput-ArrayIndexOutOfBoundsException/t...
In 5.6.2 I think I swithed from ojdbc14 to ojdbc6 but did not log how I did it!
This error seems to be back with the 6.2 version
I have an hard time figuring what to change in order to use the proper driver.
I installed ojdbc7.jar via talend modules. See printscreen
So how I can i fix this?
My prod environnement does have ojdbc6 with jobs build in 5.6.2. Those are working fine

[Anonymous]

You can simply ignore the notification about the out-dated modules. I have no idea why Talend has not erased these references to the out-dated driver files already. You will finally see in the job editor if a driver is really missing and I bet you will not find any missing.

[manueld]

Hi,
you are correct I do not have any missing jar. But I do have the array the exception.
I put the pic there only to show that I DO have the ojdbc6 and ojdbc7 installed

[Anonymous]

Strange, should not happen anymore. Could you please check if the problem disappears if you load the latest oracle jdbc driver per tLibraryLoad component?

[manueld]

Hi,
the problem dont disappear since many oracle component in my job does load the ojdbc6 jar.
SO I changed only the output component :
<IMPORT NAME="ORACLE_11-6"  MODULE="ojdbc6.jar" MVN="mvn rg.talend.libraries/ojdbc6/6.0.0"
becomes
<IMPORT NAME="ORACLE_11-6"  MODULE="ojdbc7.jar" MVN="mvn rg.talend.libraries/ojdbc7/6.0.0"
a test with only an oracleoutput did work. I added a toraclerow component BEFORE the toracleoutput and the job throw the ArrayIndexOutOfBound, Finaly, if i run the job when the outout component is called before the oraclerow, the job wont even compile saying it miss the ojdbc6.jar! And all these tests used tLibraryLoad (with ojdbc7.jar) as first step.
My conclusion is to edit tOracleXYZ_java.xml 
TOS_DI-20160510_1709-V6.2.0\plugins\org.talend.designer.components.localprovider_6.2.0.20160510_1709\components\tOracle****
Anybody have a better solution?

[manueld]

FYI
Instead of changing all my component xml files, I ended up changing all my "DB version" to 12-7­.
It did solved my problems
Note that Talend repository AND Oracle do not have the same ojdbc6 jar:
https://talend-update.talend.com/nexus/content/repositories/libraries/org/talend/libraries/ojdbc6/6....
vs
http://www.oracle.com/technetwork/apps-tech/jdbc-112010-090769.html

[Anonymous]

Thats great! Sorry actually I should know changing the used Oracle version to a higher change also the driver.
I see, the SHA-1 checksum is quite different. Could you file a JIRA ticket?
Actually I hate jars without a clear version number, IBM and Oracle often do not provide such a clear number in the file name.

[manueld]

Jira here :  https://jira.talendforge.org/browse/TDI-37691
Dont be sorry, your initial suggestion helped me find a solution!
Also, I would not even use Talend if all tFileExcel component were not existing!
Thanks again

[Attunity_user]

Hi,
I followed what manuel.dion   said to change DB version to 12 and it corrected all the jobs.  I just want to confirm if it will create any new issue.  Originally, DB version was 11 and without checking compatibility, I flipped it to 12.
Is that a better solution for  error that threw the ArrayIndexOutOfBound?

[Attunity_user]

Hi there,
I want to add one more question.  The concern I have is because our oracle version that we use it as Target database is 11 version.  So flipping it to DBversion to 12 although jobs in Talend works, will it cause any new issue?
I appreciate your response.
Thanks