Just wanted to follow up to this for anyone else who finds it to say "It worked for me, too." Here's an example of a the full mssql-ds.xml file:
| <datasources> | <local-tx-datasource> | <jndi-name>MSSQLDS</jndi-name> | <connection-url>jdbc:microsoft:sqlserver://MyServer;DatabaseName=MyDatabase</connection-url> | <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class> | <user-name>MyUser</user-name> | <password>MyPassword</password> | <!-- sql to call when connection is created | <new-connection-sql>some arbitrary sql</new-connection-sql> | --> | <!-- sql to call on an existing pooled connection when it is obtained from pool --> | <check-valid-connection-sql>Select 1</check-valid-connection-sql> | <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --> | <metadata> | <type-mapping>MS SQLSERVER2000</type-mapping> | </metadata> | <connection-property name="SelectMethod">cursor</connection-property> | </local-tx-datasource> | </datasources> | Once I added the SelectMethod to be cursor, all the tables were created and populated as specified in mssql-jdbc2-service.xml and mssqldb-jdbc-state-service.xml. Now that JBoss and Microsoft are cooperating, I'm sure the example mssql-ds.xml will be updated, right...? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3928309#3928309 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3928309 ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
