We're using dummy tables for storing autonumeric data (identity fields) so we're aware the way to access and retrieve those autonumerics:
insert into dummy_table values ()
The first part is working quite good... just an insert but we're having a bad time with the second (select @@identty).
We ALWAYS get a SQLException (Result set IDLE, not currently accessing a row -more or less that's the exception description). We've changed the select to "select @@identity as column1" but the result is the same.