非全局jndi配置步骤 :此种配置方式不需要在server.xml中配置数据源,而只在tomcat/conf/Catalina/localhost下的启动配置中配置即可。注意红色字体名称必须和相同。
0、需要在tomcat/common/lib下加入数据库连接的jar包
1、web.xml配置
<resource-ref>
<description>my DB Connection</description>
<res-ref-name>mydataSource </res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
2、applicationContext.xml下配置
<bean id="dataSource"
class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName" value="java:comp/env/mydataSource " />
</bean>
3、在tomcat的conf下的localhost下的配置如下
<?xml version="1.0" encoding="UTF-8"?>
<Context docBase="F:/workspace/cuapp/WebRoot" path="cuapp" reloadable="false">
<Resource name="mydataSource" auth="Container" type="javax.sql.DataSource"
url="jdbc:oracle:thin:@192.168.2.104:1521:ora10g"
driverClassName="oracle.jdbc.driver.OracleDriver"
password="aa"
username="aa"
initialSize="2"
maxActive="3"
maxIdle="1"
minIdle="1"
maxWait="10000"
removeAbandoned="true"
logAbandoned="true"
removeAbandonedTimeout="60"
timeBetweenEvictionRunsMillis="900000"
minEvictableIdleTimeMillis="1800000"
numTestsPerEvictionRun="100"
validationQuery="select count(0) from dual"
poolPreparedStatements="true"
maxOpenPreparedStatements="100"/>
</Context>
全局jndi配置 :此种配置需要在server.xml中配置数据源。
0、需要在tomcat下加入数据库连接的jar包
1、web.xml配置
<resource-ref>
<description>my DB Connection</description>
<res-ref-name>mydataSource </res-ref-name> must be same as server.xml
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
2、applicationContext.xml下配置
<bean id="dataSource"
class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName" value="java:comp/env/mydataSource " />
</bean>
3、server.xml中配置为
<!-- Global JNDI resources -->
<GlobalNamingResources>
<!-- Test entry for demonstration purposes -->
<Environment name="simpleValue" type="java.lang.Integer" value="30"/>
<!-- 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="mydataSource" auth="Container" type="javax.sql.DataSource"
url="jdbc:oracle:thin:@192.168.2.104:1521:ora10g"
driverClassName="oracle.jdbc.driver.OracleDriver"
password="aa"
username="aa"
initialSize="5"
maxActive="10"
maxIdle="5"
minIdle="2"
maxWait="10000"
removeAbandoned="true"
logAbandoned="true"
removeAbandonedTimeout="60"
timeBetweenEvictionRunsMillis="900000"
minEvictableIdleTimeMillis="1800000"
numTestsPerEvictionRun="100"
validationQuery="select count(0) from dual"
poolPreparedStatements="true"
maxOpenPreparedStatements="100"/>
</GlobalNamingResources>
4、tomcat/conf下localhost下的配置如下
<?xml version="1.0" encoding="UTF-8"?>
<Context docBase="F:/workspace/cuapp/WebRoot" path="xj-adminportal" reloadable="false">
<ResourceLink name="mydataSource " global="mydataSource " type="javax.sql.DataSource"/>
</Context>