3 Replies Latest reply on Mar 4, 2003 6:14 AM by Anthony Cavanagh

    Setting up MS SQL Server with JBoss

    Anthony Cavanagh Newbie

      Hi I have just started using JBoss today, amd I am trying to set up a MS SQL Server 7 database as a datasource.

      I am following the document Using MS SQL Server with JBoss.

      But have run into a problem, according to the doc, I need to add my driver to the file jboss.jcml.

      But this file does not exist in my vesrion of JBoss.
      jboss-3.2.0RC2_tomcat.4.1.18.

      Can anyone tell me what the new name is or where I can down load the docs that go with this version.

      I did download getting started with Vesrion 3, but it was not very helpful where setting up datasources was concerned.

      Thanks for any help Tony

        • 1. Re: Setting up MS SQL Server with JBoss
          Anthony Cavanagh Newbie

          Further investigation has revealed the following files in the examples directory:

          mssql-ds.xml
          mssql-service.xml
          mssql-xa-ds.xml
          mssql-xa-service.xml

          I guess the way forward is to copy these into the JBOSS server directory and modify them for my use.

          I am not sure where they should be copied to, I guess it should be the


          C:\jboss-3.2.0RC2_tomcat.4.1.18\server\default\conf directory, as this contains all the xml files that are needed at start-up.

          Am I correct in this thanks for any help.

          Cheers Tony

          • 2. Re: Setting up MS SQL Server with JBoss
            Hans Newbie

            > Further investigation has revealed the following
            > files in the examples directory:
            >
            > mssql-ds.xml
            > mssql-service.xml
            > mssql-xa-ds.xml
            > mssql-xa-service.xml
            >
            > I guess the way forward is to copy these into the
            > JBOSS server directory and modify them for my use.
            >
            > I am not sure where they should be copied to, I guess
            > it should be the
            >
            You sould copy the mssql-xxx.xml to $JBOSS_HOME/server/all(or default,minimal)/deploy/ and modify the parameter.
            It should work.
            >
            > C:\jboss-3.2.0RC2_tomcat.4.1.18\server\default\conf
            > directory, as this contains all the xml files that
            > are needed at start-up.
            >
            > Am I correct in this thanks for any help.
            >
            > Cheers Tony

            • 3. Re: Setting up MS SQL Server with JBoss
              Anthony Cavanagh Newbie

              Thanks for the help. that helped a lot.

              Cheers Tony