Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Due to some maintenance operations, stambia.org will be switched to read-only mode during the 13th November. It will be possible to read and download, but impossible to post on the forums or create new accounts. For any question please contact the support team.

Topic-icon Question Problem w/ Driver MySQL J8

More
10 Jan 2019 16:34 #1 by ari_ocg
ari_ocg created the topic: Problem w/ Driver MySQL J8
im trying to install the driver for MySQL but
i have the next error
"The JDBC driver class cannot be loaded, you should edit the driver and fix the problem."

can someone help me?

im using the next jar file:
-mysql-connector-java-8.0.13
More
10 Jan 2019 16:41 #2 by Thomas BLETON
Thomas BLETON replied the topic: Problem w/ Driver MySQL J8
More
10 Jan 2019 17:39 #3 by ari_ocg
ari_ocg replied the topic: Problem w/ Driver MySQL J8
++¡SOLUTION!++

stambia show me the error message in the image below

this happens because the jar file is not in the right path

Stambia/runtime/lib

if you change your jar file into this path all going right

pd1* don't forget make again all the process of creation for the driver
pd2* don't forget restart your enviroment and your stambia designer
Attachments:
More
24 Apr 2019 15:49 #4 by kmanfalouti
kmanfalouti replied the topic: Problem w/ Driver MySQL J8
Bonjour,

J'arrive pas a résoudre le problème de javaExceptionNotFound....

Mysql Version 8.0.15
Mysql Connector 8.0.14 ==> \stambiaRuntime\lib\jdbc

Error :

java.sql.SQLException: SQL Exception
at com.indy.engine.main.connections.b.b(SourceFile:254)
at com.indy.engine.main.connections.b.a(SourceFile:321)
at com.indy.engine.main.connections.JDBCConnectionContainerI.<init>(SourceFile:40)
at com.indy.engine.action.common.ActionCodeTypeI.setConnection(SourceFile:384)
at com.indy.engine.actionCodes.JdbcActionCodeI.executeDDL_DML(SourceFile:848)
at com.indy.engine.actionCodes.JdbcActionCodeI.executeSimpleCode(SourceFile:1427)
at com.indy.engine.action.common.ActionCodeTypeI.executeCode(SourceFile:1521)
at com.indy.engine.action.common.ActionCodeTypeI.run(SourceFile:1666)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
at com.indy.runtime.jdbc.JdbcDataSource.connectWithStandardJdbc(JdbcDataSource.java:126)
at com.indy.runtime.jdbc.JdbcDataSource.getConnection(JdbcDataSource.java:440)
at com.indy.runtime.jdbc.JdbcDataSource.getConnection(JdbcDataSource.java:109)
at com.indy.engine.main.connections.c.<init>(SourceFile:22)
at com.indy.engine.main.connections.b.b(SourceFile:244)
... 8 more
Caused by: java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at com.indy.runtime.jdbc.JdbcDataSource.connectWithStandardJdbc(JdbcDataSource.java:124)
... 12 more
Attachments:
More
24 Apr 2019 15:57 #5 by Thomas BLETON
Thomas BLETON replied the topic: Problem w/ Driver MySQL J8
Hello
Did you restart the Runtime after installing Mysql's jar file into the lib/jdbc folder ?
More
24 Apr 2019 16:12 #6 by kmanfalouti
kmanfalouti replied the topic: Problem w/ Driver MySQL J8
each time I click on stop runtime and start runtime and tick off/ON the connect button.
Question: how can I restart the runtime?
Attachments:
More
24 Apr 2019 16:19 #7 by Thomas BLETON
Thomas BLETON replied the topic: Problem w/ Driver MySQL J8
Maybe the Runtime is already started as a Windows Service ? In this case, restart the Windows service.
More
24 Apr 2019 16:38 #8 by kmanfalouti
kmanfalouti replied the topic: Problem w/ Driver MySQL J8
I can have the windows service name of stambia :)
More
24 Apr 2019 16:44 #9 by Thomas BLETON
Thomas BLETON replied the topic: Problem w/ Driver MySQL J8
I was thinking of a Windows service because your Designer is connected to the Runtime "localhost:42000" but there is apparently no Console (windows command line) window in your task bar.
If someone installed the Runtime as a Service they may have specified a service name of their choice. If they did not specify the name then the default is "Stambia Runtime".
More
24 Apr 2019 17:00 #10 by kmanfalouti
kmanfalouti replied the topic: Problem w/ Driver MySQL J8
it's OK now
download the connector from the mysql site: downloads.mysql.com/archives/c-j/

put the connector at the folder StambiaRuntime / lib / jdbc

go to stambia level designer> windows> preference> SQL explorer> jdbc

search Mysql jdbc> Edit> extra path
add the connector
URL: jdbc: mysql: // localhost: 3306 / NAMEDATABASE? UseUnicode = true & useJDBCCompliantTimezoneShift = true & useLegacyDatetimeCode = false & serverTimezone = UTC

restart the runtime