Hi Everyone,
When I create a prepared statement like this in java (using JDBC):
pStmt = conn.prepareStatement(qry);
everything works ok. However when I want a scrollable resultset and use this:
pStmt = conn.prepareStatement(qry,ResultSet.TYPE_SCROLL_INSENSITIVE);
I get a syntax error:
org.postgresql.util.PSQLException: ERROR: syntax error at or near "RETURNING"
I'm not even using RETURNING in my query. I think that my issue mayh be related to this post:http://archives.postgresql.org/pgsql-jdbc/2010-04/msg00060.php
Any ideas?
Any help would be appreciated. Thanks
