Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Oracle 11g JDBC driver.

18 views
Skip to first unread message

Serguei

unread,
Mar 2, 2010, 2:50:55 PM3/2/10
to
Dear Experts,
Our team moved from Oracle 9i to 11g server. In my application I use
the QueryDataSet to access data. The type of the column which makes me
this problem is declared as "Date". The Java line is very simple:

Date date = queryDataSetSecurity.getDate("maturity_date");

This line works if I use the good old 9i Oracle JDBC driver. But it
generates the following exception if I switch to 11g one:

com.borland.dx.dataset.VariantException: Attempt to get a DATE value
from a TIMESTAMP value.
at com.borland.dx.dataset.VariantException.fire(Unknown Source)
at com.borland.dx.dataset.Variant.a(Unknown Source)
at com.borland.dx.dataset.Variant.getDate(Unknown Source)
at com.borland.dx.dataset.ReadRow.getDate(Unknown Source)
at
com.cibcwm.wmet.etm.SecurityEditDialog.retrieveData(SecurityEditDialog.java:
1596)

It seems the driver treats this column as "Timestamp", not "Date".

Have you any idea why I have this problem and how I can fix it without
Java source code modification?

Regards,
Serguei.

0 new messages