4 Replies Latest reply on Dec 13, 2001 6:30 PM by Matt Hicks

    Please help with SQL Server 2000 Mapping

    Matt Hicks Newbie

      I am getting an error running the CMP 2.0 EJB tests with SQL Server 2000 and jboss3.0 using the Microsoft JDBC Driver. All of the tables get created and the column names that do not have specified types get mapped to BigInt(8). Also, populating the tables works. However, on any calls that return objects from the database, SQLExceptions are thrown. This is an example from the server log of a call that failed (the ORDER_NUMBER column is of type BigInt(8)):

      [2001-12-13 01:10:36,640,CMP,DEBUG] findAll command executing: SELECT t1_o.ORDER_NUMBER FROM ORDER_DATA t1_o
      [2001-12-13 01:10:36,640,MSSQL2000DS,DEBUG] Pool MSSQL2000DS created a new object: org.jboss.resource.adapter.jdbc.local.JDBCManagedConnection@ab6c1c
      [2001-12-13 01:10:36,656,MSSQL2000DS,DEBUG] Pool MSSQL2000DS [0/5/10] destroyed object org.jboss.resource.adapter.jdbc.local.JDBCManagedConnection@7a140f.
      [2001-12-13 01:10:36,656,CMP,DEBUG] java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Unhandled data type: TDS_INT8
      [2001-12-13 01:10:36,656,Default,ERROR] java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Unhandled data type: TDS_INT8
      [2001-12-13 01:10:36,656,Default,ERROR] at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

      Could anyone please give me some direction as to how to change the type mappings or explain to me what is happening? Thank you very much