tomcat动态部署项目及部署远程oracle数据库

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>

详情参考：

http://www.cnblogs.com/lraa/archive/2013/01/09/2852175.html