error: ResultSet.updateObject(timestamp in POSTGRES, DATE(7) in ORACLE )

From: "Vidas Makauskas" <vms(at)centras(dot)lt>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: error: ResultSet.updateObject(timestamp in POSTGRES, DATE(7) in ORACLE )
Date: 2006-08-28 12:06:42
Message-ID: ecum4o$jln$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,
I've upgrade SLES9 with pg73b1jdbc3.jar to SLES10 with
postgresql-8.1-404.jdbc3.jar

ResultSet.updateObject(timestamp in POSTGRES, DATE(7) from ORACLE database
via OJDBC13.JAR )
begin produce error in ResultSet.insertRow():
Exception in thread "main" java.lang.ClassCastException
at
org.postgresql.jdbc2.AbstractJdbc2ResultSet.updateRowBuffer(AbstractJdbc2ResultSet.java:1727)
at
org.postgresql.jdbc2.AbstractJdbc2ResultSet.insertRow(AbstractJdbc2ResultSet.java:832)
.........

CAST ( TRUNC ( ORACLE->DATE(7), 'DD' ) AS TIMESTAMP ) in ORACLE view not
accetable too.

There's no errors in case ResultSet.updateObject(date in POSTGRES, DATE(7)
from ORACLE)
Vidas

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Roland Walter 2006-08-28 12:52:46 I am not reachable anymore under this e-mail address
Previous Message Oliver Jowett 2006-08-28 09:32:13 Re: Exception in thread "main" java.lang.OutOfMemoryError: