Hello all !!!
I'm trying to execute a procedure into mirth using Java Script
****
var dbConn = DatabaseConnectionFactory.createDatabaseConnection ('net.sourceforge.jtds.jdbc.Driver','jdbc:jtdsqlse rver://server:1433/database','sa',
'password');
var result = dbConn.executeCachedQuery("EXEC procedure_name");
dbConn.close();
return result;
*****
and also
*************
EXEC procedure_name
*************
in the last just pure SQL statement.
But both examples are not working.
How can I run a procedure inside of mirth ?
Thanks
I'm trying to execute a procedure into mirth using Java Script
****
var dbConn = DatabaseConnectionFactory.createDatabaseConnection ('net.sourceforge.jtds.jdbc.Driver','jdbc:jtdsqlse rver://server:1433/database','sa',
'password');
var result = dbConn.executeCachedQuery("EXEC procedure_name");
dbConn.close();
return result;
*****
and also
*************
EXEC procedure_name
*************
in the last just pure SQL statement.
But both examples are not working.
How can I run a procedure inside of mirth ?
Thanks