[resolved] ORACLE OCI connection problem

One Star

[resolved] ORACLE OCI connection problem

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

Accepted Solutions
One Star

Re: [resolved] ORACLE OCI connection problem

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.

All Replies
Moderator

Re: [resolved] ORACLE OCI connection problem

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] ORACLE OCI connection problem

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
Moderator

Re: [resolved] ORACLE OCI connection problem

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] ORACLE OCI connection problem

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.
Moderator

Re: [resolved] ORACLE OCI connection problem

Hi,
Thanks for your sharing, which is useful for us.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] ORACLE OCI connection problem

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
Moderator

Re: [resolved] ORACLE OCI connection problem

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.