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 type. > > The fieldtypeoracle.xml file contains this: > > <field-type-def type="date-time" sql-type="TIMESTAMP" > sql-type-alias="TIMESTAMP(6)" java-type="java.sql.Timestamp"></field-type-def> > <field-type-def type="date" sql-type="DATE" > java-type="java.sql.Date"></field-type-def> > <field-type-def type="time" sql-type="DATE" > java-type="java.sql.Time"></field-type-def> > > So, I assume the Oracle JDBC driver is returning a java.sql.Date type for the > OFBiz "time" data type. > > -Adrian
Should I try with the following setting: > <field-type-def type="time" sql-type="DATE" > java-type="java.sql.Date"></field-type-def> ? I think I will be able to d this test if you want me to try it. Kind regards, Jacopo
