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