In the standardjbosscmp-jdbc.xml file, for a MS SQL Server database, the java.sql.Timestamp type is mapped to a MS SQL Server TIMESTAMP file.

However, the MS SQL Server TIMESTAMP type is specific to MS SQL Server, it is not compatible with the SQL '92 TIMESTAMP type. In fact, it is some sort of auto-number field, and only one column per table can be of this type.

The MS SQL Server JDBC driver documentation translates the JDBC type TIMESTAMP into the MS SQL Server type SMALLDATETIME.

Should the mapping in the standardjbosscmp-jdbc.xml then not be:


<java-type>java.sql.Timestamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>SMALLDATETIME</sql-type>