Update jdbc version in talend

Four Stars

Update jdbc version in talend


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


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


Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.