Re: svn commit: r952997 - /ofbiz/trunk/framework/base/src/org/ofbiz/base/conversion/DateTimeConverters.java

2010-06-30 Thread Adrian Crum
please test it with Oracle and let me know how it works. -Adrian --- On Tue, 6/29/10, Jacopo Cappellato wrote: > From: Jacopo Cappellato > Subject: Re: svn commit: r952997 - > /ofbiz/trunk/framework/base/src/org/ofbiz/base/conversion/DateTimeConverters.java > To: dev@ofbiz.apache.or

Re: svn commit: r952997 - /ofbiz/trunk/framework/base/src/org/ofbiz/base/conversion/DateTimeConverters.java

2010-06-29 Thread Adam Heath
Jacopo Cappellato wrote: > Should I try with the following setting: > >> > java-type="java.sql.Date"> This won't work; java.sql.Date doesn't store time fields; its hours, minutes, and seconds are all set to 0.

Re: svn commit: r952997 - /ofbiz/trunk/framework/base/src/org/ofbiz/base/conversion/DateTimeConverters.java

2010-06-29 Thread Jacopo Cappellato
On Jun 29, 2010, at 6:45 PM, Adrian Crum wrote: > > I think I found out the real reason there is a problem with Oracle. In JDBC > there are three date/time SQL types: Date, Time, and Timestamp. Oracle has > only two date/time SQL types: DATE and TIMESTAMP. Oracle does not have a TIME > SQL typ

Re: svn commit: r952997 - /ofbiz/trunk/framework/base/src/org/ofbiz/base/conversion/DateTimeConverters.java

2010-06-29 Thread Adrian Crum
On 6/9/2010 9:35 AM, Adrian Crum wrote: On 6/9/2010 9:21 AM, Adam Heath wrote: Adrian Crum wrote: On 6/9/2010 8:49 AM, Adam Heath wrote: jaco...@apache.org wrote: Author: jacopoc Date: Wed Jun 9 13:20:21 2010 New Revision: 952997 URL: http://svn.apache.org/viewvc?rev=952997&view=rev Log: Imp

Re: svn commit: r952997 - /ofbiz/trunk/framework/base/src/org/ofbiz/base/conversion/DateTimeConverters.java

2010-06-09 Thread Adrian Crum
On 6/9/2010 9:21 AM, Adam Heath wrote: Adrian Crum wrote: On 6/9/2010 8:49 AM, Adam Heath wrote: jaco...@apache.org wrote: Author: jacopoc Date: Wed Jun 9 13:20:21 2010 New Revision: 952997 URL: http://svn.apache.org/viewvc?rev=952997&view=rev Log: Implemented sql date to time converter to a

Re: svn commit: r952997 - /ofbiz/trunk/framework/base/src/org/ofbiz/base/conversion/DateTimeConverters.java

2010-06-09 Thread Adam Heath
Adrian Crum wrote: > On 6/9/2010 8:49 AM, Adam Heath wrote: >> jaco...@apache.org wrote: >>> Author: jacopoc >>> Date: Wed Jun 9 13:20:21 2010 >>> New Revision: 952997 >>> >>> URL: http://svn.apache.org/viewvc?rev=952997&view=rev >>> Log: >>> Implemented sql date to time converter to avoid errors

Re: svn commit: r952997 - /ofbiz/trunk/framework/base/src/org/ofbiz/base/conversion/DateTimeConverters.java

2010-06-09 Thread Adrian Crum
On 6/9/2010 8:49 AM, Adam Heath wrote: jaco...@apache.org wrote: Author: jacopoc Date: Wed Jun 9 13:20:21 2010 New Revision: 952997 URL: http://svn.apache.org/viewvc?rev=952997&view=rev Log: Implemented sql date to time converter to avoid errors with Oracle. Modified: ofbiz/trunk/frame

Re: svn commit: r952997 - /ofbiz/trunk/framework/base/src/org/ofbiz/base/conversion/DateTimeConverters.java

2010-06-09 Thread Adam Heath
jaco...@apache.org wrote: > Author: jacopoc > Date: Wed Jun 9 13:20:21 2010 > New Revision: 952997 > > URL: http://svn.apache.org/viewvc?rev=952997&view=rev > Log: > Implemented sql date to time converter to avoid errors with Oracle. > > > Modified: > > ofbiz/trunk/framework/base/src/org/o