Postgres Pro
Downloads
Home   >   mailing lists

error: ResultSet.updateObject(timestamp in POSTGRES, DATE(7) in ORACLE ) - Mailing list pgsql-jdbc

From Vidas Makauskas
Subject error: ResultSet.updateObject(timestamp in POSTGRES, DATE(7) in ORACLE )
Date
Msg-id ecum4o$jln$1@news.hub.org
Whole thread Raw
Responses Re: error: ResultSet.updateObject(timestamp in POSTGRES,
List pgsql-jdbc
Tree view 
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

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Exception in thread "main" java.lang.OutOfMemoryError:
Next
From: Roland Walter
Date:
Subject: I am not reachable anymore under this e-mail address