2 Replies Latest reply on Dec 11, 2001 10:07 AM by silvia

    SQLServer 2000 jdbc Driver

    silvia Newbie

      I'm using SQLServer 2000 jdbc Driver with JBoss 2.4.3-Tomcat 2.3.2.
      I've published the connection pool in JBoss with the XADataSourceLoader as follows:


      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
      java:/SQLServerPool
      jdbc:microsoft:sqlserver://192.168.1.31:1433;user=GRUPO;password=FINAF92
      DataBaseName=FINAF


      1200000
      10
      false
      false
      false
      true
      120000
      1800000
      false
      false
      1.0
      0



      I'm usin BMT Stateless Session Beans.
      With this configuration of the pool, I can only create ONE!! statement or preparedStatement object for a ONE!! connection object. If I try to create another object with the same connection, I obtain this error:

      Can't star a cloned connection while in manual transaction mode.


      Is there anyone who know how what's my problem ? How can I configurate the pool correctly in JBoss 2.4.3?

      Thanks.
      Silvia