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

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

 12.1с OK, but 12.2 doesn't without ojdbc8 

https://developer.ibm.com/answers/questions/177075/after-upgrading-to-oracle-12c-database-i-start-ge...

[Anonymous]

Hello,

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

Best regards

Sabrina

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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