getGeneratedKeys() causing exception

[Siby George]

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

[Karthik Shiraly]

Should be

...
pstmt = conn.prepareStatement(query, Statement.RETURN_GENERATED_KEYS); 
...

[Siby George]

Thanks, that was the solution