Announcement

Collapse

Mirth Connect 3.12.0 Released!

Mirth Connect 3.12.0 is now available as an appliance update and on our GitHub page. This release includes database performance improvements, improves visual HL7 representation, message pruning, keystore handling, PDF generation, community contributions, and fixes several security vulnerabilities. This release also contains many improvements to commercial extensions. 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

How to connect to MySQL server?

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

  • How to connect to MySQL server?

    Hi all,

    I have some data in a mysql database and want to read it (source: database reader) and then have to convert it into HL7 format (destination: file writer).

    There's a default MySQL driver with Mirth and I have tried connecting using various forms of connection URLs (from simplt "localhost:3306" to "jdbc:mysql://localhost:3306/myDB?user=root&password=abc123") but no success.

    The weired thing is, that channel validator doesn't popup any error and channel deploys and runs smoothly BUT does nothing. Even I have tried with wrong values in connection string (url), it still runs silently (but DOES NOTHING).

    Please guide me that How can I connect (successfully) to the mysql server and can fetch the data?

    NOTE: I have tried updating the JDBC driver (latest) from mysql.com but no success (channel behavior is the same).

    Thanks in advance.

  • #2
    Re:How to connect to MySQL server?

    Same problem! Any solution ?

    Comment


    • #3
      Re:How to connect to MySQL server?

      Check that your TCP/IP connection mode is active on your SQL Server (by default, you have only Named Pipes) in SQL Server Configuration Manager (and check @IP and your port number).

      I use the follwing connection string without any problem (SQL Server 2005) :

      var dbConn = DatabaseConnectionFactory.createDatabaseConnection ('net.sourceforge.jtds.jdbc.Driver','jdbc:jtds:sql server://172.20.0.205:1433/MyDataBase','sa','password');

      Comment


      • #4
        Re:How to connect to MySQL server?

        sorry, problem with connection string ...

        Code:
        var dbConn = DatabaseConnectionFactory.createDatabaseConnection('net.sourceforge.jtds.jdbc.Driver','jdbc:jtds:«»sqlserver://172.20.0.205:1433/DataBase','sa','password');

        Comment

        Working...
        X