6 Replies Latest reply on Jun 30, 2007 2:30 PM by jaikiran

    [Microsoft][SQLServer 2000 Driver for JDBC]Database changed

    ruchi123456

      I am using SQL Server database. I am trying to connect to database name userscdb

      I am using jsf and ejb3

      Everytime my application connects to sqlsever, i get below mentioned warnings
      16:52:23,107 INFO [STDOUT] value of em is org.jboss.ejb3.entity.TransactionScopedEntityManager@1b6847a
      16:52:23,148 WARN [JDBCExceptionReporter] SQL Warning: 0, SQLState:
      16:52:23,148 WARN [JDBCExceptionReporter] [Microsoft][SQLServer 2000 Driver for JDBC]Database changed to master
      16:52:23,148 WARN [JDBCExceptionReporter] SQL Warning: 5701, SQLState: 01000
      16:52:23,148 WARN [JDBCExceptionReporter] [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Changed database context to 'master'.
      16:52:23,148 WARN [JDBCExceptionReporter] SQL Warning: 0, SQLState:
      16:52:23,148 WARN [JDBCExceptionReporter] [Microsoft][SQLServer 2000 Driver for JDBC]Language changed to us_english
      16:52:23,148 WARN [JDBCExceptionReporter] SQL Warning: 5703, SQLState: 01000
      16:52:23,148 WARN [JDBCExceptionReporter] [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Changed language setting to us_english.
      16:52:23,148 WARN [JDBCExceptionReporter] SQL Error: 208, SQLState: 42S02

      Thus here my database changes to master everytime, although i want to connect to userscdb

      ------------------------------------
      Below is the configuration of my application

      persistence.xml placed in META-INF directory
      <?xml version="1.0" encoding="UTF-8"?>

      <persistence-unit name="shoestringPU">
      <jta-data-source>java:/SCMSSQLDS</jta-data-source>
      com.j3ltd.server.entities.Person
      com.j3ltd.server.entities.Address



      </persistence-unit>



      mssql-ds.xml

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

      <!-- ===================================================================== -->
      <!-- -->
      <!-- JBoss Server Configuration -->
      <!-- -->
      <!-- ===================================================================== -->

      <!-- $Id: mssql-ds.xml 23720 2004-09-15 14:37:40Z loubyansky $ -->

      <!--

      ======================================================================-->
      <!-- New ConnectionManager setup for Microsoft SQL Server 2000 driver

      -->
      <!-- You may download the latest Microsoft JDBC driver from *Microsoft*

      -->
      <!--

      http://msdn.microsoft.com/downloads/default.asp?url=/downloads/sample.asp?url=/

      MSDN-FILES/027/001/779/msdncompositedoc.xml&frame=true -->
      <!-- =====================================================================

      -->


      <local-tx-datasource>
      <jndi-name>SCMSSQLDS</jndi-name>

      <connection-url>jdbc:microsoft:sqlserver://dbsqlserver\\devenv:1433;DatabaseName=userscdb</connection-url>
      <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>

      <user-name>kkism</user-name>
      kkism
      <!-- sql to call when connection is created
      <new-connection-sql>some arbitrary sql</new-connection-sql>
      -->

      <!-- sql to call on an existing pooled connection when it is obtained

      from pool
      <check-valid-connection-sql>some arbitrary

      sql</check-valid-connection-sql>
      -->

      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml

      (optional) -->

      <type-mapping>MS SQLSERVER2000</type-mapping>

      </local-tx-datasource>




      Below is my class using entity bean
      public class EntityFacadeBean implements EntityFacade{
      @PersistenceContext(unitName="shoestringPU") EntityManager em ;

      public Person getPerson(String email) {
      Person entity = null;
      try {
      Query query = em.createQuery("SELECT p FROM Person p WHERE p.email = ?1");
      query.setParameter(1, email);
      entity = (Person) query.getSingleResult();
      }
      catch (NoResultException noneFound) {
      // if not found, just return null
      }
      return entity;
      }

      }

      Please suggest if i am doing anything wrong.

      Regards,
      Ruchika