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-nameMSSQLDS/jndi-name
|
connection-urljdbc:microsoft:sqlserver://MyServer;DatabaseName=MyDatabase/connection-url
|
driver-classcom.microsoft.jdbc.sqlserver.SQLServerDriver/driver-class
| user-nameMyUser/user-name
| passwordMyPassword/password
| !-- sql to call when connection is created
| new-connection-sqlsome arbitrary sql/new-connection-sql
| --
| !-- sql to call on an existing pooled connection when it is obtained
from pool --
| check-valid-connection-sqlSelect 1/check-valid-connection-sql
| !-- corresponding type-mapping in the standardjbosscmp-jdbc.xml
(optional) --
| metadata
| type-mappingMS SQLSERVER2000/type-mapping
| /metadata
| connection-property name=SelectMethodcursor/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=bbop=viewtopicp=3928309#3928309
Reply to the post :
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=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=lnkkid=110944bid=241720dat=121642
___
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user