From: | "Jonathan Tripathy" <jonnyt(at)abpni(dot)co(dot)uk> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Syntax error near returning |
Date: | 2010-11-23 17:44:32 |
Message-ID: | 46C13AA90DB8844DAB79680243857F0F0AFF30@server1.ABPNI.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew Walden | 2010-11-23 18:00:55 | Re: postmaster.pid does not exist. cannot start postgres server on ubuntu |
Previous Message | Tom Lane | 2010-11-23 17:21:28 | Re: Discerning user vs trigger based updates |