- 将 ojdbc6.jar tomcat-jdbc-7.0.37.jar 拷贝到工程的WEB-INF\lib 下面
一、在Tomcat的配置文件Tomcat7.0\conf\context.xml中添加信息:
1
2
3
4
5
6
7
8
9
10
11
|
<? xml
version = ‘1.0‘
encoding = ‘utf-8‘ ?>
< Resource
name = "jdbcoracle"
auth = "Container"
type = "javax.sql.DataSource"
factory = "org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
maxActive = "20"
maxIdle = "1"
maxWait = "100"
username = "test"
password = "test"
driverClassName = "oracle.jdbc.OracleDriver"
url = "jdbc:oracle:thin:@localhost:1521:orcl" >
</ Context >
|
注意这里的driverClassName写的是oracle.jdbc.OracleDriver。oracle10之前的driverClassName写的oracle.jdbc.driver.OracleDriver
二、 在$CATALINA_HOME/webapps/应用名称/WEB-INF/web.xml的前添加如下信息:
1
2
3
4
5
6
|
< resource-ref
>
< description
>databaseConnection</ description
>
< res-ref-name
>jdbcoracle </ res-ref-name
>
< res-type
>javax.sql.DataSource</ res-type
>
< res-auth
>Container</ res-auth
>
</ resource-ref
>
|
其中中的参数名必须和context.xml中声明的连接名一样。
三、在jsp中测试connection
1
2
3
4
5
6
7
8
9
10
11
|
<%@ page language= "java" pageEncoding= "UTF-8" % >
<%@ page import = " java.util.*,java.sql.*" % >
<%@ page import = "java.util.Hashtable,javax.sql.DataSource " % >
<%@ page import = " javax.naming.Context,javax.naming.InitialContext" % >
<% InitialContext ctx = new
InitialContext();
//通过JNDI查找DataSource DataSource ds = (DataSource) ctx.lookup( "java:comp/env/jdbcoracle" );
Connection conn = ds.getConnection();
out.println( "数据源测试联接成功!" );
% > |