Re: JDBC4 with SQLXML and postgresql-8.4-702.jdbc4.jar

No it won't work with the 9.0 JDBC driver either.  The same problem exists in both versions.

Kris

On 10/21/2010 1:26 AM, Michael musset wrote:

Thank you very much, and about that :

Yes the bug appeared when I do an updaterow() to the resultset.


i've decided to migrate to postgresql 9.

will it work with JDBC4 Postgresql Driver, Version 9.0-801

<http://jdbc.postgresql.org/download/postgresql-9.0-801.jdbc4.jar> ?

thanks,

On Thu, Oct 21, 2010 at 10:21 AM, Kris Jurka <books@ejurka.com

<mailto:books@ejurka.com>> wrote:



   On Tue, 19 Oct 2010, Michael musset wrote:

       java.lang.ClassCastException: org.postgresql.jdbc4.Jdbc4SQLXML
       cannot be
       cast to [B
       atorg.postgresql.jdbc2.AbstractJdbc2ResultSet.updateRowBuffer(AbstractJdbc2Re
       sultSet.java:1729)
       atorg.postgresql.jdbc2.AbstractJdbc2ResultSet.updateRow(AbstractJdbc2ResultSe
       t.java:1291)


       SQLXML sqlxml = con.createSQLXML();
       DOMResult domResult=sqlxml.setResult(DOMResult.class)
       domResult.setNode(xmldocumentDOM);

       stmt.setSQLXML(1, sqlxml);
       stmt.execute();


   Your sample code and stacktrace don't seem to match, but I see what
   the problem is.  The updatable ResultSet code isn't prepared for
   handling a SQLXML object.  It's slightly tricky to fix because the
   code in question is in a JDBC2 class while SQLXML is JDBC4 only.
     I'll look into it.

   Kris Jurka




--
Michael Musset,
Tel: 06 26 06 29 89