Hello, I'm trying to run JBoss 4.03SP1 together with MS SQLSERVER 2000 for a company page using JSP. But I'm stuck on configuring the database.
I donwloaded and installed the JDBC drivers for MSSQL2000. my mssql-ds.xml looks as follows: | <datasources> | <local-tx-datasource> | <jndi-name>MSSQLSERVER2000</jndi-name> | <connection-url>jdbc:microsoft:sqlserver://w2k-praktikant\webfactory;SelectMethod=cursor;DatabaseName=KVN_Allershausen</connection-url> | <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class> | <user-name>sa</user-name> | <password>webfactory</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>some arbitrary sql</check-valid-connection-sql> | --> | <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --> | <metadata> | <type-mapping>MSSQLSERVER2000</type-mapping> | </metadata> | </local-tx-datasource> | | </datasources> I changed the standardjbosscmp-jdbc.xml maybe that isnt such a good idea? in it i changed: | <datasource>MSSQLDS</datasource> | <datasource-mapping>MSSQLSERVER2000</datasource-mapping> | nothing else changed. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3926730#3926730 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3926730 ------------------------------------------------------- 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
