Oracle 11g JDBC driver.

Article View: borland.public.jbuilder.database

Article #338

Back to borland.public.jbuilder.database Previous Next

#338

From: Serguei
Date: Tue, 02 Mar 2010 19:50

27 lines
2241 bytes

   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.

Technical Details

Message-ID: <eb89ea80-e317-4dc9-8c45-4752f3cc8a73@k18g2000prf.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!k18g2000prf.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 2da372a44e,7bfc0ae088b33e3,start
X-Google-Attributes: gid2da372a44e,public,usenet
X-Google-NewGroupId: yes
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!k18g2000prf.googlegroups.com!not-for-mail
From: Serguei <Serguei.Goumeniouk@cibc.ca>
Newsgroups: borland.public.jbuilder.database
Subject: Oracle 11g JDBC driver.
Date: Tue, 2 Mar 2010 11:50:55 -0800 (PST)
Organization: http://groups.google.com
Lines: 27
Message-ID: <eb89ea80-e317-4dc9-8c45-4752f3cc8a73@k18g2000prf.googlegroups.com>
NNTP-Posting-Host: 199.198.223.108
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1267559456 2003 127.0.0.1 (2 Mar 2010 19:50:56 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 2 Mar 2010 19:50:56 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: k18g2000prf.googlegroups.com; posting-host=199.198.223.108; 
 posting-account=01fDHAoAAABXxt76qke4GTlvnbP9ex-y
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; 
 InfoPath.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; MS-RTC LM
 8),gzip(gfe),gzip(gfe)