java.sql.SQLException: No suitable driver

hvupadhye · 2019-06-14 09:34:43

Hello Guys,

I am facing a strange problem when I am connecting to the MySQL database from Community Edition (RS3.0.7-6008 2019-05-06-13-37-55). ReportServer 2 is working fine with the same JDBC URL running on the same server. Both the installed by Bitnami installer. Will you please help me to resolve this issue? Following is exact error message appearing on the screen.

Could not open connection to: jdbc://mysql//<ip>:<port>/db with user: root. java.sql.SQLException: No suitable driver

net.datenwerke.rs.core.service.reportmanager.exceptions.DatabaseConnectionException: Could not open connection to: jdbc://mysql//<ip>:<port>/db with user: root. java.sql.SQLException: No suitable driver
 at net.datenwerke.rs.base.service.datasources.transformers.database.Database2TableTransformer.transform(Database2TableTransformer.java:57)
 at net.datenwerke.rs.base.service.datasources.transformers.database.Database2TableTransformer.transform(Database2TableTransformer.java:1)
 at net.datenwerke.rs.base.service.datasources.transformers.DatasourceTransformationServiceImpl.transform(DatasourceTransformationServiceImpl.java:29)
 at net.datenwerke.rs.base.service.reportengines.table.SimpleDataSupplier.getData(SimpleDataSupplier.java:133)
 at net.datenwerke.rs.base.service.reportengines.table.SimpleDataSupplier.getData(SimpleDataSupplier.java:124)
 at net.datenwerke.rs.base.service.reportengines.table.SimpleDataSupplier.getData(SimpleDataSupplier.java:111)
 at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl.testConnection(DatasourceTesterRPCServiceImpl.java:98)
 at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$a44fcc66.CGLIB$testConnection$0(<generated>)
 at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$a44fcc66$$FastClassByGuice$$23805e16.invoke(<generated>)
 at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:66)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)
 at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$a44fcc66.testConnection(<generated>)
 at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:587)
 at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:333)
 at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$a44fcc66.CGLIB$processCall$3(<generated>)
 at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$a44fcc66$$FastClassByGuice$$23805e16.invoke(<generated>)
 at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)
 at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$a44fcc66.processCall(<generated>)
 at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:303)
 at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$a44fcc66.CGLIB$processCall$4(<generated>)
 at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$a44fcc66$$FastClassByGuice$$23805e16.invoke(<generated>)
 at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)
 at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$a44fcc66.processCall(<generated>)
 at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:373)
 at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
 at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$a44fcc66.CGLIB$service$17(<generated>)
 at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$a44fcc66$$FastClassByGuice$$23805e16.invoke(<generated>)
 at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:109)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)
 at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
 at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)
 at net.datenwerke.rs.adminutils.server.datasourcetester.DatasourceTesterRPCServiceImpl$$EnhancerByGuice$$a44fcc66.service(<generated>)
 at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)
 at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)
 at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
 at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)
 at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:89)
 at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)
 at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
 at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
 at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
 at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)
 at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)
 at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)
 at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
 at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
 at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:836)
 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1747)
 at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
 at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
 at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 at java.base/java.lang.Thread.run(Thread.java:834)
 Caused by: java.lang.RuntimeException: java.sql.SQLException: No suitable driver
 at net.datenwerke.dbpool.DbC3p0PoolServiceImpl$1.get(DbC3p0PoolServiceImpl.java:189)
 at net.datenwerke.dbpool.DbC3p0PoolServiceImpl$1.get(DbC3p0PoolServiceImpl.java:1)
 at net.datenwerke.rs.base.service.datasources.transformers.database.Database2TableTransformer.transform(Database2TableTransformer.java:54)
 ... 91 more
 Caused by: java.sql.SQLException: No suitable driver
 at java.sql/java.sql.DriverManager.getDriver(DriverManager.java:298)
 at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:285)
 at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
 at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
 at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:211)
 at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1127)
 at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1114)
 at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
 at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1855)
 at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

eduardo · 2019-06-14 10:03:33

Hi hvupadhye,

