Java invalid syntax error passing variables to SP

Hello experts,

I am receiving a syntax error when trying to pass a variable to a SQL stored procedure.  

Here is the java call: (The reason it doesnt look standard is because I'm running in a JSP that has it's own java functions etc).

var dbConn = DatabaseConnectionFactory.createDatabaseConnection ('net.sourceforge.jtds.jdbc.Driver','jdbc:jtds:sql server://localhost:1433/DB;instance=MSSQLSERVER','sa','PW');
var result = 0;
var sql = "exec dbo.mirth_test_insert_2('0')";  // this is the line in question
result = dbConn.executeUpdate(sql);

globalMap.put('PER_NBR', result)
dbConn.close();
return message;

I get the error "Is getting this error in log: Wrapped java.sql.SQLException: Incorrect syntax near '(' " etc.

Thoughts?

Thanks in advance
robthomas09Asked:
Who is Participating?
 
ram_0218Commented:
need to use callablestatement?
0
 
robthomas09Author Commented:
Thanks for the reply ram - we did give that a try and apparently our environment doesnt support that callableStatement object.  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.