[resolved] Data from Oracle8 to Oracle11 got "ArrayIndexOutOfBoundsException: 7"

[Anonymous]

Hi,
I have created a simple JOB for transport some tables from an Oracle 8 instance to another Oracle 11 instance.
The job is simple:

But I get this error:

Starting job Replica at 11:13 01/09/2014.
 connecting to socket on port 3610
 connected
Exception in component tOracleConnection_2
java.lang.ArrayIndexOutOfBoundsException: 7
	at oracle.security.o3logon.C1.r(C1)
	at oracle.security.o3logon.C1.l(C1)
	at oracle.security.o3logon.C0.c(C0)
	at oracle.security.o3logon.O3LoginClientHelper.getEPasswd(O3LoginClientHelper)
	at oracle.jdbc.ttc7.O3log.<init>(O3log.java:290)
	at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:251)
	at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:252)
	at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at datareplicator.replica_0_1.Replica.tOracleConnection_2Process(Replica.java:580)
	at datareplicator.replica_0_1.Replica.tOracleConnection_1Process(Replica.java:488)
	at datareplicator.replica_0_1.Replica.runJobInTOS(Replica.java:2307)
	at datareplicator.replica_0_1.Replica.main(Replica.java:2166)
1202 milliseconds
 disconnected
Job Replica ended at 11:13 01/09/2014. 

Any suggestion?
I'm using "Talend Open Studio for Data Integration" Version: 5.5.1 Build id: r118616-20140617-1110
Thanks
S.

[Anonymous]

Hi
1) Please check you are using correct jdbc driver.
2) You are using correct service name for connection.
For more you can visit these link,hope you can get to the solution
https://community.talend.com/t5/Design-and-Development/Oracle-Load-errors-out-after-10000-records/td...

[Anonymous]

Hi, and thanks for your feedback.
I hope jdbc driver are corrects (its was automatically downloaded by TOS) and the data connection is correct, both test was succesful.
Now, I'm going to read your links!

[Anonymous]

hi ,
as Sanjay, I would have said that it 's a problem with your driver.
test component connection alone ; test with different oracle connection list item (DB version)
regards
laurent

[Anonymous]

Hi 
For testing purpose you can do as 
tLibraryLoad--->DataBaseConnection-->DataBaseInput-->tLogRow
It will help you getting whether you are able to fetch data from input using ojdbc driver you are using.If yes then do the same with Oracle11 by creating a sample table in it and using the same ojdbc driver,if it works then no problem with jar else you need to look for your jdbc drivers.

[Anonymous]

tLibraryLoad--->DataBaseConnection-->DataBaseInput-->tLogRow

I found all the component, what JAR I must load with tLibraryLoad?
Thanks again
S.

[Anonymous]

Update: guessing the sql query by TOS, I found something strange viewing the Oracle schema.
In the Oracle 8 connection, all works fine, but in the Oracle 11 the schema is not recognized.

Suggestion? Or I'm just a noob? XD
Thanks
S.

[Anonymous]

Hi,
I think you should use ojdbc14.jar if it is there.
You should create table in target database with same schema as in Oracle8,If schema is different it will not populate data in Target database.

[Anonymous]

Hi,
I think you should use ojdbc14.jar if it is there.
You should create table in target database with same schema as in Oracle8,If schema is different it will not populate data in Target database.

TOS has downloaded:
- ojdbc12.jar: creating Oracle 8 connection
- ojdbc5.jar: for Oracle 11 connection
😕

[Anonymous · Accepted solution]

Solved.
Must use an Oracle 9 connection for souce, but source Oracle RDBMS version is 8.1.7.
Thanks everyone
S.