I have to recommend that we do not distribute a mySQL mapping,
since currently any auto-created tables will not use transactions. There
will not even necessarily be any warning of that, since some pre-created
tables may be transactional, so the driver may go into non-auto-commit
mode, but then you may be using some transactional tables and some
non-transactional tables in the same query (which is totally allowed), and
I think this will be a disaster.
Please remove this mapping.
Aaron
On Wed, 8 Nov 2000, jBoss CVS Development wrote:
> User: salborini
> Date: 00/11/08 12:45:14
>
> Modified: src/etc/conf/default standardjaws.xml
> Log:
> Updated type mappings for mySql. tested and reported by Tobias Frech
> <[EMAIL PROTECTED]>
>
> Revision Changes Path
> 1.4 +15 -5 jboss/src/etc/conf/default/standardjaws.xml
>
> Index: standardjaws.xml
> ===================================================================
> RCS file: /products/cvs/ejboss/jboss/src/etc/conf/default/standardjaws.xml,v
> retrieving revision 1.3
> retrieving revision 1.4
> diff -u -r1.3 -r1.4
> --- standardjaws.xml 2000/11/07 12:14:12 1.3
> +++ standardjaws.xml 2000/11/08 20:45:13 1.4
> @@ -691,7 +691,7 @@
> </mapping>
> <mapping>
> <java-type>java.lang.Object</java-type>
> - <jdbc-type>BLOB</jdbc-type>
> + <jdbc-type>JAVA_OBJECT</jdbc-type>
> <sql-type>BLOB</sql-type>
> </mapping>
> <mapping>
> @@ -701,8 +701,8 @@
> </mapping>
> <mapping>
> <java-type>java.lang.Short</java-type>
> - <jdbc-type>INTEGER</jdbc-type>
> - <sql-type>INTEGER</sql-type>
> + <jdbc-type>SMALLINT</jdbc-type>
> + <sql-type>SMALLINT</sql-type>
> </mapping>
> <mapping>
> <java-type>java.sql.Timestamp</java-type>
> @@ -727,12 +727,22 @@
> <mapping>
> <java-type>java.lang.String</java-type>
> <jdbc-type>VARCHAR</jdbc-type>
> - <sql-type>VARCHAR(256)</sql-type>
> + <sql-type>VARCHAR(255)</sql-type>
> </mapping>
> <mapping>
> <java-type>java.util.Date</java-type>
> <jdbc-type>DATE</jdbc-type>
> - <sql-type>DATE</sql-type>
> + <sql-type>DATETIME</sql-type>
> + </mapping>
> + <mapping>
> + <java-type>java.util.Date</java-type>
> + <jdbc-type>DATE</jdbc-type>
> + <sql-type>DATETIME</sql-type>
> + </mapping>
> + <mapping>
> + <java-type>java.sql.Time</java-type>
> + <jdbc-type>TIME</jdbc-type>
> + <sql-type>BIGINT</sql-type>
> </mapping>
> </type-mapping>
> <type-mapping>
>
>
>
>
