web stats
NoClassDefFound error jt400 drivers using DatabaseConnectionFactory or DatabaseRead - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 06-29-2019, 05:14 AM
AjayN AjayN is offline
What's HL7?
 
Join Date: May 2014
Posts: 3
AjayN is on a distinguished road
Default NoClassDefFound error jt400 drivers using DatabaseConnectionFactory or DatabaseRead

We recently started using Mirth version 3.7.1 with Amazon corretto openjdk11.
We want to connect to DB2 using either a Database reader or using DatabaseConnectionFactory

Below are the steps we followed:
1)Placed the jt400 jar file in customlib folder
2)Modified dbdriver.xml file(so that it can be used in Database readers)
3)modified mirth.properties to have server.includecustomlib = true
4)modified the mcservice.vmoptions to add values from /docs/mcservice-java9+.vmoptions

Created a test channel to test DBReader and also java script transformer step.

Code used for javascript transformer step:
DatabaseConnectionFactory.createDatabaseConnection ("com.ibm.as400.access.AS400JDBCDriver", "jdbc:as400://***;naming=system;errors=full;libraries=****", username, password);

Test Database reader created screenshot:
Capture.JPG

Error in Database reader deployment:
Capture1.JPG
Any guidance pointing to the issue would be really helpful.
Reply With Quote
  #2  
Old 08-05-2019, 06:31 AM
surbhit4u surbhit4u is offline
Mirth Newb
 
Join Date: May 2011
Posts: 15
surbhit4u is on a distinguished road
Default

Even I am facing same issue. Any help would be really appreciated
Reply With Quote
  #3  
Old 08-05-2019, 07:32 AM
cory_cole cory_cole is offline
Mirth Guru
 
Join Date: Mar 2012
Posts: 1,245
cory_cole is on a distinguished road
Default

Have you clicked the select button next to the database connection? This will test your connection to the database from within the channel.
Reply With Quote
  #4  
Old 08-05-2019, 10:36 AM
f180350 f180350 is offline
What's HL7?
 
Join Date: May 2015
Posts: 3
f180350 is on a distinguished road
Default

I use the following.

var sqlDBDriver = 'com.ibm.as400.access.AS400JDBCDriver';
var sqlDBName = 'jdbc:as400://SERVERNAME/LIBRARYNAME';
var sqlDBDUser = 'LOGIN';
var sqlDBPassword = 'PWORD';

var dbConn = DatabaseConnectionFactory.createDatabaseConnection ( sqlDBDriver, sqlDBName, sqlDBDUser, sqlDBPassword );
Reply With Quote
  #5  
Old 08-05-2019, 11:01 AM
cory_cole cory_cole is offline
Mirth Guru
 
Join Date: Mar 2012
Posts: 1,245
cory_cole is on a distinguished road
Default

There is a select button above your sql block to the right. Have you pushed that button?
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 05:06 PM.


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