Stored Procedure returns 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(
at net.sourceforge.jtds.jdbc.JtdsCallableStatement.getOutputValue(
at net.sourceforge.jtds.jdbc.JtdsCallableStatement.getString(
at net.sourceforge.jtds.jdbc.JtdsCallableStatement.getString(




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


Article is closed for comments.