Fwd: JDBC4 with SQLXML and postgresql-8.4-702.jdbc4.jar
| От | Michael musset |
|---|---|
| Тема | Fwd: JDBC4 with SQLXML and postgresql-8.4-702.jdbc4.jar |
| Дата | |
| Msg-id | AANLkTi=mdoJ2J57szgp=t5JN_Swp-CPBkWyDUxqWifns@mail.gmail.com обсуждение исходный текст |
| Ответ на | JDBC4 with SQLXML and postgresql-8.4-702.jdbc4.jar (Michael musset <mickamusset@gmail.com>) |
| Список | pgsql-jdbc |
---------- 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,
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 beatorg.postgresql.jdbc2.AbstractJdbc2ResultSet.updateRowBuffer(AbstractJdbc2Re
cast to [B
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
--
Michael Musset,
Tel: 06 26 06 29 89
В списке pgsql-jdbc по дате отправления: