topic Re: How to add to tOracle Components new oracle driver ojdbc8.jar in Installing and Upgrading

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

Anonymous — Sat, 16 Nov 2024 08:59:08 GMT

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?

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

Anonymous — Mon, 04 Dec 2017 03:45:52 GMT

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

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

Anonymous — Mon, 04 Dec 2017 11:27:17 GMT

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-get.html

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

Anonymous — Wed, 06 Dec 2017 02:39:58 GMT

Hello,

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

Best regards

Sabrina

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

Anonymous — Sat, 09 Dec 2017 09:54:09 GMT

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

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

Anonymous — Tue, 27 Feb 2018 11:50:16 GMT

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

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

Anonymous — Wed, 14 Mar 2018 07:59:30 GMT

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