Four Stars

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

 

talend_driver.PNG

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

Re: Error in connection - Oracle - TAC setup

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

 

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

Re: Error in connection - Oracle - TAC setup

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

 

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

Re: Error in connection - Oracle - TAC setup

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. 

 

Moderator

Re: Error in connection - Oracle - TAC setup

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

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