Eclipse Community Forums: Eclipse Scout » Error java.sql.SQLException: No suitable driver found for jdbc:mysql:XXXXXXXXXXXX

Home » Eclipse Projects » Eclipse Scout » Error java.sql.SQLException: No suitable driver found for jdbc:mysql:XXXXXXXXXXXX (After upgrade to scout 11)

Show: Today's Messages :: Show Polls :: Message Navigator

Error java.sql.SQLException: No suitable driver found for jdbc:mysql:XXXXXXXXXXXX [message #1839856]

Tue, 30 March 2021 10:36

Eclipse User

Hello,
I have the following error after upgrading to scout 11 on prod.

org.eclipse.scout.rt.platform.exception.BeanCreationException: Exception while invoking @PostConstruct method public void com.scout.app.server.db.sql.DatabaseSetupService.autoCreateDatabase() throws java.sql.SQLException
        at org.eclipse.scout.rt.platform.internal.BeanInstanceUtil.translateException(BeanInstanceUtil.java:171)
        at org.eclipse.scout.rt.platform.internal.BeanInstanceUtil.initializeBeanInstance(BeanInstanceUtil.java:106)
        at org.eclipse.scout.rt.platform.internal.BeanInstanceUtil.initializeBeanInstance(BeanInstanceUtil.java:77)
        at org.eclipse.scout.rt.platform.internal.SingeltonBeanInstanceProducer.createInstance(SingeltonBeanInstanceProducer.java:236)
        at org.eclipse.scout.rt.platform.internal.SingeltonBeanInstanceProducer.getOrCreateInstance(SingeltonBeanInstanceProducer.java:112)
        at org.eclipse.scout.rt.platform.internal.SingeltonBeanInstanceProducer.lambda$0(SingeltonBeanInstanceProducer.java:95)
        at org.eclipse.scout.rt.platform.internal.BeanInstanceUtil.createAndAssertNoCircularDependency(BeanInstanceUtil.java:149)
        at org.eclipse.scout.rt.platform.internal.SingeltonBeanInstanceProducer.produce(SingeltonBeanInstanceProducer.java:95)
        at org.eclipse.scout.rt.platform.internal.BeanImplementor.getInstance(BeanImplementor.java:98)
        at org.eclipse.scout.rt.platform.internal.BeanManagerImplementor.startCreateImmediatelyBeans(BeanManagerImplementor.java:338)
        at org.eclipse.scout.rt.platform.internal.PlatformImplementor.startCreateImmediatelyBeans(PlatformImplementor.java:242)
        at org.eclipse.scout.rt.platform.internal.PlatformImplementor.start(PlatformImplementor.java:141)
        at org.eclipse.scout.rt.platform.internal.PlatformStarter.run(PlatformStarter.java:30)
Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql:XXXXXXXXXXXX
        at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:702)
        at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:251)
        at com.scout.app.server.db.sql.DatabaseSetupService.autoCreateDatabase(DatabaseSetupService.java:66)
        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 org.eclipse.scout.rt.platform.internal.BeanInstanceUtil.initializeBeanInstance(BeanInstanceUtil.java:103)
        ... 11 common frames omitted

This is not happening on dev environment, only when deploying to tomcat.
Database for dev is same used with tomcat and they are on same machine.
Does anyone have any idea how to solve this issue.
Kind Regards

Report message to a moderator

Re: Error java.sql.SQLException: No suitable driver found for jdbc:mysql:XXXXXXXXXXXX [message #1839871 is a reply to message #1839856]

Tue, 30 March 2021 16:27

Eclipse User

Sounds to me if the JDBC driver cannot be found for MySQL. Scout itself does not provide any dependencies to the database drivers because people may use different databases. If you add the MySQL driver as dependency (to the class path) this may help, e.g.

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.23</version>
</dependency>

Report message to a moderator

Re: Error java.sql.SQLException: No suitable driver found for jdbc:mysql:XXXXXXXXXXXX [message #1839878 is a reply to message #1839871]

Tue, 30 March 2021 19:05

Eclipse User

Hello,
No, that is not the problem, the application was working fine with version 10 and the driver exists like you mentioned, I noticed the issue after upgrading to 11.
Kind Regards

Report message to a moderator

Re: Error java.sql.SQLException: No suitable driver found for jdbc:mysql:XXXXXXXXXXXX [message #1839941 is a reply to message #1839878]

Thu, 01 April 2021 14:49

Eclipse User

Hello,
I solved the issue by adding
Class.forName("com.mysql.cj.jdbc.Driver");
to the DatabaseSetupService just before calling the driver to establish the connection and it works now.
Kind Regards

Report message to a moderator

Re: Error java.sql.SQLException: No suitable driver found for jdbc:mysql:XXXXXXXXXXXX [message #1839943 is a reply to message #1839941]

Thu, 01 April 2021 15:25

Eclipse User

Thanks for posting your solution here!

André

Report message to a moderator

Previous Topic:	JS - Java questions
Next Topic:	REST Client: fetching data and populating a table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 08:50:05 GMT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter