web stats
FireBird Driver trouble With Mirth 2.0.1 - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 03-21-2011, 09:10 AM
Benzo Benzo is offline
OBX.1 Kenobi
 
Join Date: May 2010
Location: Québec Canada
Posts: 35
Benzo is on a distinguished road
Default 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 ?
Reply With Quote
  #2  
Old 03-21-2011, 09:38 AM
geraldb geraldb is offline
Mirth Employee
 
Join Date: Aug 2006
Location: Irvine, CA
Posts: 314
geraldb is an unknown quantity at this point
Default

Do you have the FireBird driver .jar file in the $MIRTH_HOME/custom-lib directory?
__________________
Gerald Bortis | Chief Information Officer | Mirth Corporation
Reply With Quote
  #3  
Old 03-21-2011, 10:56 AM
Benzo Benzo is offline
OBX.1 Kenobi
 
Join Date: May 2010
Location: Québec Canada
Posts: 35
Benzo is on a distinguished road
Default

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" />
Reply With Quote
  #4  
Old 03-21-2011, 12:15 PM
Benzo Benzo is offline
OBX.1 Kenobi
 
Join Date: May 2010
Location: Québec Canada
Posts: 35
Benzo is on a distinguished road
Post

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
Reply With Quote
  #5  
Old 03-22-2011, 10:51 AM
Benzo Benzo is offline
OBX.1 Kenobi
 
Join Date: May 2010
Location: Québec Canada
Posts: 35
Benzo is on a distinguished road
Default

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 ?
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 06:27 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation