tomcat jsp 数据库连接池配置问题

demonapple 2014-09-04 10:10:52

我想配置tomcat 项目的数据库连接池，不是全局的。

环境：apache-tomcat-6.0.29
jdk: 1.7.0_45
lib包放在项目wen-inf的lib下面

直接使用能连接成功，说明jar包和连接串没问题

Class.forName("oracle.jdbc.driver.OracleDriver")

					.newInstance();

			String url_ms = "java:oracle:thin:@132.228.1.1:1521:kk";

			String user = "xx"; //数据库登陆密码

			String password = "xx";

			Connection conn_ms = DriverManager.getConnection(url_ms, user,password);

然后开始修改
修改的内容有

conn_pool\META-INF下新建context.xml

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

<Context reloadable="true" crossContext="true">

 <!-- Default set of monitored resources -->

 <WatchedResource>WEB-INF/web.xml</WatchedResource>

 <!-- Uncomment this to disable session persistence across Tomcat restarts -->

 <!--

  <Manager pathname="" />

 -->

 <Resource 

 name="jdbc/oracle" 

 auth="Container"

 type="javax.sql.DataSource"

 driverClassName="oracle.jdbc.driver.OracleDriver"

 url="java:oracle:thin:@132.228.1.1:1521:kk"

 username="xx"

 password="xx"

 maxActive="15"

 maxIdle="5"

 maxWait="-1"/>

</Context>

web-inf加入

 <resource-ref>

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

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

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

 </resource-ref>

然后重启tomcat报错
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL 'java:oracle:thin:@132.228.1.1:1521:kk'

将包放到tomcat目录的lib下还是一样的结果

请问如何正确配置tomcat的项目数据库连接池？还是tomcat这种配置只能在全局配置，不可局部配置连接池？

...全文