SQLServer 2000 jdbc Driver

[silvia]

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

[alex_koshterek]

There's a connection option that you need to set in the URL, 'selectMethod=cursor', eg:

"jdbc:microsoft:sqlserver://dbmachine:1433;SelectMethod=cursor"

[silvia]

A lot of thanks, Alex.