agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] SPI Updatable recordset
Date: Fri, 02 Jun 2006 21:33:47 +0200
Message-ID: <4480929B.4070806@tada.se> (raw)
In-Reply-To: <7426fe270606021225p74d767a6kccaafd303f24436c@mail.gmail.com>
References: <7426fe270606021225p74d767a6kccaafd303f24436c@mail.gmail.com>
Hi Eric,
The PL/Java jdbc driver will only support the combination
ResultSet.TYPE_FORWARD_ONLY and ResultSet.CONCUR_READ_ONLY at present.
Other combinations might be implemented in future releases. Patches are
always welcome.
Kind Regards,
Thomas Hallgren
Eric E wrote:
> 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
> ------------------------------------------------------------------------
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
view thread (4+ messages) latest in thread
Message-ID: <4480929B.4070806@tada.se>
Permalink: ../4480929B.4070806@tada.se/
Also on: postgresql.org/message-id/4480929B.4070806@tada.se
reply
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: <4480929B.4070806@tada.se>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox