JNDI配置数据源

在web.xml文件中配置

<resource-ref>
<description>student dbs</description>
<res-ref-name>jdbc/mysql</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>



servet.xml中:

<GlobalNamingResources>
<!-- Editable user database that can also be used by
UserDatabaseRealm to authenticate users
-->
<Resource name="UserDatabase" auth="Container"
type="org.apache.catalina.UserDatabase"
description="User database that can be updated and saved"
factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
pathname="conf/tomcat-users.xml" />

<Resource name ="jdbc/mysql"
auth ="Container" 
type ="javax.sql.DataSource"
maxActive ="100"
maxIdle ="30"
maxWait ="60" 
wait_timeout ="18800"
timeBetweenEvictionRunsMillis ="300000" 
minEvictableIdleTimeMillis ="600000"
username ="root"
password ="root" 
driverClassName ="com.mysql.jdbc.Driver" 
url ="jdbc:mysql://localhost:3306/student?comautoReconnect=true&amp;failOverReadOnly=false" 
removeAbandoned ="true"
removeAbandonedTimeout ="60" 
logAbandoned ="true" />
</GlobalNamingResources>



<Context path="/student" docBase="C:\Users\huang\workspace\student\WebRoot\" debug="0" reloadable="false" crossContext="true" >
<ResourceLink

name="jdbc/mysql"

type="javax.sql.DataSource"

global="jdbc/mysql"/>
</Context>

 
posted @ 2012-08-22 16:39  园林鸟  阅读(254)  评论(0编辑  收藏  举报