topic Re: [resolved] ORACLE OCI connection problem in Talend Studio

[resolved] ORACLE OCI connection problem

Anonymous — Sat, 16 Nov 2024 11:55:34 GMT

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

Re: [resolved] ORACLE OCI connection problem

Anonymous — Wed, 28 Aug 2013 10:34:59 GMT

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

Re: [resolved] ORACLE OCI connection problem

Anonymous — Wed, 28 Aug 2013 10:41:58 GMT

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

Re: [resolved] ORACLE OCI connection problem

Anonymous — Thu, 29 Aug 2013 03:54:44 GMT

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

Re: [resolved] ORACLE OCI connection problem

Anonymous — Fri, 30 Aug 2013 11:43:30 GMT

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.

Re: [resolved] ORACLE OCI connection problem

Anonymous — Mon, 02 Sep 2013 03:42:34 GMT

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

Re: [resolved] ORACLE OCI connection problem

Anonymous — Sun, 18 Dec 2016 20:47:40 GMT

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

Re: [resolved] ORACLE OCI connection problem

Anonymous — Mon, 19 Dec 2016 08:06:05 GMT

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