怎么找不到mssql-ds.xml文件

Question

mssql-ds.xml在C:\JBOSS3.08\docs\examples\jca下,把它COPY到你C:\JBOSS3.08\server\default\deploy目录下,然后作些修改.

Answer 1

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
  <local-tx-datasource>
    <jndi-name>MSSQLDS</jndi-name> 
 <connection-url>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MyDatabase</connection-url>
    <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
    <user-name>x</user-name>
    <password>y</password>
      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
      <metadata>
         <type-mapping>MS SQLSERVER2000</type-mapping>
      </metadata>  </local-tx-datasource></datasources>修改对应的属性,一般修改jndi-name ,onnection-url, user-name, password.