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

On Thu, 21 Oct 2010, Kris Jurka 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.
>

I've put a fix for this into CVS.  I've uploaded a new jar file here:

http://ejurka.com/pgsql/jars/xml/

Kris Jurka