Oracle Autonomous Database - Wallet

[Anonymous]

Hi

  I am using Talend 7.1.1 and trying to connect to Oracle Autonomous Database.  I tried to use the tDBOutput component. I chose Connection Type : WALLET. However even after this i don't have an option to point "WALLET_LOCATION". Can someone please help to get me connected to the Autonomous DB please

Thanks

Balaji

[vapukov]

try to add in run advanced properties:

-Doracle.net.tns_admin=C:\myTNSdir
-Doracle.net.wallet_location=C:\mywalletdir

[Anonymous]

Thanks for the quick response. I tried that, but i am still not able to get my connection working. I am sure i am doing some basic mistake.

Enclosing screen shots to provide more information.

1. Complete Process.PNG provides the entire process

2. Using tDBOutput component. This is the output component that has the following

    a. Connection Type : Wallet

    b. URL : "jdbcracleci:/@balatest_high" --> hopefully this will not be used as all connection information is in the wallet

    c. Oracle Schema : "f_user1"

3. tLibraryLoad. This is the component that is used to point all Wallet related JARs

4. In the advanced properties, i have set the tns.admin and wallet_location

   the error i get is the following

Exception in component tDBOutput_1 (TestJob)
java.sql.SQLException: ORA-12154: TNS:could not resolve the connect identifier specified

at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1159)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1062)
at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:729)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:782)
at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:60)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:704)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:270)
at testing.testjob_0_1.TestJob.tFileInputDelimited_1Process(TestJob.java:2254)
at testing.testjob_0_1.TestJob.tLibraryLoad_1Process(TestJob.java:4568)
at testing.testjob_0_1.TestJob.runJobInTOS(TestJob.java:4795)
at testing.testjob_0_1.TestJob.main(TestJob.java:4646)

Not sure what is the mistake i am making. Please help

Thanks

Balaji

[Anonymous]

Hello Bajali,

Did you find any solution?

I followed the same steps and I am facing the same problem.

Thanks!

Guilherme