| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael musset | 2010-10-21 08:26:17 | Fwd: JDBC4 with SQLXML and postgresql-8.4-702.jdbc4.jar |
| Previous Message | Daniele Varrazzo | 2010-10-19 20:04:17 | Re: XA Xid to PostgreSQL transaction ID |