# Clover server db connection problem

**URL:** <https://forum.cloverdx.com/t/clover-server-db-connection-problem/861>\
**Category:** CloverDX Platform\
**Created:** [June 2, 2011, 12:00am UTC](https://forum.cloverdx.com/t/clover-server-db-connection-problem/861 "2011-06-02T00:00:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![kasturi](https://avatars.discourse-cdn.com/v4/letter/k/a698b9/32.png) [@kasturi](https://forum.cloverdx.com/u/kasturi)\
**Post date:** [June 2, 2011, 12:00am UTC](https://forum.cloverdx.com/t/clover-server-db-connection-problem/861/1 "2011-06-02T00:00:00Z")

</div>

I am trying to run graphs from Clover server and getting this error message:

’ can;t initialize connection DBConnection driver[null]:jndi:url[jdbc:mysql://the server:port /database name]:user[username].

I can validate DBInputTable and view data . DBInput table is using the same Mysql database connection. What is missing when I run the graph?  
Any help on this will be greatly appreciated.

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [June 3, 2011, 9:33am UTC](https://forum.cloverdx.com/t/clover-server-db-connection-problem/861/2 "2011-06-03T09:33:24Z")

</div>

Please send the full stack trace and the version of CloverETL you use. I suspect, that it can be problem with jdbc driver (is in your Designer class path, but isn’t in Server class path).

---

<div class="post-metadata">

**Author:** ![kasturi](https://avatars.discourse-cdn.com/v4/letter/k/a698b9/32.png) [@kasturi](https://forum.cloverdx.com/u/kasturi)\
**Post date:** [June 3, 2011, 8:08pm UTC](https://forum.cloverdx.com/t/clover-server-db-connection-problem/861/3 "2011-06-03T20:08:22Z")

</div>

Is this what you are looking for?

I have clover designer: 3.0.2

Thanks for your help.

Can’t initialize connection DBConnection driver[null]:jndi:url[jdbc:mysql://dc1-ecomdb02.mypublisher.com:3306/ecommerce]:user[mypub].

detail  
Element [1306242923071:emails\_new]-Can’t initialize connection DBConnection driver[null]:jndi:url[jdbc:mysql://dc1-ecomdb02.mypublisher.com:3306/ecommerce]:user[mypub].  
at org.jetel.graph.TransformationGraph.init(TransformationGraph.java:402)  
at org.jetel.graph.runtime.EngineInitializer.initGraph(EngineInitializer.java:176)  
at com.cloveretl.server.b.k.b(Unknown Source)  
at com.cloveretl.server.b.k.a(Unknown Source)  
at com.cloveretl.server.b.k.executeGraph(Unknown Source)  
at com.cloveretl.server.b.c.executeGraph(Unknown Source)  
at com.cloveretl.server.facade.a.a.executeGraph(Unknown Source)  
at com.cloveretl.server.web.gui.k.actionRunGraph(Unknown Source)  
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)  
at java.lang.reflect.Method.invoke(Method.java:597)  
at org.apache.el.parser.AstValue.invoke(AstValue.java:191)  
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)  
at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)  
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)  
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)  
at javax.faces.component.UICommand.broadcast(UICommand.java:387)  
at org.ajax4jsf.component.AjaxActionComponent.broadcast(AjaxActionComponent.java:55)  
at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:324)  
at org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:299)  
at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:256)  
at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:469)  
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)  
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)  
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)  
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:178)  
at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)  
at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:388)  
at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:515)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.mortbay.servlet.UserAgentFilter.doFilter(UserAgentFilter.java:81)  
at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter.java:132)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:83)  
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)  
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)  
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)  
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)  
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)  
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)  
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)  
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)  
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)  
at java.lang.Thread.run(Thread.java:662)  
Caused by: Cannot create JDBC driver ‘MySQL’. Can not find class: org.gjt.mm.mysql.Driver  
at org.jetel.connection.jdbc.driver.JdbcDriver.prepareDriver(JdbcDriver.java:179)  
at org.jetel.connection.jdbc.driver.JdbcDriver.(JdbcDriver.java:118)  
at org.jetel.connection.jdbc.driver.JdbcDriver.(JdbcDriver.java:92)  
at org.jetel.connection.jdbc.driver.JdbcDriver.createInstance(JdbcDriver.java:232)  
at org.jetel.connection.jdbc.driver.JdbcDriverDescription.createJdbcDriver(JdbcDriverDescription.java:181)  
at org.jetel.connection.jdbc.DBConnection.prepareJdbcDriver(DBConnection.java:437)  
at org.jetel.connection.jdbc.DBConnection.init(DBConnection.java:405)  
at org.jetel.graph.TransformationGraph.init(TransformationGraph.java:399)  
… 52 more  
Caused by: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver  
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1680)  
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1526)  
at org.jetel.util.classloader.GreedyURLClassLoader.loadClass(GreedyURLClassLoader.java:66)  
at java.lang.ClassLoader.loadClass(ClassLoader.java:248)  
at java.lang.Class.forName0(Native Method)  
at java.lang.Class.forName(Class.java:247)  
at org.jetel.connection.jdbc.driver.JdbcDriver.prepareDriver(JdbcDriver.java:177)  
… 59 more

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [June 6, 2011, 11:30am UTC](https://forum.cloverdx.com/t/clover-server-db-connection-problem/861/4 "2011-06-06T11:30:31Z")

</div>

Hello,  
unfortunately CloverETL Server 3.0.2 doesn’t contain any jdbc drivers. You need to download ([http://dev.mysql.com/downloads/connector/j/](http://dev.mysql.com/downloads/connector/j/)) or copy from your CloverETL Designer, mysql jdbc driver (_mysql-connector-java-5.1.XX-bin.jar_) to the folder, that is on the application server class path (in case of Apache Tomcat it is _\<path\_to\_tomcat\_home\_directory\>/lib_).

---

<div class="post-metadata">

**Author:** ![kasturi](https://avatars.discourse-cdn.com/v4/letter/k/a698b9/32.png) [@kasturi](https://forum.cloverdx.com/u/kasturi)\
**Post date:** [June 7, 2011, 5:12pm UTC](https://forum.cloverdx.com/t/clover-server-db-connection-problem/861/5 "2011-06-07T17:12:41Z")

</div>

Thank you. We have added the file to the correct path and the connection is okay now.
