Tomcat 6中JDBC数据源(Oracle)的配置

文章由LinuxBoy分享于2019-03-30 07:03:18热评（213）

Tomcat 6中JDBC数据源(Oracle)的配置

费了一番周折，把Tomcat6中JDBC数据源配置好了，这里把过程写一下。感觉是某些网上的东西不可全信，还是官方文档管用。

步骤一：将Oracle的数据库驱动包classes12.jar拷贝到$CATALINA_HOME/lib下，我的Tomcat6库位置是C:\Tomcat6\lib，就拷贝到这里。

步骤二：改写server.xml。
server.xml在$CATALINA_HOME/conf下，打开它，找到你工程对应的Context一段，在其中加入Resource节点，比如我的工程是DataSource，那么改写后的Context节点为：

<Resource name="jdbc/myoracle" auth="Container"

type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"

url="jdbc:oracle:thin:@192.168.104.173:1521:orcl"

username="hy" password="hy" maxActive="20" maxIdle="10"

maxWait="-1"/>

</Context>
干脆把server.xml全文贴一下以方便对照。

<!-- Note: A "Server" is not itself a "Container", so you may not

define subcomponents such as "Valves" at this level.

Documentation at /docs/config/server.html

-->

<!-- Global JNDI resources

Documentation at /docs/jndi-resources-howto.html

-->

<!-- Editable user database that can also be used by

UserDatabaseRealm to authenticate users

-->

<Resource name="UserDatabase" auth="Container"

type="org.apache.catalina.UserDatabase"

description="User database that can be updated and saved"

factory="org.apache.catalina.users.MemoryUserDatabaseFactory"

pathname="conf/tomcat-users.xml" />

</GlobalNamingResources>

<!-- A "Service" is a collection of one or more "Connectors" that share

a single "Container" Note: A "Service" is not itself a "Container",

so you may not define subcomponents such as "Valves" at this level.

Documentation at /docs/config/service.html

-->

<!-- A "Connector" represents an endpoint by which requests are received

and responses are returned. Documentation at :

Java HTTP Connector: /docs/config/http.html (blocking & non-blocking)

Java AJP Connector: /docs/config/ajp.html

APR (HTTP/AJP) Connector: /docs/apr.html

Define a non-SSL HTTP/1.1 Connector on port 8080

-->

<Connector port="8088" protocol="HTTP/1.1"

maxThreads="150" connectionTimeout="20000"

redirectPort="8443" />

<!-- Define a SSL HTTP/1.1 Connector on port 8443

This connector uses the JSSE configuration, when using APR, the

connector should be using the OpenSSL style configuration

described in the APR documentation -->

<!--

<Connector port="8443" protocol="HTTP/1.1" SSLEnabled="true"

maxThreads="150" scheme="https" secure="true"

clientAuth="false" sslProtocol="TLS" />

-->

<!-- An Engine represents the entry point (within Catalina) that processes

every request. The Engine implementation for Tomcat stand alone

analyzes the HTTP headers included with the request, and passes them

on to the appropriate Host (virtual host).

Documentation at /docs/config/engine.html -->

<!-- You should set jvmRoute to support load-balancing via AJP ie :

-->

<!--For clustering, please take a look at documentation at:

/docs/cluster-howto.html (simple how to)

/docs/config/cluster.html (reference documentation) -->

<!--

-->

<!-- The request dumper valve dumps useful debugging information about

the request and response data received and sent by Tomcat.

Documentation at: /docs/config/valve.html -->

<!--

-->

<!-- This Realm uses the UserDatabase configured in the global JNDI

resources under the key "UserDatabase". Any edits

that are performed against this UserDatabase are immediately

available for use by the Realm. -->

<Realm className="org.apache.catalina.realm.UserDatabaseRealm"

resourceName="UserDatabase"/>

<!-- Define the default virtual host

Note: XML Schema validation will not work with Xerces 2.2.

-->

<Host name="localhost" appBase="webapps"

unpackWARs="true" autoDeploy="true"

xmlValidation="false" xmlNamespaceAware="false">

<!-- SingleSignOn valve, share authentication between web applications

Documentation at: /docs/config/valve.html -->

<!--

-->

<!-- Access log processes all example.

Documentation at: /docs/config/valve.html -->

<!--

<Valve className="org.apache.catalina.valves.AccessLogValve" directory="logs"

prefix="localhost_access_log." suffix=".txt" pattern="common" resolveHosts="false"/>

-->

<Resource name="jdbc/myoracle" auth="Container"

type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"

url="jdbc:oracle:thin:@192.168.104.173:1521:orcl"

username="hy" password="hy" maxActive="20" maxIdle="10"

maxWait="-1"/>

</Context>

</Host>

</Engine>

</Service>

</Server>

步骤三：改写工程的web.xml,在其中增加resource-ref节点.
改写后的web.xml全文如下:

<?xml version="1.0" encoding="UTF-8"?>

<web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee

http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">

<welcome-file-list>

<welcome-file>/web/page/welcome.jsp</welcome-file>

</welcome-file-list>

<resource-ref>

<description>Oracle Datasource example</description>

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

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

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

</resource-ref>

</web-app>

步骤四:页面调用示例.

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

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

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

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>

<head>

<title>DataSource Welcome Page</title>

</head>

<body>

<thead>

<tr>

</tr>

</thead>

<tbody>

try {

InitialContext ctx = new InitialContext();

DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/myoracle");

Connection conn = ds.getConnection();

Statement stmt = conn.createStatement();

ResultSet rst = stmt.executeQuery(" select ID, NAME, AGE, SEX from EMPLOYEE");

while (rst.next()) {

out.println("<tr>");

out.println("<td>"+rst.getString("ID")+"</td>");

out.println("<td>"+rst.getString("NAME")+"</td>");

out.println("<td>"+rst.getString("AGE")+"</td>");

out.println("<td>"+rst.getString("SEX")+"</td>");

out.println("</tr>");

}

conn.close();

} catch (Exception e){

e.printStackTrace();

}

</tbody>

</table>

</body>

</html>

执行效果:

与数据库数据比较一下:

源码下载(注意在lib目录中加入classes12.jar):

下载在帮客之家的1号FTP服务器里，下载地址：

FTP地址：ftp://www.bkjia.com

用户名：www.bkjia.com

密码：www.muu.cc

在 2011年LinuxIDC.com\3月\Tomcat 6中JDBC数据源(Oracle)的配置

下载方法见 http://www.bkjia.net/thread-1187-1-1.html

推荐文章：

Tomcat 6中JDBC数据源(Oracle)的配置