From: <no...@so...> - 2002-04-06 16:30:38
|
Bugs item #538236, was opened at 2002-04-02 09:44 You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=538236&group_id=22866 Category: JBossCMP Group: v3.0 Rabbit Hole Status: Open Resolution: None Priority: 5 Submitted By: Stephen Coy (scoy) Assigned to: Dain Sundstrom (dsundstrom) Summary: Oracle data mappings use TIMESTAMP type Initial Comment: The standardjbosscmp-jdbc.xml tries to use the TIMESTAMP datatype for mapping java.util.Date to an sql type for both Oracle7 and Oracle8 databases: <mapping> <java-type>java.util.Date</java-type> <jdbc-type>TIMESTAMP</jdbc-type> <sql-type>TIMESTAMP</sql-type> </mapping> TIMESTAMP is not a valid Oracle7/8 datatype. Unfortunately there does not seem to be any kind of equivelent that we can use here. Oracle DATE types only have a granularity of whole seconds. I will investigate whether or not we can get away with using a NUMBER type here. ---------------------------------------------------------------------- Comment By: Markus Kling (mkling) Date: 2002-04-06 16:30 Message: Logged In: YES user_id=360804 Up to version 8.1.7, Oracle supports only one temporal datatype: DATE, which has a granularity of second. The following datatypes are new for Oracle9i: TIMESTAMP TIMESTAMP [ (fractional_seconds_precision)] TIMESTAMP WITH [LOCAL]TIME ZONE INTERVAL YEAR TO MONTH INTERVAL DAY TO SECOND fractional_seconds_precision optionally specifies the number of digits in the fractional part of the SECOND datetime field and can be a number in the range 0 to 9. The default is 6. Below 9i date columns can be written and read as java.sql.Timestamp - the ms just get truncated. -Markus ---------------------------------------------------------------------- Comment By: Peter Levart (plevart) Date: 2002-04-06 16:10 Message: Logged In: YES user_id=346981 Are you sure? It works for me. It might be that this is a new feature of Oracle 9i (I haven't tried with Oracle 7 or 8). ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=538236&group_id=22866 |