Uploaded image for project: 'JDK'
  1. JDK
  2. JDK-5055528

populate fails with SQLException because locatorsUpdateCopy is not implemented

    XMLWordPrintable

    Details

    • Subcomponent:
    • Resolved In Build:
      b58
    • CPU:
      generic
    • OS:
      generic

      Backports

        Description

        CachedRowSet.populate() fails with SQLException because some drivers have not
        implemented locatorsUpdateCopy().

        Inside the populate() method initMetaData() is called which calls the locatorUpdateCopy() method for blobs and clobs. If this is not implemented by JDBC drivers it fails throwing SQLException.

        This causes CachedRowSets not to work


        ###@###.### 2004-06-24

        Same problem has been reported by a CAP member:

        We have identified and confirmed a high priority bug with the JDBC
        RowSet implementation of your current build of JDK 1.5. The bug makes
        the RowSet unusable with the PostgreSQL database (and possibly others).
        As a CAP member, we suggest very high urgency on this bug as it may
        cause the RowSet not to support other databases.

        Here is an overview:

        The RowSet gathers some initial metadata when first being used. This
        calls the locatorsUpdateCopy() of the JDBC driver. This method is meant
        to describe how LOBs are updated, but in the case of PostgreSQL (and
        maybe other databases), LOBs aren't updateable at all. The PostgreSQL
        driver chooses to throw an exception at this point. Since the RowSet
        doesn't catch this exception, it stops the entire rest of the RowSet
        from being used. A simple change is needed to gracefully catch this
        exception.

        Stacktrace when using RowSet with PostgreSQL:

        org.postgresql.util.PSQLException: This method is not yet implemented.
                at org.postgresql.Driver.notImplemented(Driver.java:413)
                at
        org.postgresql.jdbc3.AbstractJdbc3DatabaseMetaData.locatorsUpdateCopy(AbstractJdbc3DatabaseMetaData.java:339)

                at
        com.sun.rowset.CachedRowSetImpl.initMetaData(CachedRowSetImpl.java:691)
                at
        com.sun.rowset.CachedRowSetImpl.populate(CachedRowSetImpl.java:597)
                at
        com.sun.rowset.internal.CachedRowSetReader.readData(CachedRowSetReader.java:170)

                at
        com.sun.rowset.CachedRowSetImpl.execute(CachedRowSetImpl.java:727)

        Please let me know if you need more information.

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                ahandasunw Amit Handa (Inactive)
                Reporter:
                ahandasunw Amit Handa (Inactive)
                Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:
                  Imported:
                  Indexed: