How to add to tOracle Components new oracle driver ojdbc8.jar

Five Stars

How to add to tOracle Components new oracle driver ojdbc8.jar

Hi all

Our admins have migrated Oracle databases to 12.2c required ojdbc8.jar to JAVA client connection.

Components out of the box Talend 6.4 used ojdbc7 maximum, if I select 12-7 DB version in component property.

Are there new tOracle components supported 12.2 and ojdbc8?

How to add into connection component new oracle version supporting?

How to assiciate ojdbc8 driver with connection component?

Moderator

Re: How to add to tOracle Components new oracle driver ojdbc8.jar

Hello,

Here is online document about:TalendHelpCenter: Supported systems, databases and business applications by Talend components

So far, talend support for oracle 12 c.

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.
Five Stars

Re: How to add to tOracle Components new oracle driver ojdbc8.jar

Moderator

Re: How to add to tOracle Components new oracle driver ojdbc8.jar

Hello,

Feel free to create a new feature jira issue on Talend Bug Tracker.

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

Re: How to add to tOracle Components new oracle driver ojdbc8.jar

Not ideal, but should work:

 

1) Make a backup of your ojdbc7.jar (ojdbc7.jar.orig)

2) Rename you ojdbc8.jar to ojdbc7.jar within Studio

3) Rebuild/Re-run job

 

One Star

Re: How to add to tOracle Components new oracle driver ojdbc8.jar

Hi,

 

I've tried to replace /workspace/.Java/lib/ojdbc7.jar with ojdbc8.jar and rebuild job but same error

 

 
[statistics] connecting to socket on port 4044
[statistics] connected
Exception in thread "main" java.lang.Error: Incompatible version of libocijdbc[Jdbc:121010, Jdbc-OCI:122010
	at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:4094)
	at java.security.AccessController.doPrivileged(Native Method)
	at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:4087)
	at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:301)
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:715)
	at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:195)
	at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:51)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:247)
	at provescloud.prova_cloud_0_1.prova_cloud.tOracleConnection_1Process(prova_cloud.java:344)
	at provescloud.prova_cloud_0_1.prova_cloud.runJobInTOS(prova_cloud.java:621)
	at provescloud.prova_cloud_0_1.prova_cloud.main(prova_cloud.java:470)
[statistics] disconnected
Job prova_cloud ended at 12:39 27/02/2018. [exit code=1]

Furthermore, when we close studio and launch it back it restores ojdbc7.jar file... should I modify it anywhere else?

thanks

 
Moderator

Re: How to add to tOracle Components new oracle driver ojdbc8.jar

Hello,

You need to rename you ojdbc8.jar to ojdbc7.jar first and then install your new ojdbc7.jar (renamed ojdbc8.jar) into studio manully.

The simplest solution is : Window -> Show View -> Talend -> Modules -> Click the white bottle / jar and pick-up  new ojdbc7.jar (renamed ojdbc8.jar) on your hard drive.

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.