3 Replies Latest reply on Apr 25, 2002 12:29 PM by Grzeschik, Peter

    Problem with configuring datasource for CMP 2.0 (Please repl

    TJ Newbie

      hi;
      I tried to use CMP with JBOSS 3.0 beta with MS SQL Server 2000 but when I do insert into the database using CMP Bean, it inserts into hypersonic database instead of MS SQL Server. I have used session bean accessing BMP bean to do the same and it works fine.
      Below here is the configuration file (mssql2000-service.xml) :




      ConnectionURL=jdbc:JSQLConnect://localhost:1433/test
      userName = sa


      DriverClass=com.jnetdirect.jsql.JSQLDriver

      SQLServerDS
      java:/TransactionManager


      <depends optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter
      <depends optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory



      MinSize=0
      MaxSize=100
      BlockingTimeoutMillis=5000
      IdleTimeoutMinutes=30
      CleanupIntervalMinutes=10
      MaxIdleTimeoutPercent=1.0


      org.jboss.resource.security.ManyToOnePrincipalMapping


      userName=sa
      password=