From: thomas at tada.se (Thomas Hallgren)
Date: Fri, 02 Jun 2006 21:33:47 +0200
Subject: [Pljava-dev] SPI Updatable recordset
In-Reply-To: <7426fe270606021225p74d767a6kccaafd303f24436c@mail.gmail.com>
References: <7426fe270606021225p74d767a6kccaafd303f24436c@mail.gmail.com>
Message-ID: <4480929B.4070806@tada.se>

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
>