tomcat是6.0.18，oracle是远程连接的
1.将ojdbc6.jar放入apache-tomcat-6.0.18\bin中
2.编辑：apache-tomcat-6.0.18\conf\context.xml
<Context path="/reserve" >//reserve:项目名称
<Resource name="jdbc/reserveDataSource" auth="Container" type="javax.sql.DataSource"//reserveDataSource:数据库源名称
factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
maxActive="200"
maxIdle="50"
maxWait="3000"
username="test"//数据库用户名
password="test"//密码
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:PRODORCL"/> //远程url
</Context>
3.（这个可以不配置）新建：E:\apache-tomcat-6.0.18\conf\catalina\localhost\reserve.xml //reserve：项目名称
<?xml version='1.0' encoding='utf-8'?>
<Resource name="reserveDataSource" auth="Container" type="javax.sql.DataSource"
factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
maxActive="200"
maxIdle="50"
maxWait="3000"
username="test"
password="test"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:PRODORCL"/>
4、……\conf\server.xml中配置Java项目：
在<host>中添加：
<Connector port="8070" protocol="HTTP/1.1" //设置端口号
connectionTimeout="20000"
URIEncoding="gbk"
redirectPort="8443" />
<Context path="/reserve" docBase="D:\workSpaces\reserve_yaic\webapps\reserve" //程序地址
debug="0" privileged="true"
reloadable="true"
> </Context>
详情参考：