0 Replies Latest reply on Oct 9, 2002 2:53 PM by y_bhakta

    Creating non XA DataSource with Jboss 2.4.9

    y_bhakta

      Hi

      I am currently try to use Jboss 2.4.9, but the below configuration works fine with jboss 2.4.6.

      My DataSource configuration is described below creates DataSource fine and registered in JNDI fine, but when I try to get connection from this DataSource it gives the error "No matched connections available".


      iSpring
      com.inet.tds.TdsDataSource

      jdbc:inetdae7a:tiger?prepare=false&database=ispring
      1200000
      octet
      50
      octet
      false
      false
      false
      true
      120000
      1800000
      false
      false
      1.0
      0
      false
      false


      If I give XADataSourceLoader incaseof JDBCDataSourceLoader it works fine, but I don't want XADataSource to created as I am handling the transactions manually and don't want the transaction always.
      Below is the DataSource cnfiguration.


      iSpring
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
      jdbc:inetdae7a:tiger?prepare=false&database=ispring
      1200000
      octet
      50
      octet
      false
      false
      false
      true
      120000
      1800000
      false
      false
      1.0
      5
      <!-- release on commit will release connections created within a transaction
      whenever the transaction is committed or rolledback -->
      false
      <!-- save stack trace will remember the point where a connection was created.
      Only use with ReleaseOnCommit!! If a release on commmit happens,
      you will get a stack trace of where the connection was created AND
      NOT released. -->
      false


      Thanks
      Bhakta.