Update jdbc version in talend

Anonymous — Sat, 16 Nov 2024 08:32:00 GMT

Hi,

Currently, I am using licensed talend version 6.1. When I generate war file using talend it creates ojdbc6.jar in /WEB-INF/lib folder. I want it to be ojdbc7.jar. What are the changes required to achieve it. I tried installing ojdbc7.jar using module option even then generated war file contains ojdbc6.jar. Please find attached the modules snapshot.

I need to do this upgrade to suppress the following message in catalina.out in tomcat8:

08-Feb-2018 10:01:43.586 SEVERE [http-nio-49000-exec-2] oracle.jdbc.driver.OracleDriver.registerMBeans Error while registering Oracle JDBC Diagnosability MBean.

javax.management.MalformedObjectNameException: Invalid character '\n' in value part of property

at javax.management.ObjectName.construct(ObjectName.java:618)

at javax.management.ObjectName.<init>(ObjectName.java:1382)

at oracle.jdbc.driver.OracleDriver.registerMBeans(OracleDriver.java:303)

at oracle.jdbc.driver.OracleDriver$1.run(OracleDriver.java:213)

at java.security.AccessController.doPrivileged(Native Method)

at oracle.jdbc.driver.OracleDriver.<clinit>(OracleDriver.java:209)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:348)

at java.sql.DriverManager.isDriverAllowed(DriverManager.java:556)

at java.sql.DriverManager.getConnection(DriverManager.java:661)

at java.sql.DriverManager.getConnection(DriverManager.java:247)

Re: Update jdbc version in talend

Anonymous — Wed, 21 Mar 2018 07:54:19 GMT

Hello,

Could you please follows these steps to update your jar file?
1) Make a backup of your ojdbc6.jar (ojdbc6.jar.orig)

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

3) Rebuild/Re-run job

Let us know if it works.

Best regards

Sabrina

topic Update jdbc version in talend in Installing and Upgrading

Update jdbc version in talend

Re: Update jdbc version in talend