建立Oracle的JDBC Connection Pool?
Configuration
General
Name: OracleCP
URL: jdbc:weblogic
racle
Driver Classname: weblogic.jdbc.oci.Driver
Properties(key=value): user=scott
password=tiger
server=estore
Connections
Initial Capacity: 4 connections
Maximum Capacity: 10 connections
Capacity Increment: 2 connections
Login Delay Seconds: 1 seconds
Refresh Period: 10 minutes
(Y)Allow Shrinking
Shrink Period: 15 minutes
Testing
Test Table Name: dual
(N)Test Reserved Connections
(N)Test Released Connections
Targets
Servers
eStoreServer
建立Oracle的JDBC Data Source?
Configuration
Name: OracleDS
JNDI Name: jdbc.OracleDS
Pool Name: OracleCP
Targets
Servers
eStoreServer
建立Oracle的JDBC Tx Data Source?
Configuration
Name: OracleTxDS
JNDI Name: jdbc.OracleTxDS
Pool Name: OracleCP
(N)Enable Two-Phase Commit
Targets
Servers
eStoreServer
建立Oracle的Realm?
Configuration
General
Name: defaultRDBMSRealmForOracle
Realm Class: examples.security.rdbmsrealm.RDBMSRealm
Database
Driver: weblogic.jdbc.oci.Driver
URL: jdbc:weblogic
racle
User Name: scott
Password: tiger
测试工具:在DOS命令行下先设置环境变量,后执行
java utils.dbping ORACLE user password server
java utils.t3dbping t3://localhost:7001 scott tiger estore weblogic.jdbc.oci.Driver jdbc:weblogic
racle