Skip site navigation (1) Skip section navigation (2)

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

From: Kris Jurka <books(at)ejurka(dot)com>
To: Michael musset <mickamusset(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC4 with SQLXML and postgresql-8.4-702.jdbc4.jar
Date: 2010-10-21 08:21:01
Message-ID: alpine.BSO.2.00.1010210418110.30447@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbc

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

In response to

Responses

pgsql-jdbc by date

Next:From: Michael mussetDate: 2010-10-21 08:26:17
Subject: Fwd: JDBC4 with SQLXML and postgresql-8.4-702.jdbc4.jar
Previous:From: Daniele VarrazzoDate: 2010-10-19 20:04:17
Subject: Re: XA Xid to PostgreSQL transaction ID

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group