are you sure you mean ReportServer 2 ? Please check the version again.

What version of MySQL are you using and what is the JDBC you use that doesn't work?

Regards,
Eduardo

eduardo · 2019-06-14 10:04:18

Hi hvupadhye,

also check for white spaces before / after the JDBC URL.

Regards,
Eduardo

hvupadhye · 2019-06-14 12:32:39

I am facing a strange problem when I am connecting to the MySQL database from Community Edition (RS3.0.7-6008 2019-05-06-13-37-55). I wanted to tell you, on the same server there is another installation of ReportServer 2.X and it working fine. I am using MySQL 5.7.16 version. I am using the latest JDBC driver which is downloaded on today.

Last edited by hvupadhye (2019-06-14 12:41:56)

eduardo · 2019-06-14 12:35:35

Hi hvupadhye,

please post a screenshot of the ReportServer 2.X ( what is X? ) where it is working.

Please post the JDBC URL that is not working.

Regards,
Eduardo

hvupadhye · 2019-06-14 13:38:32

Not Working: https://ibb.co/7kK8PVv
Working: https://ibb.co/wRygKXy

eduardo · 2019-06-14 13:43:04

Hi hvupadhye,

in the error message I see:
Could not open connection to: jdbc://mysql//<ip>:<port>/db with user: root. java.sql.SQLException: No suitable driver

But jdbc://mysql//<ip>:<port>/db is not the JDBC URL you wrote.
Can you please make sure that you clicked on the "Apply" button before you click on the "Test connection" Button ?

Regards,
Eduardo

hvupadhye · 2019-06-14 13:49:32

I edited the error and hide the IP details of my server. Please see https://ibb.co/wJ1tSFs image for details. Yes, I am sure that I clicked on apply button before test connection.

Last edited by hvupadhye (2019-06-14 13:51:14)

eduardo · 2019-06-14 13:57:59

Hi hvupadhye,

the correct URL for mysql should start with: jdbc:mysql://

And *not* with jdbc://mysql:// as in your screenshot. Please change the URL.
The correct URL is also in the screenshot that is working. So you don't have the exact URLs in both cases.

Regards,
Eduardo

hvupadhye · 2019-06-14 14:44:33

Sorry for stupid mistake and thank you for the patient support. I really appreciate. It is working now. I am laughing at myself. In future, I will be very careful and try to be sure before posting issue on forum.

Last edited by hvupadhye (2019-06-14 14:50:02)

eduardo · 2019-06-14 15:29:58

Hi hvupadhye,

no worries!

Regards,
Eduardo

marktoddy · 2021-06-21 06:48:32

The reason you got this error is because you forgot to register your java mysql jdbc driver with the application.

Should be like this:

Class.forName("com.mysql.jdbc.Driver");

This forces the driver to register itself, so that Java knows how to handle those database connection strings.

You'll have to read the manual on your specific mysql jdbc driver to find the exact string to place inside the the Class.forName("...") parameter.

ReportServer Forum

#1 2019-06-14 09:34:43

java.sql.SQLException: No suitable driver

#2 2019-06-14 10:03:33

Re: java.sql.SQLException: No suitable driver

#3 2019-06-14 10:04:18

Re: java.sql.SQLException: No suitable driver

#4 2019-06-14 12:32:39

Re: java.sql.SQLException: No suitable driver

#5 2019-06-14 12:35:35

Re: java.sql.SQLException: No suitable driver

#6 2019-06-14 13:38:32

Re: java.sql.SQLException: No suitable driver

#7 2019-06-14 13:43:04

Re: java.sql.SQLException: No suitable driver

#8 2019-06-14 13:49:32

Re: java.sql.SQLException: No suitable driver

#9 2019-06-14 13:57:59

Re: java.sql.SQLException: No suitable driver

#10 2019-06-14 14:44:33

Re: java.sql.SQLException: No suitable driver

#11 2019-06-14 15:29:58

Re: java.sql.SQLException: No suitable driver

#12 2021-06-21 06:48:32

Re: java.sql.SQLException: No suitable driver

Board footer