[jboss-user] [JCA/JBoss] - Re: Seemingly random connection issues?

[znbailey]

"weston.price at 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#3973648

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3973648