Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 28 Aug 2006 15:06:42 +0300
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
- Follow-Ups:
- Re: error: ResultSet.updateObject(timestamp in POSTGRES,
- From: Kris Jurka
- Re: error: ResultSet.updateObject(timestamp in POSTGRES,
- Prev by Date: Re: Exception in thread "main" java.lang.OutOfMemoryError:
- Next by Date: I am not reachable anymore under this e-mail address
- Previous by thread: Optimizations in the latest driver
- Next by thread: Re: error: ResultSet.updateObject(timestamp in POSTGRES,
- Indexes: