Help with prepared statement in javascript

[josemathews Mirth Newb Find all posts View Profile Close josemathews]

Hi,
I am trying to use a prepared statement with a DatabaseConnection object. I tried to use DatabaseConnection.executeUpdate(String sqlExpression, java.util.List params) API. When I try to pass in a javascript array like this:

var params = new Array();
params[0] = $('lastName');
params[1] = $('firstName');
params[2] = $('middleName');

var expression = "INSERT IGNORE INTO hl7_sample (patient_last_name, patient_first_name, patient_middle_initial) VALUES (?, ?, ?);"
var result = dbConn.executeUpdate(expression, params);

I get the exception:

ERROR-406: JDBC Connector error
ERROR MESSAGE: Error writing to database:
org.mozilla.javascript.EvaluatorException: Cannot convert [email protected] to java.util.List (fff9cb5c-5920-499d-9383-eb395398ded0#22)
at org.mozilla.javascript.DefaultErrorReporter.runtim eError(DefaultErrorReporter.java:95)
at org.mozilla.javascript.Context.reportRuntimeError( Context.java:966)
at org.mozilla.javascript.Context.reportRuntimeError( Context.java:1022)
at org.mozilla.javascript.Context.reportRuntimeError2 (Context.java:992)


I understand why that is happening but couldn't figure out the solution. Anybody knows the correct way to use this API? Thanks for your help.

Post edited by: josemathews, at: 09/10/2007 12:17

[josemathews Mirth Newb Find all posts View Profile Close josemathews]

Re:Help with prepared statement in javascript

Googled around and found the solution. Since Rhino gives you access to the java classes I could use the following:

var params = new java.util.ArrayList();
params.add($('lastName'));
params.add($('firstName'));
params.add($('middleName'));


var expression = "INSERT IGNORE INTO hl7_test_sample (patient_last_name, patient_first_name, patient_middle_initial) VALUES (?, ?, ?);"
var result = dbConn.executeUpdate(expression, params);

Thanks,
- jose

[chrisl Mirth Certified Find all posts View Profile Close chrisl]

Re:Help with prepared statement in javascript

You might need to do:

var params = new Packages.java.util.ArrayList();