Stored Procedure returns error

Error:

I have a simple process flow that sets context variables as input parameters for a stored procedure and then stores the return parameter as a context variable. Every time I run the process flow I get the following error:

java.sql.SQLException: Output parameters have not yet been processed. Call getMoreResults().
at net.sourceforge.jtds.jdbc.ParamInfo.getOutValue(ParamInfo.java:159)
at net.sourceforge.jtds.jdbc.JtdsCallableStatement.getOutputValue(JtdsCallableStatement.java:115)
at net.sourceforge.jtds.jdbc.JtdsCallableStatement.getString(JtdsCallableStatement.java:229)
at net.sourceforge.jtds.jdbc.JtdsCallableStatement.getString(JtdsCallableStatement.java:423)

 

 

Cause:

The JTDS driver used to create the connection to the database is too restrictive in this case, expecting more records to be generated

 

Solution :

Use the MSSQL Driver for the Database Info activity that is used for the stored procedure

You can use the sqljdbc.jar file here - <Installation Directory>\AdeptiaServer\ServerKernel\libs\driver

Have more questions? Submit a request

0 Comments

Article is closed for comments.