Showing different exceptions for different ResultSetTypes?
For the code below, I am getting different exceptions for different ResultSet types.
ResultSet rs = stmt.executeQuery("Select * from usermaster");
rs.absolute(3);
rs.updateString("emailID", "newID");
rs.updateRow();
*****
For ResultSet -> ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY, I am getting following exception
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Invalid attribute/option identifier
at sun.jdbc.odbc.JdbcOdbcResultSet.setPos(JdbcOdbcResultSet.java:5017)
at sun.jdbc.odbc.JdbcOdbcResultSet.updateRow(JdbcOdbcResultSet.java:4009)
at DBConnector.<init>(DBConnector.java:56)
******
For ResultSet -> ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE, I am getting following exception
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]String data, right truncation
at sun.jdbc.odbc.JdbcOdbcResultSet.setPos(JdbcOdbcResultSet.java:5017)
at sun.jdbc.odbc.JdbcOdbcResultSet.updateRow(JdbcOdbcResultSet.java:4009)
at DBConnector.<init>(DBConnector.java:56)
******
I am using SQL Server 2000, and JDK1.4 beta.
I am not able to identify what is going wrong here? Please help
