Announcement

Collapse
No announcement yet.

MySQL Doubt

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • mrslatezb
    replied
    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.

    Leave a comment:


  • chrisl
    replied
    Re: MySQL Doubt

    Update to version 1.1.0 and the MySQL driver is included.

    -Chris

    Leave a comment:


  • mrslatezb
    replied
    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 !

    Leave a comment:


  • pitchfork
    replied
    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.




    Leave a comment:


  • mrslatezb
    replied
    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.

    Leave a comment:


  • pitchfork
    replied
    Re: MySQL Doubt

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

    Leave a comment:


  • pitchfork
    replied
    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)

    Leave a comment:


  • chrisl
    replied
    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

    Leave a comment:


  • pitchfork
    started a topic MySQL Doubt

    MySQL Doubt

    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!
Working...
X