Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Topic-icon Question Problem w/ Driver MySQL J8

More
10 Jan 2019 16:34 #1 by ari_ocg
Problem w/ Driver MySQL J8 was created by ari_ocg
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
Replied by Thomas BLETON on topic Problem w/ Driver MySQL J8
More
10 Jan 2019 17:39 #3 by ari_ocg
Replied by ari_ocg on 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
Replied by kmanfalouti on 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
Replied by Thomas BLETON on 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
Replied by kmanfalouti on 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
Replied by Thomas BLETON on 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
Replied by kmanfalouti on 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
Replied by Thomas BLETON on 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
Replied by kmanfalouti on 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