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
