Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Error in connection - Oracle - TAC setup

Hi, 

 

I'm getting stuck with installing database drivers in my Web application server.

 

I keep on getting - Cannot connect to database (Could not initialize class oracle.jdbc.driver.DMSFactory) on the connection test. 

 

I've already put the ojdbc6dms.jar and ojdbc6dms_g.jar in <apache-tomcat>/lib but still not working. Has anyone encountered this before? 

im using Oracle 11g

 

0683p000009LzIB.png

 

 

 

Labels (3)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hello,

Please make sure you have the correct JDBC driver for your Oracle  11 installed for TAC/Tomcat (in the /endorsed/ or /lib/ folder).

Is your Oracle 11g connection Ok with you in studio?

Best regards

Sabrina

 

View solution in original post

4 Replies
Anonymous
Not applicable
Author

Hello,

Please make sure you have the correct JDBC driver for your Oracle  11 installed for TAC/Tomcat (in the /endorsed/ or /lib/ folder).

Is your Oracle 11g connection Ok with you in studio?

Best regards

Sabrina

 

Anonymous
Not applicable
Author

Thanks xdshi! it worked, only that i need to put the jar files into both. I did have successful Connection check but i got this error in the Version check part - 

500 The call failed on the server; see server log for details

 

when i checked the logs, it says 

18-Jul-2018 01:07:50.745 SEVERE [http-nio-8080-exec-6] org.apache.catalina.core.ApplicationContext.log Exception while dispatching incoming RPC call
com.google.gwt.user.server.rpc.UnexpectedException: Service method 'public abstract void org.talend.gwttoolkit.client.login.service.LoginService.checkLicenseKey(boolean) throws org.talend.gwttoolkit.client.exception.ClientBusinessException,org.talend.gwttoolkit.client.exception.ClientSystemException' threw an unexpected exception: java.lang.IllegalStateException: Unknown database schema version
at com.google.gwt.user.server.rpc.RPC.encodeResponseForFailure(RPC.java:415)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:605)

 

I chose Oracle 11g and the jars are ojdbc6.jar, ojdbc6dms.jar, ojdbc6_g.jar and ojdbc6dms_g.jar. 

 

I saw a post related to this, but it doesn't have any answer. 

 

Hope you can advise. 

 

Anonymous
Not applicable
Author

Hello,

Would you mind create a case on talend support portal so that we can give you a remote assistance(webex session) through support cycle with priority?

Best regards

Sabrina

Anonymous
Not applicable
Author

For Apache Tomcat 8.0, put the JDBC drivers in the <apache-tomcat>/endorsed path. For Apache Tomcat 8.5, you need to put the JDBC drivers in the <apache-tomcat>/lib path. For more information, see Installing database drivers in your Web application server, on the Talend Help Center.