MySQL Doubt

[pitchfork]

Hi again,

I am trying to connect Mirth with an external MySQL Database (inbound).

In the "destination" tab I fill in the fields with these values:

Connector Type: Database Writer
Driver: MySQL
Database URL: jdbc:mysql://server-ip/test
Username and password

Is there something wrong with this configuration? I cannot insert a single value in the database table.

Thank you very much!

[chrisl]

Re: MySQL Doubt

I need to see the full channel and any errors you are getting to figure out where you might have problems. The database URL looks fine. Check your mirth.log for errors, and paste anything that's related to the JDBC writer.

-Chris

[pitchfork]

Re: MySQL Doubt

Hi,

I have read in another thread that maybe is not availabe the mysql driver yet??Mith MS SQL Server works fine. Although my primary goal is to connect Mirth to an Informix Database. If anyone knows how to do it I would be very grateful.

Thanks very much.

This is what I get in the log file.

ERROR [4_destination_4.dispatcher.1] org.mule.impl.DefaultExceptionStrategy: Caught exception in Exception Strategy: com.mysql.jdbc.Driver
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.mule.providers.jdbc.JdbcConnector.getConnectio n(JdbcConnector.java:361)
at org.mule.providers.jdbc.JdbcMessageDispatcher.doDi spatch(JdbcMessageDispatcher.java:93)
at org.mule.providers.AbstractMessageDispatcher$Worke r.run(AbstractMessageDispatcher.java:257)
at org.mule.impl.work.WorkerContext.run(WorkerContext .java:290)
at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.runTask(ThreadPoolExecutor. java:650)
at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.run(ThreadPoolExecutor.java :675)
at java.lang.Thread.run(Unknown Source)

[pitchfork]

Re: MySQL Doubt

Ok, I solved it just adding the mysql driver that was missing.

[mrslatezb]

Re: MySQL Doubt

I get the same message when I try to connect via MySQL. Is there anyway you can provide instructions on how you readded the driver because I still can't get my connection to work using the same methods described here. I did add the old mysql drivers to the lib/dbdrivers folder but it hasnt fixed the problem. I get the exact same error messages as Pitchfork.

[pitchfork]

Re: MySQL Doubt

I added this file version to the \mirth\lib\dbdrivers folder: mysql-connector-java-3.1.13-bin.jar

It should fix the problem.

[mrslatezb]

Re: MySQL Doubt

Thanks for the help now that error has went away. But iget the No Suitable Driver error now. I guess i have to figure out what I am missing now !

[chrisl]

Re: MySQL Doubt

Update to version 1.1.0 and the MySQL driver is included.

-Chris

[mrslatezb]

Re: MySQL Doubt

Thanks for the help. I actually just to uninstall completely and reinstall and then copy the mysql driver into place. I didnt get a chance to download the updated 1.1.0. Everything works great, this program is fantastic! Thanks Chris.