topic Re: tOracleConnection : How to create Oracle Wallet connection ? in Talend Studio

tOracleConnection : How to create Oracle Wallet connection ?

Anonymous — Sat, 16 Nov 2024 11:59:52 GMT

Hello,
a) I want to create a tOracleConnection using an Oracle Wallet...
Can someone help me to fill in the different parameters correctly :
My Oracle Wallet is stored on my PC : d:\ECB\ORAWAL\
I want to use the GPDVL_SQL_PCU_A------ entry of my wallet.
I succeeded to connect the DB via sqlplus.
b) When I try to create a DB connection metadata, the Oracle Wallet connection type is not shown... Is this a bug ? Do you have a workaround ?
Thanks for your feedback...
My tnsnames.ora looks like this :
ifile=//xxxxx.xxx.ksys.be\OID_TNSNAMES\tnsnames.ora
ifile=//xxxxx.xxx.xxs.be\OID_TNSNAMES\tnsnames.custom.ora
ifile=//orclnet11.unix.banksys.be\OID_TNSNAMES\tnsnames.ora
ifile=//orclnet11.unix.banksys.be\OID_TNSNAMES\tnsnames.custom.ora
# New local entries to be able to use the Oracle Wallet
GPDVL_SQL_PCU_A142762.unix.banksys.be,GPDVL_SQL_PCU_A142762=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxdev2.xxxxX.BANKSYS.BE)(PORT=1531))(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxdev1.xxxxX.BANKSYS.BE)(PORT=1531))(LOAD_BALANCE=false)(FAILOVER=true))(CONNECT_DATA=(SERVICE_NAME=GPDVL_SQL_PCU.xxxx.banksys.be)))

François,
=====================
D:\ECB\Tools\testsvn>sqlplus /@GPDVL_SQL_PCU_A------
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jun 17 14:05:20 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> q
SP2-0042: unknown command "q" - rest of line ignored.
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
D:\ECB\Tools\testsvn>

Re: tOracleConnection : How to create Oracle Wallet connection ?

Anonymous — Mon, 17 Jun 2013 13:29:17 GMT

Hi
i never tried to create a wallet connection, but after search for a while on google, I think it should work with tJDBCXXX component, have a try to create a wallet connection with tJDBCxxx connection. Refer to this page:
http://tech.shopzilla.com/2011/09/oracle-wallet-with-thin-driver-with-connection-pool-with-database-timeouts/
Shong

Re: tOracleConnection : How to create Oracle Wallet connection ?

Anonymous — Wed, 19 Jun 2013 13:17:59 GMT

Hello,
After a few hours of word, I'm now able to work with tJDBCConnection and Oracle Wallet....
With tJDBCConnection, I have filled in values like this :
JDBC URL = "jdbc racle:thin:/@GPDVL_SQ_PCU_A142762" (the entry in my tnsnames.ora)
Driver Jar : ojdbc6.jar (depends your JVM version), oraclepki.jar, osdt_cert.jar osdt_core.jar
Driver Class = "oracle.jdbc.driver.OracleDriver"
Username = null Password=null
Also, you need to add System properties at run time. Currently, I ticked the 'Use Specific JVM arguments' and added 2 arguments :
-Doracle.net.tns_admin="D:\ECB\ORA_Wallet" (where is located your tnsnames.ora file...)
-Doracle.net.wallet_location = "-Doracle.net.wallet_location="(SOURCE = (METHOD = FILE ) ( METHOD_DATA = ( DIRECTORY = D:\ECB\ORA_Wallet )))"
I have tried to put all these parameters in Contexts (after JDBCconnection METADATA creation)... but that does not work.
Do you have ideas ?
Thanks,
François,

Re: tOracleConnection : How to create Oracle Wallet connection ?

Anonymous — Wed, 19 Jun 2013 14:44:45 GMT

Hi
First of all, glad to see you have got it works with tJDBCxxx component. For the problem of using context variable as DB parameters, which version are you using? I just do a quick testing to connect to Mysql using context variables on tJDBCInput component with TOS4DI 5.3.0 and it works. What's the error if it does not work?
Shong

Re: tOracleConnection : How to create Oracle Wallet connection ?

Anonymous — Wed, 19 Jun 2013 14:55:35 GMT

Hi Shong,
I'm using TOSDI 5.3.0 too. And, the problem is linked to the post I just done : https://community.talend.com/t5/Design-and-Development/tContextLoad-How-to-load-null-values/td-p/111649
When you use the Oracle Wallet, then login & password fields have to set to NULL (no empty string).
As workaround, I tried using tContextload... but cannot assign key to value NULL
François,

Re: tOracleConnection : How to create Oracle Wallet connection ?

Anonymous — Wed, 19 Jun 2013 15:10:04 GMT

Hi
OK, I understand your problem now, and I have answered you in the new topic.
Shong

Re: tOracleConnection : How to create Oracle Wallet connection ?

Anonymous — Mon, 15 Aug 2016 20:10:17 GMT

Hi,
How do I parameterize tOracleConnection_3 with the location of my Oracle Wallet or is it assumed to be in the Windows Registry? If Windows Registry is the default location, where will it go to find the Wallet once job is deployed to Linux?
Many thanks!
Peter