Announcement

Collapse

NextGen (Mirth) Connect 3.9.1 Released!

NextGen (Mirth) Connect 3.9.1 is now available as an appliance update and on our GitHub page. This release contains bug fixes and adds support for eHealth Exchange UDDI providers in the Interoperability plugin. See the release notes for the list of fixes and updates.

Download | See What's New | Upgrade Guide | Release Notes

For discussion on this release, see this thread.
See more
See less

MySQL Doubt

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

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

  • #2
    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
    Chris Lang

    Comment


    • #3
      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)

      Comment


      • #4
        Re: MySQL Doubt

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

        Comment


        • #5
          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.

          Comment


          • #6
            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.




            Comment


            • #7
              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 !

              Comment


              • #8
                Re: MySQL Doubt

                Update to version 1.1.0 and the MySQL driver is included.

                -Chris
                Chris Lang

                Comment


                • #9
                  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.

                  Comment

                  Working...
                  X