[Microsoft][SQLServer 2000 Driver for JDBC]Row update failed

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Saran (Saran_at_discussions.microsoft.com)
Date: 02/25/05 

Date: Fri, 25 Feb 2005 07:33:03 -0800

I am getting an error "[Microsoft][SQLServer 2000 Driver for JDBC]Row update
failed" while updating an int value on result set. Below is the code snippet
that i use in java. The error is occurring occasionally. Not able to
replicate.

strSQL = "SELECT intCol FROM Table1 WHERE intCol = 1";
PreparedStatement objPS = null;
...get the connection object, prepare object...using msjdbc driver with SQL
server 2000
ResultSet objRS = objPS.executeQuery();
objRS.updateInt("intCol", 2);
objRS.updateRow();

any help is appreciated.
Thanks in advance.

Relevant Pages