web stats
Database Writer Error - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 04-10-2015, 09:21 AM
rhorch rhorch is offline
What's HL7?
 
Join Date: Oct 2013
Posts: 1
rhorch is on a distinguished road
Default Database Writer Error

I am using Mirth 3.2.1 64-bit, and was previously using 3.2.0. I have been trying to get this to work with Informix and all of the attempts I have made end in "No suitable driver found". All of the jars are in the custom-lib folder and the server has been restarted multiple times. I have used the drivers directly from java with the same parameters successfully. Here are the following setups:

<----------------->
Informix CSDK:

<driver class="com.informix.jdbc.IfxDriver" name="Informix" template="jdbc:informix-sqli://hostort/dbname:informixserver=servername" selectLimit="SELECT LIMIT 1 * FROM ?" />

Database Writer error
ERROR MESSAGE: Error evaluating Database Writer
com.mirth.connect.server.MirthJavascriptTransforme rException:
CHANNEL: Test
CONNECTOR: Destination 1
SOURCE CODE:
25: function doScript() {
26: var dbConn;
27:
28: try {
29: //DatabaseConnectionFactory.initializeDriver("com.in formix.jdbc.IfxDriver");
30: dbConn = DatabaseConnectionFactory.createDatabaseConnection ('com.informix.jdbc.IfxDriver','jdbc:informix-sqli://192.168.2.3:20021/live_prep:informixserver=fx_dev_540_net','informix ','t3mpr00t');
31: var sql = "insert into hl7test values ('" + connectorMessage.getMessageId() + "');"
32: dbConn.executeUpdate(sql);
33: } finally {
34: if (dbConn) {
LINE NUMBER: 30
DETAILS: Wrapped java.sql.SQLException: No suitable driver found for jdbc:informix-sqli://192.168.2.3:20021/live_prep:informixserver=fx_dev_540_net
at 97e09f8b-9ff1-49c7-8c3f-25848c6934bc:30 (doScript)
at 97e09f8b-9ff1-49c7-8c3f-25848c6934bc:40
at com.mirth.connect.server.util.javascript.JavaScrip tUtil.executeScript(JavaScriptUtil.java:526)
at com.mirth.connect.connectors.jdbc.DatabaseDispatch erScript$DatabaseDispatcherTask.call(DatabaseDispa tcherScript.java:120)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker( Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: No suitable driver found for jdbc:informix-sqli://192.168.2.3:20021/live_prep:informixserver=fx_dev_540_net
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.mirth.connect.server.userutil.DatabaseConnecti on.<init>(DatabaseConnection.java:62)
at com.mirth.connect.server.userutil.DatabaseConnecti onFactory.createDatabaseConnection(DatabaseConnect ionFactory.java:49)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.mozilla.javascript.MemberBox.invoke(MemberBox. java:126)
at org.mozilla.javascript.NativeJavaMethod.call(Nativ eJavaMethod.java:225)
at org.mozilla.javascript.Interpreter.interpretLoop(I nterpreter.java:1473)
at org.mozilla.javascript.Interpreter.interpret(Inter preter.java:815)
at org.mozilla.javascript.InterpretedFunction.call(In terpretedFunction.java:109)
at org.mozilla.javascript.ContextFactory.doTopCall(Co ntextFactory.java:394)
at org.mozilla.javascript.ScriptRuntime.doTopCall(Scr iptRuntime.java:3091)
at org.mozilla.javascript.InterpretedFunction.exec(In terpretedFunction.java:120)
at com.mirth.connect.server.util.javascript.JavaScrip tTask.executeScript(JavaScriptTask.java:68)
at com.mirth.connect.server.util.javascript.JavaScrip tUtil.executeScript(JavaScriptUtil.java:521)
... 5 more

<----------------->
IBM Data Server Client:
<driver class="com.ibm.db2.jcc.DB2Driver" name="DB2 Informix" template="jdbc:ids://hostort/dbname" selectLimit="SELECT LIMIT 1 * FROM ?" />

Database Writer error
ERROR MESSAGE: Error evaluating Database Writer
com.mirth.connect.server.MirthJavascriptTransforme rException:
CHANNEL: Test
CONNECTOR: Destination 1
SOURCE CODE:
24: }
25: function doScript() {
26: var dbConn;
27:
28: try {
29: dbConn = DatabaseConnectionFactory.createDatabaseConnection ('com.ibm.db2.jcc.DB2Driver','jdbc:ids://74.127.61.171:21021/live_prep','informix','t3mpr00t');
30: var sql = "insert into hl7test values ('" + connectorMessage.getMessageId() + "');"
31: dbConn.executeUpdate(sql);
32: } finally {
33: if (dbConn) {
LINE NUMBER: 29
DETAILS: Wrapped java.sql.SQLException: No suitable driver found for jdbc:ids://74.127.61.171:21021/live_prep
at ba49d344-f876-4945-b653-c06ae0d6e865:29 (doScript)
at ba49d344-f876-4945-b653-c06ae0d6e865:39
at com.mirth.connect.server.util.javascript.JavaScrip tUtil.executeScript(JavaScriptUtil.java:526)
at com.mirth.connect.connectors.jdbc.DatabaseDispatch erScript$DatabaseDispatcherTask.call(DatabaseDispa tcherScript.java:120)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker( Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: No suitable driver found for jdbc:ids://74.127.61.171:21021/live_prep
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.mirth.connect.server.userutil.DatabaseConnecti on.<init>(DatabaseConnection.java:62)
at com.mirth.connect.server.userutil.DatabaseConnecti onFactory.createDatabaseConnection(DatabaseConnect ionFactory.java:49)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.mozilla.javascript.MemberBox.invoke(MemberBox. java:126)
at org.mozilla.javascript.NativeJavaMethod.call(Nativ eJavaMethod.java:225)
at org.mozilla.javascript.Interpreter.interpretLoop(I nterpreter.java:1473)
at org.mozilla.javascript.Interpreter.interpret(Inter preter.java:815)
at org.mozilla.javascript.InterpretedFunction.call(In terpretedFunction.java:109)
at org.mozilla.javascript.ContextFactory.doTopCall(Co ntextFactory.java:394)
at org.mozilla.javascript.ScriptRuntime.doTopCall(Scr iptRuntime.java:3091)
at org.mozilla.javascript.InterpretedFunction.exec(In terpretedFunction.java:120)
at com.mirth.connect.server.util.javascript.JavaScrip tTask.executeScript(JavaScriptTask.java:68)
at com.mirth.connect.server.util.javascript.JavaScrip tUtil.executeScript(JavaScriptUtil.java:521)
... 5 more


<----------------->
JDBC/ODBC:

Database Writer error
ERROR MESSAGE: Error evaluating Database Writer
com.mirth.connect.server.MirthJavascriptTransforme rException:
CHANNEL: Test
CONNECTOR: Destination 1
SOURCE CODE:
24: }
25: function doScript() {
26: var dbConn;
27:
28: try {
29: dbConn = DatabaseConnectionFactory.createDatabaseConnection ('sun.jdbc.odbc.JdbcOdbcDriver','jdbcdbc:fx_dev6 4','informix','t3mpr00t');
30: var sql = "insert into hl7test values ('" + connectorMessage.getMessageId() + "');"
31: dbConn.executeUpdate(sql);
32: } finally {
33: if (dbConn) {
LINE NUMBER: 29
DETAILS: Wrapped java.sql.SQLException: No suitable driver found for jdbcdbc:fx_dev64
at 0148acd3-597b-4508-b22c-61bfceda7e65:29 (doScript)
at 0148acd3-597b-4508-b22c-61bfceda7e65:40
at com.mirth.connect.server.util.javascript.JavaScrip tUtil.executeScript(JavaScriptUtil.java:526)
at com.mirth.connect.connectors.jdbc.DatabaseDispatch erScript$DatabaseDispatcherTask.call(DatabaseDispa tcherScript.java:120)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker( Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: No suitable driver found for jdbcdbc:fx_dev64
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.mirth.connect.server.userutil.DatabaseConnecti on.<init>(DatabaseConnection.java:62)
at com.mirth.connect.server.userutil.DatabaseConnecti onFactory.createDatabaseConnection(DatabaseConnect ionFactory.java:49)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.mozilla.javascript.MemberBox.invoke(MemberBox. java:126)
at org.mozilla.javascript.NativeJavaMethod.call(Nativ eJavaMethod.java:225)
at org.mozilla.javascript.Interpreter.interpretLoop(I nterpreter.java:1473)
at org.mozilla.javascript.Interpreter.interpret(Inter preter.java:815)
at org.mozilla.javascript.InterpretedFunction.call(In terpretedFunction.java:109)
at org.mozilla.javascript.ContextFactory.doTopCall(Co ntextFactory.java:394)
at org.mozilla.javascript.ScriptRuntime.doTopCall(Scr iptRuntime.java:3091)
at org.mozilla.javascript.InterpretedFunction.exec(In terpretedFunction.java:120)
at com.mirth.connect.server.util.javascript.JavaScrip tTask.executeScript(JavaScriptTask.java:68)
at com.mirth.connect.server.util.javascript.JavaScrip tUtil.executeScript(JavaScriptUtil.java:521)
... 5 more
Reply With Quote
  #2  
Old 04-10-2015, 10:34 AM
narupley's Avatar
narupley narupley is online now
Mirth Employee
 
Join Date: Oct 2010
Posts: 7,124
narupley is on a distinguished road
Default

You may be running into this issue: MIRTH-3649

Have you tried using the Database Reader/Writer connectors rather than JavaScript? That should work fine. Or if you need to use JavaScript, there's a workaround I posted in the issue.
__________________
Step 1: JAVA CACHE...DID YOU CLEAR ...wait, ding dong the witch is dead?

Nicholas Rupley
Work: 949-237-6069
Always include what Mirth Connect version you're working with. Also include (if applicable) the code you're using and full stacktraces for errors (use CODE tags). Posting your entire channel is helpful as well; make sure to scrub any PHI/passwords first.


- How do I foo?
- You just bar.
Reply With Quote
Reply

Tags
driver, informix

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 07:57 AM.


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