Subject: [Pljava-dev] SPI Updatable recordset
Date: Fri, 2 Jun 2006 15:25:12 -0400
Message-ID: <7426fe270606021225p74d767a6kccaafd303f24436c@mail.gmail.com> (raw)
Hi,
I'm trying to use PL/JAVA's SPI connection to create an updatable
recordset, and I keep getting an exception when I try to initialize a
statement with CONCUR_UPDATABLE.
The problematic function is this:
public ResultSet getUpdatableResultSet(String sSQLStatement) throws
SQLException{
return db_conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_UPDATABLE)
.executeQuery(sSQLStatement);
}
I have tried using ResultSet.TYPE_FORWARD_ONLY,
ResultSet.TYPE_SCROLL_INSENSITIVE,
and ResultSet.TYPE_SCROLL_SENSITIVE
and all give me the same exception.
The statement works fine when running the code as a standalone program and
using the standard Postgres 8.0 JDBC driver. Executing a SQL DLL command
against a Statement from the SPI connection works just fine.
Any ideas? Is it possible to get an updatable ResultSet from the SPI
connection?
Thanks,
Eric
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20060602/ab38b362/attachment.html;
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] SPI Updatable recordset
In-Reply-To: <7426fe270606021225p74d767a6kccaafd303f24436c@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox