[JBoss-dev] [ jboss-Bugs-538236 ] Oracle data mappings use TIMESTAMP type

[<no...@so...>]

Bugs item #538236, was opened at 2002-04-02 11: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: Peter Levart (plevart)
Date: 2002-04-06 18: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