From: whalesuit at gmail.com (Eric E)
Date: Fri, 2 Jun 2006 15:25:12 -0400
Subject: [Pljava-dev] SPI Updatable recordset
Message-ID: <7426fe270606021225p74d767a6kccaafd303f24436c@mail.gmail.com>

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>