Database Writer Error

[rhorch]

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

[narupley]

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.