[resolved] ORACLE OCI connection problem

[Anonymous]

Hello,
I have a problem with creating ORACLE OCI connection. When I test other connection types like SID or service name with the same parameters everything worked well.
I tried to create the connection in repository but without any success.
Im getting the following error message:
Exception in component tOracleConnection_1
java.sql.SQLException: ??
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:650)
at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:338)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:133)
at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:53)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at test.sfaf_0_1.sfaf.tOracleConnection_1Process(sfaf.java:287)
at test.sfaf_0_1.sfaf.runJobInTOS(sfaf.java:524)
at test.sfaf_0_1.sfaf.main(sfaf.java:390)
Im using TOS_DI-win-x86_64 V5.3.1 running on WIN 7 64, oracle client 11.2.0 installed is 64bit as well as JDK 7.
ORACLE_HOME and TNS_ADMIN variables set correctly.
Could anyone help me with this?
Thanks a lot!!
Zdenek

[Anonymous]

Hi,

I tried to create the connection in repository but without any success.

Did you get "no ocijdbc11 in java.library.path" error message?(I cannot see the error "java.sql.SQLException: ??" ) If so, when you use the oracle oci to conntect remote oracle database , you need install Oracle Client on your computer.
See the related document TalendHelpCenter: Setting up a DB connection
Best regards
Sabrina

[Anonymous]

Oracle client is already installed, the ocijdbc11 library is in ..oracle\product\..\BIN\ directory.
Btw I dont know why I get these two chars "??".
Thank you,
Zdenek

[Anonymous]

Hi Zdenek,
Did you resolve your issue? Because the topic state is resolved. If so, could you please share your solution with us?
Best regards
Sabrina

[Anonymous · Accepted solution]

Hello,
yes I did, I had oracle client 11 and tried to connect to oracle 10 database which wasnt problem for ORACLE with SID or ORACLE with service name connection types BUT ORACLE OCI connection couldnt be established.
WHAT I DID was just downloaded ocijdbc10.dll and copied it to %ORACLE_HOME%\BIN directory and it solved the problem. So Im still running oracle 11 client but I have to say Talend to to use ORCALE 10 when creating ORCLE OCI connection.
For other types of ORACLE connections I can leave ORACLE 11 in DB Version field and it works.
Thank you for help Sabrine!
Best regards,
Z.

[Anonymous]

Hi,
Thanks for your sharing, which is useful for us.
Best regards
Sabrina

[Anonymous]

Same issue in TOS DI 6.2.1 x64 + Oracle 11R2 x64 client using tnsnames and direct Socket connection
Connection works in all modes except OCI

[Anonymous]

Hi,
It seems the Oracle jar is not compatible with the current OCI client used.
Have you tried to  update the jars in studio to the ones in the OCI Client download to see if it is Ok with you?
Please take a look at a similiar issue:https://community.oracle.com/thread/924664?tstart=0
Best regards
Sabrina