Menu
▾
▴
[jboss-cvs] jboss/src/etc/conf/default standardjbosscmp-jdbc.xml
|
From: Dain S. <dsu...@us...> - 2002-06-20 17:35:14
|
User: dsundstrom
Date: 02/06/20 10:35:00
Modified: src/etc/conf/default Tag: Branch_3_0
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
No revision
No revision
1.23.2.12 +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.23.2.11
retrieving revision 1.23.2.12
diff -u -r1.23.2.11 -r1.23.2.12
--- standardjbosscmp-jdbc.xml 19 Jun 2002 23:57:40 -0000 1.23.2.11
+++ standardjbosscmp-jdbc.xml 20 Jun 2002 17:34:51 -0000 1.23.2.12
@@ -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>
|
