以下设置在Sun Java System Application Server Platform Edition 8.1_02 (build b06-fcs)上设置成功
(配置Oracle9连接池)
1.1.名称:Oracle9Pool
1.2.资源类型:javax.sql.DataSource
1.3.数据库供应商:oracle
2.1.数据库源类名:oracle.jdbc.pool.OracleDataSource
3.1.“池设置”、“连接验证”、“事务隔离”使用默认值
3.2.“属性”保留三项:URL: jdbc:oracle:thin:@xxx.xxx.xxx.xxx:1521:orcl
Password:yourpass
User: yourname
以下可以继续配置数据源, 并可用下列代码测试.
<%@page contentType="text/html"%>
<%@page pageEncoding="GBK" import="java.sql.*,javax.sql.*,javax.naming.*"%>
<html>
<head>
<title>JSP Page</title>
</head>
<body>
<h1>JSP Page</h1>
<%
InitialContext ic = new InitialContext();
DataSource ds = (DataSource)ic.lookup("jdbc/Oracle9Pool");
//注意上面一行: 与tomcat不同, 不是"java:/comp/env/jdbc/Oracle9Pool"
Connection conn = ds.getConnection();
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("select * from xxzxuid");
while (rs.next()){
out.print(rs.getString(3));
}
rs.close();
st.close();
conn.close();
%>
</body>
</html>
==============================================================================================
以下设置在Sun Java System Application Server Platform Edition 8.1_02 (build b06-fcs)上设置成功
(配置mySQL连接池)
1.1.名称:mysqlPool
1.2.资源类型:javax.sql.ConnectionPoolDataSource
1.3.数据库供应商:mysql
2.1.数据库源类名:com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource
3.1.“池设置”、“连接验证”、“事务隔离”使用默认值
3.2.“属性”保留五项:databasename: yourDB (对应mysql中的schemata,默认的数据库)
serverName: localhost
port: 3306
Password: yourpass
User: yourname
==============================================================================================
以下设置在Sun Java System Application Server Platform Edition 8.1_02 (build b06-fcs)上设置成功
(配置ms SQL Server连接池)
1.1.名称:mssqlPool
1.2.资源类型:javax.sql.DataSource
1.3.数据库供应商:mssql
2.1.数据库源类名:com.microsoft.jdbcx.sqlserver.SQLServerDataSource
3.1.“池设置”、“连接验证”、“事务隔离”使用默认值
3.2.“属性”保留五项:databasename: YourDB (对应ms sql中的数据库)
serverName: localhost
port: 1433
Password: yourpass
User: yourname