XA Connection pool hangs after binding

[skadakia]

Hi,

I have installed JBoss-2.4.4_Tomcat-3.2.3. Trying to set DataSource for MS SQLServer on Windows 2000 using Atinav's TaveConn25C JDBC driver.

I have configured the jboss.jcml file by duplicating "DefaultDS" MBean and changed the settings appropriately, as shown here:


net.avenir.jdbc2.Driver



AIMDS
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl

jdbc:AvenirDriver://localhost:1433
1200000
sa
10

false
false
false
true
120000
1800000
false
false
1.0
0


There two problems, I'm facing:
1. [05:32:13,123,J2eeDeployer] Initialization failed
java.io.IOException: Failed to get /tmp.properties URL; Temporary directory does not exist!
at org.jboss.deployment.J2eeDeployer.initService(J2eeDeployer.java:337)
...

2. JBoss server seems to be hanged after the following statements:
[05:32:13,453,JdbcProvider] Starting
[05:32:13,463,JdbcProvider] Started
[05:32:13,463,AIMDS] Starting
[05:32:13,533,AIMDS] XA Connection pool AIMDS bound to java:/AIMDS

Your help in resolving these problems will be greatly appreciated.

Thanks.

Sundeep Kadakia

[davidjencks]

hanging here is usually due to wrong configuration parameters for the driver, so it can't get a connection. In particular your url looks somewhat doubtful.

[skadakia]

I really appreciate your reply. You pointed me in right direction. The Atinav driver does require to specify user and password along with url. So by specifying the following snippet in jboss.jcml file solved the problem.


net.avenir.jdbc2.Driver



AIMDS
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
jdbc:AvenirDriver://localhost:1433/aim;uid=sa;pwd=


I have found this information at this wonderful site by Suresh, http://personal.vsnl.com/sureshms/jboss.html. This site also describes configuration for other widely used JDBC drivers.

Cheers, long live JBoss..
Sundeep