[Pljava-dev] SPI Updatable recordset

[Eric E]

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://pgfoundry.org/pipermail/pljava-dev/attachments/20060602/ab38b362/attachment.html