---------- Forwarded message ----------
From:
Michael musset <mickamusset@gmail.com> Date: Thu, Oct 21, 2010 at 10:26 AM
Subject: Re: [JDBC] JDBC4 with SQLXML and postgresql-8.4-702.jdbc4.jar
To: Kris Jurka <
books@ejurka.com>
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 ?
thanks,
On Thu, Oct 21, 2010 at 10:21 AM, Kris Jurka
<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
--
Michael Musset,
Tel: 06 26 06 29 89