1. 启动tomcat,通过admin配置数据源:
选择Resources-Data sources进入配置数据源界面
选择Data Source Actions ->选择Create New Data Source,内容如下:
JNDI Name: jdbc/mysql
Data Source URL: jdbc:mysql://localhost:3306/test
JDBC Driver Class: com.mysql.jdbc.Driver
User Name: root
Password: ********
Max. Active Connections: 4
Max. Idle Connections: 2
Max. Wait for Connection: 500
Validation Query:
2. 如果某应用需要引用该数据源,则可以在web.xml里引用:
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/mysql</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
3.也可以在应用的配置文件内引用:
<Context docBase="myapp" path="/myapp"
workDir="work/Catalina/localhost/myapp">
<ResourceLink global="jdbc/mysql" name="jdbc/mysql" type="javax.sql.DataSource"/>
</Context>