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

    Jboss 4.01 - Configure Pool Connection for MSSQL 2000

    konrad1980

      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

        • 1. Re: Jboss 4.01 - Configure Pool Connection for MSSQL 2000

          Moderated: FAQ

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

            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
              cstefani

              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
                konrad1980

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


                Konrad