Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Update jdbc version in talend

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)

Labels (2)
1 Reply
Anonymous
Not applicable
Author

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