[jboss-user] [JCA/JBoss] - Re: Seemingly random connection issues?
"weston.price(a)jboss.com" wrote : You need to post your *-ds.xml file as well as
the version and type of MSSQL driver. Also, MS-SQL version would be good as well.
|
| The exeption you are seeing is typically the result of a SQL not being about to be
executed on constructing a connection. This is usually specificied in your *-ds.xml file
as <new-connection-sql>SOME SQL</new-connection-sql>
|
|
Hi Weston,
Thanks for your response. Here is the mssql-ds.xml file:
| <datasources>
| <local-tx-datasource>
| <jndi-name>SystemDS</jndi-name>
|
<connection-url>jdbc:jtds:sqlserver://server-host:1433/dbname;SelectMethod=cursor</connection-url>
| <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
| <user-name>ZZZZZZ</user-name>
| <password>ZZZZZZ</password>
| <prepared-statement-cache-size>10000</prepared-statement-cache-size>
| <min-pool-size>10</min-pool-size>
| <max-pool-size>100</max-pool-size>
| <blocking-timeout-millis>5000</blocking-timeout-millis>
| <check-valid-connection-sql>select 1</check-valid-connection-sql>
| </local-tx-datasource>
| </datasources>
|
The version of the JTDS MS SQL driver used is the latest stable release, version 1.2. As
you can see the check-valid-connection-sql is specified.
Just to reiterate the JBoss version is 3.2.7. Because of this I don't think the
new-connection-sql option is available (I remember reading somewhere that this was a 4.0+
feature)?
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3973648#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...