Retrieve Number of Rows Affected in Calling Stored Procedure

[Mark Reyes]

Hi All,

I have an insert statement that is embedded in a stored procedure call, please see my code.

  	private class AddUser extends StoredProcedure {

		public AddUser(DataSource ds) {
			super(ds, SP_MAINTAIN_USER);
			declareParameter(new SqlParameter("@bytOption", Types.INTEGER));
			declareParameter(new SqlParameter("@strUserID", Types.VARCHAR));
			declareParameter(new SqlParameter("@strPassword", Types.VARCHAR));
			declareParameter(new SqlParameter("@strFirstName", Types.VARCHAR));
			declareParameter(new SqlParameter("@strLastName", Types.VARCHAR));
			declareParameter(new SqlParameter("@strMI", Types.VARCHAR));
			declareParameter(new SqlReturnUpdateCount(Constants.RETURN_COUNT));
			// declareParameter(new SqlOutParameter("return_value",
			// Types.INTEGER));
			compile();
		}
	}  

Now what I want is to retrieve the number of rows affected. In plain JDBC, the callable statement is returning the number of rows affected this is for me to add logic
so that I will know that the Insert/Update procedure was successful.

Do you know how to do this? I have tried the class SqlReturnUpdateCount, but it returns null.

SQLOutParameter "return_value" is not correct also as I do not have a parameter which is an Out Parameter in my stored procedure. I am using MSSQL by the way. Please advise.

[Lorand Komaromi]

Have you checked the Map returned by execute()?

[Mark Reyes]

Hi Lorand,

yes, I have checked the return map but it has no values or entries associated with.

[Mark Reyes]

Hi,

I found the cause while making some changes in the db. The culprit is the dreaded Set No Count option which is automatically appended by MSSQL 2008 DB.

Thanks.

[Mark Spritzler]

mark reyes wrote:Hi,

I found the cause while making some changes in the db. The culprit is the dreaded Set No Count option which is automatically appended by MSSQL 2008 DB.

Thanks.

Sweet, good catch.

Mark