users@glassfish.java.net

Re: [SQL0183] Result of date or timestamp expression not valid

From: <glassfish_at_javadesktop.org>
Date: Wed, 12 Dec 2007 00:59:48 PST

When the connection pool is created in GlassFish for as400 IBM iseries, the data source class name
used is com.ibm.as400.access.AS400JDBCDataSource. When you add the properties "date format" and "time format" to the URL in a stand-alone format, the com.ibm.as400.access.AS400JDBCDriver is used. This contains the method to accept a URL that can hold the above properties.

However, the AS400JDBCDataSource that is used by GlassFish, does not accept the "date format" and "time format" properties in the URL. They need to be specified as separate properties in the additional properties section. As you can see in AS400JDBCDataSource documentation, there are no getter/setter methods for URL, which is why these effects are not seen. It has methods to accept the date and time formats : getDateFormat() and getTimeFormat().

Hope this helps,
Shalini.
[Message sent by forum member 'sm157516' (sm157516)]

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