我用的是jboss4,数据源定义文件路径如下:
C:\jboss\server\default\deploy\mssql-ds.xml
mssql-ds.xml文件名称为必须,内容如下:<?xml version="1.0" encoding="UTF-8"?><!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== --><!-- $Id: mssql-ds.xml,v 1.3 2004/09/15 14:37:40 loubyansky Exp $ --> <!-- ======================================================================-->
<!-- New ConnectionManager setup for Microsoft SQL Server 2000 driver -->
<!-- You may download the latest Microsoft JDBC driver from *Microsoft* -->
<!-- http://msdn.microsoft.com/downloads/default.asp?url=/downloads/sample.asp?url=/MSDN-FILES/027/001/779/msdncompositedoc.xml&frame=true -->
<!-- ===================================================================== --><datasources>
<local-tx-datasource>
<jndi-name>myDataSource</jndi-name>
<connection-url>jdbc:microsoft:sqlserver://192.168.0.1:1433;DatabaseName=mydatabase</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>sa</user-name>
<password>sa</password>
<min-pool-size>10</min-pool-size>
<max-pool-size>200</max-pool-size>
<!-- 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>MS SQLSERVER2000</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
C:\jboss\server\default\deploy\mssql-ds.xml
mssql-ds.xml文件名称为必须,内容如下:<?xml version="1.0" encoding="UTF-8"?><!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== --><!-- $Id: mssql-ds.xml,v 1.3 2004/09/15 14:37:40 loubyansky Exp $ --> <!-- ======================================================================-->
<!-- New ConnectionManager setup for Microsoft SQL Server 2000 driver -->
<!-- You may download the latest Microsoft JDBC driver from *Microsoft* -->
<!-- http://msdn.microsoft.com/downloads/default.asp?url=/downloads/sample.asp?url=/MSDN-FILES/027/001/779/msdncompositedoc.xml&frame=true -->
<!-- ===================================================================== --><datasources>
<local-tx-datasource>
<jndi-name>myDataSource</jndi-name>
<connection-url>jdbc:microsoft:sqlserver://192.168.0.1:1433;DatabaseName=mydatabase</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>sa</user-name>
<password>sa</password>
<min-pool-size>10</min-pool-size>
<max-pool-size>200</max-pool-size>
<!-- 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>MS SQLSERVER2000</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
解决方案 »
- JSP网页如何插入JAVA对话框
- jxl写入excel的时候新数据将旧数据给覆盖掉了,怎么让新数据在旧数据尾部开始写入?????????
- Servlet超链接传参数的问题,求教!
- 读取spring配置出错!
- 和框架初学者分享我的学框架的经验
- jsp中的错误
- 关于JAVA如何在服务器端建立一个全局永久类实例得问题(低手莫入)
- 大家有intellij idea的使用资料吗?我连hello world都没能搞定,晕死了……100分
- 样向另一台机发送信息 (无内容)
- 使用struts的时候,怎么才能在页面打开的时候,form里面已经填入我所需要的值?
- javax.activation.UnsupportedDataTypeException: 用javamail碰到的异常,100分求解啊
- JAVA怎么样调用带返回记录集的存储过程(ORACLE)
DataSource ds = (DataSource)ctx.lookup("java:/MSSQLDS");
这个方法我以前就试过了,这是JBOSS所特有的JNDI方法,最好在EJB里不采用,是吧?因为要考虑组件和服务器的解耦,而且,这种jndi的方法也不行的,出现的错误也是一样的