0 Replies Latest reply on Sep 25, 2001 7:42 AM by Chandu

    Problem creating a table with a Date field in CMP on MS SQL

    Chandu Newbie

      Hello World,
      I am trying to deploy a Simple CMP bean with a java.sql.Date field as one of the properties. The bean get deployed without any problems. But doesnt create any table in the MS SQLServer database. The driver I am using is Opta2000. The changes in the jboss.jcml file is included below:

      <!-- JDBC -->

      com.inet.tds.TdsDriver



      DefaultDS
      org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl
      jdbc:inetdae7:debut:1433?database=master
      sa



      where debut is the system name where my MS SQL Server 7.0 resides.I have also tried with the jaws.xml in the bean. But that too doesnt work. The same bean works fine for Oracle 8i database. The problem exists only for the SQL Server database and only for the Date field. Does the jboss2.2.2 CMP has problems with the Date field? Or does the Opta2000 Driver has problems with the Date field? I would be grateful if anyone can suggest me a way out of this.
      Thanx in advance.
      Chandu.