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