萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 資料庫 >> Oracle 教學

WebLogic 8.1 配置 Oracle 資料庫連線池與 JNDI 資料源完整教學

環境

  • WebLogic 8.1 (Console Port 7001)
  • Oracle 9i/10g/11g (Thin Driver)

Step 1:建立 JDBC Connection Pool

  1. Console → `mydomain` → Services → JDBC → Connection Pools → **Configure a new JDBC Connection Pool**
  2. Database Type: **Oracle**
  3. Driver: **Oracle's Driver (Thin) Version: 9.0.1, 10, 11**
  4. Name: `myconnection1`
  5. Database Name: `ORCL` (SID/Service Name)
  6. Host: `192.168.1.251`
  7. Port: `1521`
  8. User/Password: 對應 Oracle 帳密
  9. **Test Driver Configuration** → 顯示 "Connection Successful"
  10. **Create and Deploy**

Step 2:連線池進階測試設定

  1. 點選 `myconnection1` → **Connections** 分頁 → **Show Advanced Options**
  2. 勾選:Test Reserved Connections、Test Created Connections、Test Released Connections
  3. Test Table Name: 任意存在的表(如 `DUAL` 或 `EMP`)
  4. Initial SQL: `SQL SELECT 1 FROM DUAL`(輕量驗證)
  5. 勾選 **Supports Local Transactions**
  6. Apply → **Test** 分頁 → **Test Pool** → "Test Successful"

Step 3:建立 JDBC Data Source (JNDI)

  1. Console → Services → JDBC → Data Sources → **Configure a new JDBC Data Source**
  2. Name: `mydatasource1`
  3. JNDI Name: `jdbc/oracle` (或 `test/ora9`)
  4. Pool Name: 選 `myconnection1`
  5. 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 ConnectionsStep 2 全勾選、設定合理 `Inactive Connection Timeout`

結語

WebLogic 8.1 雖屬經典版本,但「Connection Pool → Data Source → JNDI → JSP 測試」四步驟至今仍是 Java EE 資料庫存取的標準流程。記得開啟連線驗證機制,避免死連佔用資源。

copyright © 萬盛學電腦網 all rights reserved