4 Replies Latest reply on Jan 11, 2005 3:34 AM by 234 234

    Jboss 4.01 - Configure Pool Connection for MSSQL 2000

    234 234 Newbie

      How Configure Connection Pool for MSSQLSERWER 2000?
      Documentaction for Jboss 4.01 is bad Becouse lack me many class in jboss-jca.jar which are describe in Documentation for Jboss 4.01
      Example:
      org.jboss.resource.connectionmanager.NoTxConnectionManager
      Maby somebody have example of mssql-service.xml file.

      Thanks for help
      Konrad

        • 2. Re: Jboss 4.01 - Configure Pool Connection for MSSQL 2000
          234 234 Newbie

          I confugre pollconnection
          mssql-service.xml:

          <?xml version="1.0" encoding="UTF-8"?>


          <depends optional-attribute-name="ManagedConnectionFactoryName">

          sqlserverNoTxDS


          <config-property name="ConnectionURL" type="java.lang.String">jdbc:microsoft:sqlserver://serwer;DatabaseName=my_base;SelectMethod=direct</config-property>
          <config-property name="DriverClass" type="java.lang.String">com.microsoft.jdbc.sqlserver.SQLServerDriver</config-property>
          <config-property name="UserName" type="java.lang.String">sa</config-property>
          <config-property name="Password" type="java.lang.String"></config-property>



          <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper


          <depends optional-attribute-name="ManagedConnectionPool">

          0
          50
          5000
          15
          ByContainer


          <depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager
          <depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager
          jboss.jca:service=RARDeployer



          But when I deploy this file jboss shout me exception:

          ObjectName: jboss.jca:name=06NoTxDS,service=NoTxDS
          state: FAILED
          I Depend On:
          Depends On Me: jboss.jca:name=06NoTxDS,service=NoTxCM
          org.jboss.deployment.DeploymentException: No Attribute found with name: JndiName

          What i make wrong?

          Thanks


          • 3. Re: Jboss 4.01 - Configure Pool Connection for MSSQL 2000
            Colin Stefani Newbie

            If this is an exerpt from your service file, check your spelling of "server" (I see being spelled as "serwer")

            -c

            • 4. Re: Jboss 4.01 - Configure Pool Connection for MSSQL 2000
              234 234 Newbie

              Oh I am sorry.
              But when I insert source of msssql-service.xml,
              Forums shows this file like in topic up.


              Konrad