首先把sql server jdbc driver copy \common\lib下
我刚配上的如下:
-----------------------------------------------------------------------mssql-ds.xml
<datasources>
<local-tx-datasource>
<jndi-name>jdbc/test</jndi-name>
<connection-url>jdbc:microsoft:sqlserver://10.1.1.192:1433;DatabaseName=TEST</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>sa</user-name>
<password>sa</password>
</local-tx-datasource></datasources>
-----------------------------------------------------------------------standardjbosscmp-jdbc.xml
<datasource>java:/jdbc/test</datasource>
<datasource-mapping>MS SQLSERVER2000</datasource-mapping>
-----------------------------------------------------------------------
standardjaws.xml
<datasource>java:/jdbc/test</datasource>
<type-mapping>MS SQLSERVER2000</type-mapping>
<debug>false</debug>
测试:<%@page language="java" contentType="text/html;"%>
<%@page import="java.sql.*,javax.naming.Context,javax.naming.InitialContext"%>
<%@page import="javax.sql.DataSource"%>
<%
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
Context initCtx = new InitialContext();
DataSource ds = (DataSource)initCtx.lookup("java:/jdbc/test");
conn = ds.getConnection();
if (conn != null)
out.println("ok");
else
out.println("error");
} catch(Exception ex) {
out.println(ex.getMessage());
} finally {
if (conn != null) conn.close();
}
%>
我刚配上的如下:
-----------------------------------------------------------------------mssql-ds.xml
<datasources>
<local-tx-datasource>
<jndi-name>jdbc/test</jndi-name>
<connection-url>jdbc:microsoft:sqlserver://10.1.1.192:1433;DatabaseName=TEST</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<user-name>sa</user-name>
<password>sa</password>
</local-tx-datasource></datasources>
-----------------------------------------------------------------------standardjbosscmp-jdbc.xml
<datasource>java:/jdbc/test</datasource>
<datasource-mapping>MS SQLSERVER2000</datasource-mapping>
-----------------------------------------------------------------------
standardjaws.xml
<datasource>java:/jdbc/test</datasource>
<type-mapping>MS SQLSERVER2000</type-mapping>
<debug>false</debug>
测试:<%@page language="java" contentType="text/html;"%>
<%@page import="java.sql.*,javax.naming.Context,javax.naming.InitialContext"%>
<%@page import="javax.sql.DataSource"%>
<%
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
Context initCtx = new InitialContext();
DataSource ds = (DataSource)initCtx.lookup("java:/jdbc/test");
conn = ds.getConnection();
if (conn != null)
out.println("ok");
else
out.println("error");
} catch(Exception ex) {
out.println(ex.getMessage());
} finally {
if (conn != null) conn.close();
}
%>
解决方案 »
- You cannot set autocommit during a managed transaction
- hibernae annotations inverse问题
- DOMParser的一个解析问题(parse)
- 项目中hibernate插入数据问题
- 怎么在struts2中执行<result>返回的页面
- 怎么使用WSS4J API进行对消息解密
- spring+flex集成
- 为什么tomcat不能打开html文件?
- 使用WSDL2Java报错
- 什么是Socket协议
- 请问一个sql server数据源配置问题
- 帮忙,救命啊--struts+hibernate在tomcat下开发OK,移植到websphare下就有了问题
我是问mssal-xa-ds的用法!!