spring 数据源JNDI 基于tomcat mysql配置

关键代码

<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName">
<value>java:comp/env/jdbc/ghdb</value>
</property>
<property name="resourceRef">
<value>true</value>
</property>
</bean>

全局jndi配置

Tomcat7\conf\context.xml下新增如下代码

<Resource auth="Container" driverClassName="com.mysql.jdbc.Driver"
logAbandoned="true" maxActive="20" maxIdle="10" maxWait="1000" name="jdbc/ghdb"
password="root" removeAbandoned="true" removeAbandonedTimeout="60"
type="javax.sql.DataSource"
url="jdbc:mysql://127.0.0.1:3306/kdddb?generateSimpleParameterMetadata=true&characterEncoding=utf8&autoReconnect=true"
useUnicode="true"
username="root" />

注意

name="jdbc/ghdb"

和

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