Oracle Autonomous Database - Wallet

Anonymous — Tue, 04 Dec 2018 05:28:33 GMT

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

Re: Oracle Autonomous Database - Wallet

vapukov — Tue, 04 Dec 2018 10:23:16 GMT

try to add in run advanced properties:

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

Re: Oracle Autonomous Database - Wallet

Anonymous — Tue, 04 Dec 2018 22:17:01 GMT

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

Re: Oracle Autonomous Database - Wallet

Anonymous — Wed, 08 Jan 2020 13:54:17 GMT

Hello Bajali,

Did you find any solution?

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

Thanks!

Guilherme

topic Re: Oracle Autonomous Database - Wallet in Talend Studio

Oracle Autonomous Database - Wallet

Re: Oracle Autonomous Database - Wallet

Re: Oracle Autonomous Database - Wallet

Re: Oracle Autonomous Database - Wallet