環境
- WebLogic 8.1 (Console Port 7001)
- Oracle 9i/10g/11g (Thin Driver)
Step 1:建立 JDBC Connection Pool
- Console → `mydomain` → Services → JDBC → Connection Pools → **Configure a new JDBC Connection Pool**
- Database Type: **Oracle**
- Driver: **Oracle's Driver (Thin) Version: 9.0.1, 10, 11**
- Name: `myconnection1`
- Database Name: `ORCL` (SID/Service Name)
- Host: `192.168.1.251`
- Port: `1521`
- User/Password: 對應 Oracle 帳密
- **Test Driver Configuration** → 顯示 "Connection Successful"
- **Create and Deploy**
Step 2:連線池進階測試設定
- 點選 `myconnection1` → **Connections** 分頁 → **Show Advanced Options**
- 勾選:Test Reserved Connections、Test Created Connections、Test Released Connections
- Test Table Name: 任意存在的表(如 `DUAL` 或 `EMP`)
- Initial SQL: `SQL SELECT 1 FROM DUAL`(輕量驗證)
- 勾選 **Supports Local Transactions**
- Apply → **Test** 分頁 → **Test Pool** → "Test Successful"
Step 3:建立 JDBC Data Source (JNDI)
- Console → Services → JDBC → Data Sources → **Configure a new JDBC Data Source**
- Name: `mydatasource1`
- JNDI Name: `jdbc/oracle` (或 `test/ora9`)
- Pool Name: 選 `myconnection1`
- Create and Deploy
Step 4:JSP 測試頁
<%@ page import="java.sql.*, javax.naming.*, javax.sql.*" %>
<%
try {
Context initCtx = new InitialContext();
DataSource ds = (DataSource) initCtx.lookup("jdbc/oracle"); // 你的 JNDI 名稱
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT COUNT(*) AS cnt FROM emp");
if (rs.next()) out.println("EMP COUNT = " + rs.getString("cnt"));
rs.close(); stmt.close(); conn.close();
} catch (Exception e) { e.printStackTrace(); }
%>
部署至 Web 應用,瀏覽器訪問 → 顯示筆數即成功。
常見問題速查
| 現象 | 原因 | 解法 |
| JNDI Lookup 失敗 `NameNotFoundException` | JNDI 名稱拼錯或 Data Source 未部署到正確 Server | 確認 JNDI 名稱、Target 到正確 Managed Server |
| 連線池測試失敗 `Io exception: The Network Adapter could not establish the connection` | Host/Port/SID 錯誤、防火牆、Listener 未啟動 | `tnsping` 測試、檢查 `listener.ora`、`firewall-cmd` |
| 應用重新部署後連線洩漏 | 未啟用 Test Reserved Connections | Step 2 全勾選、設定合理 `Inactive Connection Timeout` |
結語
WebLogic 8.1 雖屬經典版本,但「Connection Pool → Data Source → JNDI → JSP 測試」四步驟至今仍是 Java EE 資料庫存取的標準流程。記得開啟連線驗證機制,避免死連佔用資源。