Menu
▾
▴
[jboss-cvs] jboss/src/etc/conf/default standardjbosscmp-jdbc.xml
|
From: Dain S. <dsu...@us...> - 2002-06-20 17:32:10
|
User: dsundstrom
Date: 02/06/20 10:32:08
Modified: src/etc/conf/default standardjbosscmp-jdbc.xml
Log:
Fixed java.util.Date mapping for all type-mappings. This type has both
date and time informations so we need to use a Timestamp mapping.
Revision Changes Path
1.36 +19 -11 jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml
Index: standardjbosscmp-jdbc.xml
===================================================================
RCS file: /cvsroot/jboss/jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml,v
retrieving revision 1.35
retrieving revision 1.36
diff -u -r1.35 -r1.36
--- standardjbosscmp-jdbc.xml 19 Jun 2002 14:56:42 -0000 1.35
+++ standardjbosscmp-jdbc.xml 20 Jun 2002 17:32:01 -0000 1.36
@@ -7,7 +7,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.35 2002/06/19 14:56:42 dsundstrom Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.36 2002/06/20 17:32:01 dsundstrom Exp $ -->
<jbosscmp-jdbc>
@@ -438,6 +438,10 @@
<sql-type>DATE</sql-type>
</mapping>
<mapping>
+ <!--
+ | Note that you lose granularity here
+ | Use a numeric type and store milliseconds if you really need it
+ -->
<java-type>java.sql.Timestamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>DATE</sql-type>
@@ -563,6 +567,10 @@
<sql-type>DATE</sql-type>
</mapping>
<mapping>
+ <!--
+ | Note that you lose granularity here
+ | Use a numeric type and store milliseconds if you really need it
+ -->
<java-type>java.sql.Timestamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>DATE</sql-type>
@@ -1144,8 +1152,8 @@
</mapping>
<mapping>
<java-type>java.util.Date</java-type>
- <jdbc-type>DATE</jdbc-type>
- <sql-type>DATE</sql-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
</mapping>
</type-mapping>
@@ -1377,7 +1385,7 @@
</mapping>
<mapping>
<java-type>java.util.Date</java-type>
- <jdbc-type>DATE</jdbc-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>DATETIME</sql-type>
</mapping>
<mapping>
@@ -1505,7 +1513,7 @@
<mapping>
<java-type>java.util.Date</java-type>
- <jdbc-type>DATE</jdbc-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>DATETIME</sql-type>
</mapping>
@@ -1559,8 +1567,8 @@
-->
<mapping>
<java-type>java.util.Date</java-type>
- <jdbc-type>DATE</jdbc-type>
- <sql-type>DATE</sql-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
</mapping>
<mapping>
<java-type>java.sql.Time</java-type>
@@ -1653,8 +1661,8 @@
</mapping>
<mapping>
<java-type>java.util.Date</java-type>
- <jdbc-type>DATE</jdbc-type>
- <sql-type>DATE</sql-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>TIMESTAMP</sql-type>
</mapping>
<mapping>
<java-type>java.sql.Time</java-type>
@@ -1847,8 +1855,8 @@
<mapping>
<java-type>java.util.Date</java-type>
- <jdbc-type>DATE</jdbc-type>
- <sql-type>DATE</sql-type>
+ <jdbc-type>TIMESTAMP</jdbc-type>
+ <sql-type>DATETIME YEAR TO FRACTION(3)</sql-type>
</mapping>
<mapping>
|
