"[EMAIL PROTECTED]" 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 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
