spring+tomcat 提供jndi数据源

1.jee命名空间

xmlns:jee="http://www.springframework.org/schema/jee"

xsi:schemaLocation="http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.0.xsd"

2.spring context 添加配置

方法1.

<jee:jndi-lookup id="dbDataSource"

jndi-name="jdbc/DatabaseName"

expected-type="javax.sql.DataSource" />

方法2.

<bean id="dbDataSource" class="org.springframework.jndi.JndiObjectFactoryBean">

<property name="jndiName" value="java:comp/env/jdbc/DatabaseName"/>

</bean>

3.tomcat server.xml添加配置

<GlobalNamingResources>

<Resource name="jdbc/DatabaseName" auth="Container" type="javax.sql.DataSource"

username="dbUsername" password="dbPasswd"

url="jdbc:postgresql://localhost/dbname"

driverClassName="org.postgresql.Driver"

initialSize="5" maxWait="5000"

maxActive="120" maxIdle="5"

validationQuery="select 1"

poolPreparedStatements="true"/>

</GlobalNamingResources/>

4.tomcat context.xml添加配置

<ResourceLink name="jdbc/DatabaseName"

global="jdbc/DatabaseName"

type="javax.sql.DataSource"/>