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.