[Pljava-dev] SPI Updatable recordset

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
>