tomcat配置資料來源通過JNDI訪問mysql資料庫

最後更新：2018-12-06 來源：互聯網

上載者：User

創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

<p>4.tomcat配置資料來源通過JNDI訪問mysql資料庫</p><p>Cannot create JDBC driver of class '' for connect URL 'null'錯誤</p>

1.添加mysql jdbc驅動至build path,並複製到tomcat目錄/lib下

2.在tomcat目錄/conf/server.xml的<host></host>之間添加

<Resource name="jdbc/bbs" auth="Container" type="javax.sql.DataSource"

maxActive="100" maxIdle="30" maxWait="10000"

username="root" password="0." driverClassName="com.mysql.jdbc.Driver"

url="jdbc:mysql://localhost:3306/bbs?autoReconnect=true"/>

</Context>

3.在工程的web-inf/web.xml中的<web-app></web-app>之間添加

<resource-ref>

<description>DB Connection</description>

<res-ref-name>jdbc/bbs</res-ref-name>

<res-type>javax.sql.DataSource</res-type>

<res-auth>Container</res-auth>

</resource-ref>

4.建立測試jsp

<%@ page contentType="text/html;charset=utf-8"%>

<%@ page language="java"%>

<%@ page import="java.util.*"%>

<%@ page import="java.sql.*"%>

<%@ page import="javax.sql.*"%>

<%@ page import="javax.naming.*"%>

<html>

<head>

</head>

<h1>mysql jndi test</h1>

<hr>

DataSource ds = null;

try {

Context initCtx = new InitialContext();

if (initCtx == null)

throw new Exception("Initial Failed!");

Context ctx = (Context) initCtx.lookup("java:comp/env");

if (ctx != null)

ds = (DataSource) ctx.lookup("jdbc/bbs");

if (ds == null)

throw new Exception("Look up DataSource Failed!");

} catch (Exception e) {

System.out.println(e.getMessage());

}

Connection conn = ds.getConnection();

Statement stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery("select * from user");

while (rs.next()) {

<%=rs.getInt(1)%>

<%=rs.getString(2)%>

}

rs.close();

stmt.close();

conn.close();

</body>

</html>

5.相關錯誤：　　<1>Cannot create JDBC driver of class '' for connect URL 'null'　　Tomcat先找到web.xml下的<resource-ref>，然後再找server.xml下面的<Resource>。如果沒有找到<Resource name=”JDBC/TestDB”>，或者名字錯了，則會報“Cannot create JDBC driver of class '' for connect URL 'null'”錯誤。　　注意步驟2和3中jdbc/bbs處名稱要相同，3處的url資訊要正確　　<2>Cannot load JDBC driver class 'com.mysql.jdbc.Driver'　　參加步驟1

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More