Tomcat 7 配置MySQL/Oracle JDBC驱动 |
| 发表者：admin分类：应用服务2020-03-30 11:59:43 阅读[36487] |
1. Tomcat 7 配置MySQL JDBC
Step1:
修改apache-tomcat-7.0.75 conf/ server.xml 放入 <GlobalNamingResources> 标签中:
<Resource name="jdbc/Demo"
auth="Container"
type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
testWhileIdle="true"
testOnBorrow="true"
testOnReturn="false"
validationInterval="30000"
timeBetweenEvictionRunsMillis="30000"
maxActive="100"
minIdle="10"
maxWait="10000"
initialSize="10"
removeAbandonedTimeout="60"
removeAbandoned="true"
logAbandoned="true"
minEvictableIdleTimeMillis="30000"
jmxEnabled="true"
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
username="demo"
password="demo"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://sjXXXX:3306/test"/>
Step2:
修改apache-tomcat-7.0.75 conf/ context.xml
<ResourceLink global="jdbc/Demo" name="jdbc/Demo" type="javax.sql.DataSource"/>
Step3:
修改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">
<resource-ref>
<!-- add-->
<description>MySQL DB Connection Pool</description>
<res-ref-name>jdbc/Demo</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>
</web-app>
Step4: (不一定都需要)
把MYSQL 相应的驱动包 放到Tomcat/ lib 目录下 例如: mysql-connector-java-5.1.20-bin.jar
2. Tomcat 7 配置Oracle JDBC
Step1:
修改apache-tomcat-7.0.75 conf/ server.xml 放入 <GlobalNamingResources> 标签中:
<Resource name="jdbc/QA" auth="Container"
type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@//10.9.***.***:XXXX/oracleDBName"
username="admin" password="admin" maxActive="20" maxIdle="10"
maxWait="-1"/>
Step2:
修改apache-tomcat-7.0.75 conf/ context.xml
<ResourceLink global="jdbc/QA" name="jdbc/QA" type="javax.sql.DataSource"/>
Step3:
修改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">
<resource-ref>
<description>QA DB Connection Pool</description>
<res-ref-name>jdbc/QA</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>
</web-app>
Step4: (不一定都需要)
把Oracle 相应的驱动包 放到Tomcat/ lib 目录下 例如: ojdbc6.jar
Test JDBC connection code example:
if(env!=null){
DataSource ds = (DataSource)env.lookup("jdbc/"+ dbName);
if(ds==null) throw new Exception("Can't find the DataSource for "+ envsiteID);
return ds.getConnection();
}
————————————————
版权声明：本文为CSDN博主「com542948180」的原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/com542948180/java/article/details/70240977
Step1:
修改apache-tomcat-7.0.75 conf/ server.xml 放入 <GlobalNamingResources> 标签中:
<Resource name="jdbc/Demo"
auth="Container"
type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
testWhileIdle="true"
testOnBorrow="true"
testOnReturn="false"
validationInterval="30000"
timeBetweenEvictionRunsMillis="30000"
maxActive="100"
minIdle="10"
maxWait="10000"
initialSize="10"
removeAbandonedTimeout="60"
removeAbandoned="true"
logAbandoned="true"
minEvictableIdleTimeMillis="30000"
jmxEnabled="true"
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
username="demo"
password="demo"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://sjXXXX:3306/test"/>
Step2:
修改apache-tomcat-7.0.75 conf/ context.xml
<ResourceLink global="jdbc/Demo" name="jdbc/Demo" type="javax.sql.DataSource"/>
Step3:
修改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">
<resource-ref>
<!-- add-->
<description>MySQL DB Connection Pool</description>
<res-ref-name>jdbc/Demo</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>
</web-app>
Step4: (不一定都需要)
把MYSQL 相应的驱动包 放到Tomcat/ lib 目录下 例如: mysql-connector-java-5.1.20-bin.jar
2. Tomcat 7 配置Oracle JDBC
Step1:
修改apache-tomcat-7.0.75 conf/ server.xml 放入 <GlobalNamingResources> 标签中:
<Resource name="jdbc/QA" auth="Container"
type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@//10.9.***.***:XXXX/oracleDBName"
username="admin" password="admin" maxActive="20" maxIdle="10"
maxWait="-1"/>
Step2:
修改apache-tomcat-7.0.75 conf/ context.xml
<ResourceLink global="jdbc/QA" name="jdbc/QA" type="javax.sql.DataSource"/>
Step3:
修改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">
<resource-ref>
<description>QA DB Connection Pool</description>
<res-ref-name>jdbc/QA</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>
</web-app>
Step4: (不一定都需要)
把Oracle 相应的驱动包 放到Tomcat/ lib 目录下 例如: ojdbc6.jar
Test JDBC connection code example:
if(env!=null){
DataSource ds = (DataSource)env.lookup("jdbc/"+ dbName);
if(ds==null) throw new Exception("Can't find the DataSource for "+ envsiteID);
return ds.getConnection();
}
————————————————
版权声明：本文为CSDN博主「com542948180」的原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/com542948180/java/article/details/70240977
转载请标明出处【Tomcat 7 配置MySQL/Oracle JDBC驱动】。
《www.micoder.cc》
虚拟化云计算,系统运维,安全技术服务.
| Tags： | [阅读全文...] |
最新评论