Bugs item #518197, was opened at 2002-02-15 14:38 You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=518197&group_id=22866
Category: JBossCMP Group: v3.0 Rabbit Hole Status: Open Resolution: None Priority: 5 Submitted By: Matt (mpetteys) Assigned to: Nobody/Anonymous (nobody) Summary: Mysql / java.util.Date datatype mapping Initial Comment: The MySQL data type mapping for java.util.Date should be modified so the time data is not lost. Currently, the mapping is. <mapping> <java-type>java.util.Date</java-type> <jdbc-type>DATE</jdbc-type> <sql-type>DATETIME</sql-type> </mapping> It should be changed to.. <mapping> <java-type>java.util.Date</java-type> <jdbc-type>TIMESTAMP</jdbc-type> <sql-type>DATETIME</sql-type> </mapping> When you now set the field using a date, it is updated correctly in the database with the time being stored because the sql-type type is datetime but when you retrieve it the time is lost because the SQL type ignores the time data which is in the db. ======================================================= ============ RCS file: /cvsroot/jboss/jboss/src/etc/conf/default/standar djbosscmp-jdbc.xml,v retrieving revision 1.15 diff -r1.15 standardjbosscmp-jdbc.xml 840c840 < <jdbc-type>DATE</jdbc-type> --- > <jdbc-type>TIMESTAMP</jdbc-type> ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=518197&group_id=22866 _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
