0 Replies Latest reply on Oct 4, 2002 4:17 AM by Koen Rousseau

    MS SQL Server 2000

    Koen Rousseau Newbie

      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>