2 Replies Latest reply on Jan 24, 2003 6:38 AM by Guru Munde

    MS SQLServer2000 set up

    Guru Munde Newbie

      Hi

      Please can someone help me to enable my CMP entity bean communicate with MS SQLServer2000 database.

      What JBoss files do I need to change?
      What are the changes that I have to make?
      Where does the jdbc driver live?
      Where can I get the jdbc driver?
      etc, etc, etc

      I am a complete novice (just been on a course) and never done this before. I hope that there is a J2EE Guru out there?

      Thanks in advance

        • 1. Re: MS SQLServer2000 set up
          Lirox Newbie

          follow me!
          1:copy mssql-service.xml from jboss-3.0.4_tomcat-4.0.6\docs\examples\jca to jboss-3.0.4_tomcat-4.0.6\server\default\deploy
          2:open it via notepad.
          find following lines.

          MSSQLDS



          <config-property name="ConnectionURL" type="java.lang.String">jdbc:microsoft:sqlserver://localhost:1433;DatabaseName= YOURDATABASE!!!! </config-property>
          <config-property name="DriverClass" type="java.lang.String">com.microsoft.jdbc.sqlserver.SQLServerDriver</config-property>
          <!--set these only if you want only default logins, not through JAAS-->
          <config-property name="UserName" type="java.lang.String">USERNAME!!!!</config-property>
          <config-property name="Password" type="java.lang.String">PASSWORD!!!!!</config-property>


          3. change databaseName,UserName and Password!!!
          4. copy msbase.jar,mssqlserver.jar,msutil.jar (download from M$)
          to jboss-3.0.4_tomcat-4.0.6\server\default\deploy\lib
          5. notice. default JndiName is "MSSQLDS"!
          6. good luck &&& enjoy it !

          • 2. Re: MS SQLServer2000 set up
            Guru Munde Newbie

            Thanks for your reply. I will follow the steps. Before I do, will the MS JDBC Driver work with JBoss running on Windows NT?