users@glassfish.java.net

Re: Toplink conversion error using util.Date/sql.Date and Timestamps

From: <glassfish_at_javadesktop.org>
Date: Wed, 07 Feb 2007 07:26:25 PST

I found the problem: I declared the database fields as "TIMESTAMP WITH LOCAL TIMEZONE". This results in the use of oracle.sql.TIMESTAMPLTZ objects instead of oracle.sql.TIMESTAMP objects which could be converted on the fly, whereas TIMESTAMPLTZ cannot.
 
I changed the field to plain and simple TIMESTAMP and now it works.

Thanks for your help!
[Message sent by forum member 'hbusch' (hbusch)]

http://forums.java.net/jive/thread.jspa?messageID=202471