tomcat9配置JNDI
配置文件路径
$TOMCAT_HOME/conf/context.xml
配置mysql JNDI
- 添加mysql数据库驱动包
$TOMCAT_HOME/lib/mysql-connector-java-8.0.15.jar
该驱动包需要支持jdk8
<?xml version="1.0" encoding="UTF-8"?>
<Context>
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<WatchedResource>WEB-INF/tomcat-web.xml</WatchedResource>
<WatchedResource>${catalina.base}/conf/web.xml</WatchedResource>
<Resource auth="Container"
name="jdbc/TestDB" type="javax.sql.DataSource"
maxTotal="100" maxIdle="30" maxWaitMillis="10000"
driverClassName="com.mysql.cj.jdbc.Driver"
url="jdbc:mysql://aliyunhost:3306/test"
username="root" password="123456" />
</Context>
- com.mysql.cj.jdbc.Driver
注意:com.mysql.jdbc.Driver
已经过期
配置DB2 JNDI
- 添加db2数据库驱动包
$TOMCAT_HOME/lib/db2jcc4-4.14.146.jar
该驱动包需要支持jdk8
<?xml version="1.0" encoding="UTF-8"?>
<Context>
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<WatchedResource>WEB-INF/tomcat-web.xml</WatchedResource>
<WatchedResource>${catalina.base}/conf/web.xml</WatchedResource>
<Resource auth="Container"
name="jdbc/TestDB" type="javax.sql.DataSource"
maxTotal="100" maxIdle="30" maxWaitMillis="10000"
driverClassName="com.ibm.db2.jcc.DB2Driver"
url="jdbc:db2://aliyunhost:50000/test"
username="test" password="123456" />
</Context>
普通web工程测试
db2和mysql都可以正常运行
https://blog.csdn.net/qq_26264237/article/details/90638180
spring-boot测试
https://blog.csdn.net/qq_26264237/article/details/90641389