Article:
  Configuring JBoss 4.0 JDBC Connectivity
Subject:   SQL Server 2000
Date:   2004-03-10 12:19:58
From:   razmaspaz
Does anyone know how to configure for SQL Server 2000 using the ms jdbc driver?
Full Threads Oldest First

Showing messages 1 through 7 of 7.

  • SQL Server 2000
    2005-12-29 15:34:04  helica [View]

  • SQL Server 2000
    2005-11-22 02:58:38  gamle01 [View]

    Hi,
    How should I configure 2 different datasources for MSSQL Server connection, in the same standardjbosscmp-jdbc.xml and other config files?
    I've tried this but it doesn't work...
    <defaults>
    <datasource>java:/DEMODS</datasource>
    <datasource>java:/DEMO2DS</datasource>
    <datasource-mapping>MS SQLSERVER2000</datasource-mapping>
    ....

    thanks in advance.
    cheers,
    g
    • SQL Server 2000
      2005-11-22 07:29:04  Deepak Vohra | [View]

      The <defaults/> elements may have only one <datasource/> element.
  • SQL Server 2000
    2004-05-13 05:50:04  Deepak Vohra | [View]

    MS SQL Server Database Configuration


    To configure JBoss 4.0 with MS SQL Server database, MS SQL Server driver classes are required in the Classpath.Copy MS SQL Server JDBC driver class jar files mssqlserver.jar, msbase.jar, msutil.jar to the server/default/lib dir. To configure with non-xa MS SQL Server datasource copy /docs/examples/jca/mssql-ds.xml to /server/default/deploy dir. To configure with MS SQL Server XA datasource copy /docs/examples/jca/mssql-xa-ds.xml to /server/default/deploy dir. Modify mssql-ds.xml configuration file. Driver Class and Connection URL settings for MS SQL Server JDBC Drivers
    Driver Class: com.microsoft.jdbc.sqlserver.SQLServerDriver
    Connection URL:jdbc:microsoft:sqlserver://localhost:1433;
    DatabaseName=MyDatabase
    To configure with XA JDBC driver for MS SQL Server modify the mssql-xa-ds.xml configuration file.
    Driver Class: com.microsoft.jdbcx.sqlserver.SQLServerDataSource
    The standardjaws.xml file is configured with Hypersonic database by default. To configure JBoss server with MS SQL Server database modify /server/default/conf/standardjaws.xml configuration file. Set <datasource> and <type-mapping> elements.

    <jaws>
    <datasource>java:/MSSQLDS</datasource>
    <type-mapping>MS SQLSERVER2000</type-mapping>
    </jaws>

    The standardjbosscmp-jdbc.xml configuration file is configured with Hypersonic database. To configure JBoss server with MS SQL Server modify /server/default/conf/standardjbosscmp-jdbc.xml configuration file. Set the <datasource> and <datasource-mapping> elements.

    <jbosscmp-jdbc>
    <defaults>
    <datasource>java:/MSSQLDS</datasource>
    <datasource-mapping>MS SQLSERVER2000</datasource-mapping>
    </defaults>
    </jbosscmp-jdbc>


    Modify login-config.xml configuration file with MS SQL Server database settings. Add the following <application-policy/> element to login-config.xml.

    <application-policy name = "MSSQLDbRealm">
    <authentication>
    <login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule" flag = "required">
    <module-option name = "principal">sa</module-option>
    <module-option name = "userName">sa</module-option>
    <module-option name = "password"></module-option>
    <module-option name ="managedConnectionFactoryName">
    jboss.jca:service=LocalTxCM,name=MSSQLDS
    </module-option>
    </login-module>
    </authentication>
    </application-policy>


    By modifying the mssql-ds.xml, standardjaws.xml, standardjbosscmp-jdbc.xml and login-config.xml the JBoss 4.0 server is configured to be used with a MS SQL Server database.
    • SQL Server 2000
      2004-10-11 02:46:18  HemantJoshi [View]

      Dear Sir,

      I have followed instructions given as above. I am still having problem using it with SQL Server 2000.

      Could you possible email dummy files for SQL server 2000.

      Much appreciated.

      Kind Regards
      Hemant

      • SQL Server 2000
        2004-10-11 05:16:02  Deepak Vohra | [View]


        What is the configuration error you are getting? Please post detail.

        thanks,
        Deepak
        • SQL Server 2000
          2005-03-30 20:18:39  kalparser [View]

          The Hibernat-service.xml is like this:
          <server>
          <mbean code="org.jboss.hibernate.jmx.Hibernate"
          name="jboss.har:service=Hibernate">
          <attribute name="DatasourceName">java:MSSQLDS</attribute>
          <attribute name="Dialect">net.sf.hibernate.dialect.HSQLDialect</attribute>
          <attribute name="SessionFactoryName">java:/hibernate/SessionFactory</attribute>
          <attribute name="CacheProviderClass">
          net.sf.hibernate.cache.HashtableCacheProvider
          </attribute>
          </mbean>
          </server>

          And I create the session from a session bean:
          SessionFactory sf = (SessionFactory)ctx.lookup("java:/hibernate/SessionFactory");

          I got exception as below:
          javax.naming.NameNotFoundException: hibernate
          not bound


          Need help urgently!!
          Thanks!