Hi All,
I am in a very strange situation. I am using MSSQL as DB and when I try to retrieve inserted record's key using getGeneratedKeys() I get error. I searched for an answer but of no luck.
Code snippet:
pstmt = conn.prepareStatement(query);
int insertCount = pstmt.executeUpdate(); // execute insert statement
System.out.println("Insert Count:" + insertCount);
ResultSet resultSet = pstmt.getGeneratedKeys();
if (resultSet != null && resultSet.next()) {
logId = resultSet.getLong(1);
}
Line: getGeneratedKeys() is causing exception:
com.microsoft.sqlserver.jdbc.SQLServerException: The statement must be executed before any results can be obtained.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getGeneratedKeys(SQLServerStatement.java:2002)
I dont see this as a
jdbc driver issue as I am using latest driver: sqljdbc4.jar and have tried the same situation in hibernate and that works
Thanks
Siby