MaxDB 7.5.0.23 on Linux
Scenario:
I have a update dbproc that execs multiple update statements in a SUBTRANS
block and has 4 parameters 3 IN and 1 OUT.
after each update I set an internally defined VAR N INT using the following:
SET N = N + $COUNT;
After the last update statement and right before SUBTRANS END; call I set
the out parameter using:
SET UPDCOUNT = N + $COUNT;
In my java app I use the following:
cstmt = conn.prepareCall("{call spUpdateProc(?,?,?,?)}");
cstmt.setInt(1,Integer.parseInt(sId));
cstmt.setString(2,sUser);
java.sql.Timestamp tsp = utilClass.getTimestamp();
cstmt.setTimestamp(3,tsp);
cstmt.registerOutParameter(4,Types.INTEGER);
cstmt.execute();
int intUpdCount = cstmt.getInt(4);
if(intUpdCount <= 0){<return a no update made message to user>}
else{<return a success message to user>}
The value of intUpdCount returned is zero.
Any ideas as why the update counts are not being tallied and set?
Thanks.
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
