首先把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();
}
%>
是不是相当于server/default/deploy/hsqldb-service.xml ?
为什么还要修改standardjbosscmp-jdbc.xml ,我没有写cmp啊?
没有写cmp,是不是后面两个xml不要设置?
望指教!!