4 Replies Latest reply on Feb 27, 2002 11:02 AM by Elsholz

    [jboss 3.0]Connection to MSSQL-Database

    Elsholz Newbie

      Hi,

      i have problems to create a connection to my MSSQL-Database:

      this file i put in deploy:

      <?xml version="1.0" encoding="UTF-8"?>
      <!-- $Id: mssql-service.xml,v 1.2 2002/01/14 00:16:51 d_jencks Exp $ -->

      <!-- =====================================================================-->
      <!-- mssql-service.xml -->
      <!-- JBoss v3.0alpha (november 23, 2001) ATINAV thin driver Configuration -->
      <!-- tested against MS SQL 2000 -->
      <!-- =====================================================================-->
      <!-- -->
      <!-- please put jdbc driver (in this case TaveConn25C.jar) under -->
      <!-- jboss_home/lib/ext -->
      <!-- please put this file (mssqlds-service.xml) under jboss_home/deploy -->
      <!-- The atinav driver is from -->
      <!-- http://www.atinav.com/products/aveconnect/aveconnect.htm -->
      <!-- This configuration is contributed by Alex Pavlov apavlov@ma.us.mks.com -->
      <!-- =====================================================================-->







      ConnectionURL=jdbc:AvenirDriver://coffein.ps.lan:1433/TEST;uid=sa;pwd=
      DriverClass=net.avenir.jdbc2.Driver

      MSSQL2000DS
      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
      #
      #Wed Aug 15 16:17:29 EDT 2001
      BlockingTimeoutMillis=50000
      IdleTimeoutMinutes=30
      MaxSize=10
      CleanupIntervalMinutes=10
      MinSize=0
      MaxIdleTimeoutPercent=1.0


      org.jboss.resource.security.ManyToOnePrincipalMapping

      userName=sa
      password=



      but i get this Error:

      [11:25:46,108,ContainerFactory] Deploying CDBean
      [11:25:48,231,DefaultDS] Unable to create ManagedConnection:
      javax.resource.ResourceException: Unable to create DB connection for url: jdbc:hsqldb:hsql://localhost:1476, user: sa, exception: java.sql.SQLException: ot found: SA

      whats wrong???

      alex