建立数据连接池
1. 启动WebLogic7
2. 打开IE6,在地址栏中输入:http://localhost:7001/console
3. 输入用户名和密码
4. 在左边的目录树中选中Services->JDBC->Connection Pools,单击右侧的Configure a new JDBC Connection Pool.,输入以下信息:
Configuration->General页:
Name = SQL Server Connection Pool
URL = jdbc:weblogic:mssqlserver4:northwind@localhost
Driver classname = weblogic.jdbc.mssqlserver4.Driver
Properties : user = sa
Password =<- sa的密码
单击Create建立连接池。
Targets->Server页:
将myserver(服务器名称)移至右侧的列表中,但击单击Apply


建立数据源
Services->JDBC->Data Sources->Configure a new JDBC Connection Pool
Configuration->General页:
Name = SQLServer Tx Data Source
JNDI Name = SQLServer
Pool Name = SQL Server Connection Pool
选中Emulate Two-Phase Commit for non-XA Driver和Row Prefetch Enabled
单击Create建立数据源。