0

I kind a need some help with an error I get when trying to connect to a mysql database as custom database from the database replication module. I followed the following instruction to try to connect to a mysql database. But I get the following error: No suitable driver found for jdbc:mysql://localhost:3306/test The test database on localhost exists and can be reached. I also copied the mysql-connector-java-5.1.37-bin.jar file in de userlib directory and followed all other instructions as stated below. Copied the text from: Original question Install and configure MxModelReflection and DatabaseReplication modules first. You need the JDBC driver. It is included in the MySQL installation: c:\Program Files (x86)\MySQL\Connector.J 5.1\mysql-connector-java-5.1.33-bin.jar Of course, version numbers may differ from this example. Copy the JAR to the userlib folder of your Mendix project. To configure the database: Database type: custom user ID / password as configured in the database Connection string: jdbc:mysql://<server>:<port>/<schema> Driver class: com.mysql.jdbc.Driver Escape characters: back tick ` You can check the escape options that are necessary for proper functioning.I left Escape the schema and table name separately unchecked. Save Sync the database Now you can create mappings as described in the documentation.** com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: replication.ReplicationSettings$MendixReplicationException: Could not connect with the database at location: jdbc:mysql://localhost:3306/test at com.mendix.core.component.InternalCore.execute(InternalCore.java:394) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: replication.ReplicationSettings$MendixReplicationException: Could not connect with the database at location: jdbc:mysql://localhost:3306/test at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:198) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: replication.ReplicationSettings$MendixReplicationException: Could not connect with the database at location: jdbc:mysql://localhost:3306/test at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36) Caused by: replication.ReplicationSettings$MendixReplicationException: Could not connect with the database at location: jdbc:mysql://localhost:3306/test at databasereplication.implementation.DatabaseConnector.connect(DatabaseConnector.java:82) Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/test at java.sql.DriverManager.getConnection(DriverManager.java:604) at java.sql.DriverManager.getConnection(DriverManager.java:221) at databasereplication.implementation.DatabaseConnector.connect(DatabaseConnector.java:64) at databasereplication.implementation.DbReader.CustomReader.processDatabase(CustomReader.java:37) at databasereplication.actions.SyncDatabaseInfo.executeAction(SyncDatabaseInfo.java:72) at databasereplication.actions.SyncDatabaseInfo.executeAction(SyncDatabaseInfo.java:1) at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:49) at com.mendix.core.actionmanagement.CoreAction.doCall(CoreAction.java:260) at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:248) at com.mendix.core.actionmanagement.ActionManager$1.execute(ActionManager.java:188) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:194) at com.mendix.core.component.InternalCore.execute(InternalCore.java:386) at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:52) at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:47) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:192) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:149) at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:49) at com.mendix.core.actionmanagement.CoreAction.doCall(CoreAction.java:260) at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:248) at com.mendix.core.actionmanagement.CustomActionMonitorImpl$$anonfun$run$1.apply(CustomMonitoredAction.scala:14) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2$$anon$1.execute(ActionDispatching.scala:145) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2.apply(ActionDispatching.scala:147) at scala.util.Try$.apply(Try.scala:191) at com.mendix.core.session.Worker$$anonfun$receive$3.applyOrElse(ActionDispatching.scala:141) at akka.actor.Actor$class.aroundReceive(Actor.scala:465) at com.mendix.core.session.Worker.aroundReceive(ActionDispatching.scala:137) at akka.actor.ActorCell.receiveMessage(ActorCell.scala:516) at akka.actor.ActorCell.invoke(ActorCell.scala:487) at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:238) at akka.dispatch.Mailbox.run(Mailbox.scala:220) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393) at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)

asked 2015-11-24

0 answers