Check this out
<local-tx-datasource>
<jndi-name>mySQLServerPool</jndi-name>
<connection-url>jdbc:microsoft:sqlserver://x.x.x.x:1433;DatabaseName=DBNAME;SelectMethod=cursor</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>xxxx</user-name>
xxxxxx
<min-pool-size>5</min-pool-size>
<max-pool-size>10</max-pool-size>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>15</idle-timeout-minutes>
<transaction-isolation>TRANSACTION_SERIALIZABLE</transaction-isolation>
</local-tx-datasource>
SelectMethod=cursor takes care of the connection pooling. Experts correct me if
I am wrong
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3862567#3862567
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3862567
-------------------------------------------------------
The SF.Net email is sponsored by: Beat the post-holiday blues
Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user
