Announcement

Collapse
No announcement yet.

FireBird Driver trouble With Mirth 2.0.1

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

  • FireBird Driver trouble With Mirth 2.0.1

    Hi All
    I have juste install the new version of Mirth
    and i have follow the instruction found here
    "Mirth Connect 1.8 to 2.0 Upgrade Guide"

    Before the upgrade I weas ebale to update My FireBird table but after i got this message.

    Code:
    889: var resultId = dbConn.executeCachedQuery("select gen_id(GEN_MSH_ENTETE_ID,1) from rdb$database");
    890: var gIdMessagekey = 0;
    LINE NUMBER:	886
    DETAILS:	Wrapped java.sql.SQLException: No suitable driver found for jdbc:firebirdsql:127.0.0.1:C:\Client\Demo-Labo\MEDICAL.FDB

    Any tips ?

  • #2
    Do you have the FireBird driver .jar file in the $MIRTH_HOME/custom-lib directory?
    Gerald Bortis | Chief Information Officer | Mirth Corporation

    Comment


    • #3
      Yes
      I have all the drivers that was in the old $Mirth_HOME/LIB/CUSTOM

      Can it be something in the dbdrivers.xml

      I have add this line in it
      Code:
          <driver class="org.firebirdsql.jdbc.FBDriver" name="firebird" template="jdbc:firebirdsql:127.0.0.1:C:\\Client\\Demo-Labo\\MEDICAL.FDB" />

      Comment


      • #4
        Just to add some information I have made this test in a channel
        Code:
        globalMap.put("FbDriver",'org.firebirdsql.jdbc.FBDriver');
        globalMap.put("FbUrl",'jdbc:firebirdsql:127.0.0.1:C:\\Client\\Demo-Labo\\MEDICAL.FDB');
        globalMap.put("FbUsername",'XXXXXXX');
        globalMap.put("FbPw",'YYYYYY');
        
        var dbConn = DatabaseConnectionFactory.createDatabaseConnection(globalMap.get('FbDriver'),globalMap.get('FbUrl'),globalMap.get('FbUsername'),globalMap.get('FbPw'));
        This is the code i use in a master channel execption on the DatabaseConnection

        When i deploy the channel i got this error message
        Code:
        2011-03-21 15:05:47,616]  ERROR (Server Error:146): java.lang.ClassNotFoundException: org.firebirdsql.jdbc.FBDriver
        TIA for your help
        Benoit

        Comment


        • #5
          Again just to add information on the subject

          I have uninstall the version 2 reinstall it except that I did not copy my old mirthdb.
          after i have retored my last server configuration.
          Guess what Everything works

          Ideas anyone ?

          Comment

          Working...
          X