在eclipse 下Servers下的tomcat进行修改:
1.web.xml添加:
<resource-ref>
<res-ref-name>jdbc/sso</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
<resource-ref>
<res-ref-name>jdbc/audit</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
2. context.xml里面添加
<Resource name="jdbc/sso" auth="Container" defaultAutoCommit="false" driverClassName="com.mysql.jdbc.Driver" initialSize="15" maxActive="20" maxIdle="2" username="root" password="Ever@311" type="javax.sql.DataSource" url="jdbc:mysql://172.16.10.132:3306/idm" />
<Resource name="jdbc/audit" auth="Container" defaultAutoCommit="false" driverClassName="com.mysql.jdbc.Driver" initialSize="15" maxActive="20" maxIdle="2" username="root" password="Ever@311" type="javax.sql.DataSource" url="jdbc:mysql://172.16.10.132:3306/audit4" />
在项目里进行修改:
3.在jdbc.properties里面进行修改:
db.pool.jndiName=jdbc/sso //jndiName值要和tomcat里面配的name值相同
db.pool.java.naming.factory.initial=com.sun.jndi.rmi.registry.RegistryContextFactory
audit.db.pool.jndiName=jdbc/audit
audit.db.pool.java.naming.factory.initial=com.sun.jndi.rmi.registry.RegistryContextFactory
4.在spring/applicationContext.xml中加一个bean,替代原来的dataSource //value里面必须是java:comp/env/开头
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName" value="java:comp/env/jdbc/sso"> </property>
</bean>
<bean id="auditDataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName" value="java:comp/env/jdbc/audit"> </property>
</bean>
5.在spring/dataSource.xml里面添加
<beans profile="ft,uat,press,pprod,prod,press2,press3,prod2,prod3,default"> //default为运行环境(本地测试)
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName" value="java:comp/env/${db.pool.jndiName}" />
<property name="lookupOnStartup" value="true" />
<property name="cache" value="true" />
<property name="proxyInterface" value="javax.sql.DataSource" />
<property name="jndiEnvironment">
<props>
<prop key="java.naming.factory.initial">${db.pool.java.naming.factory.initial}</prop>
</props>
</property>
</bean>
<bean id="auditDataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName" value="java:comp/env/${audit.db.pool.jndiName}" />
<property name="lookupOnStartup" value="true" />
<property name="cache" value="true" />
<property name="proxyInterface" value="javax.sql.DataSource" />
<property name="jndiEnvironment">
<props>
<prop key="java.naming.factory.initial">${audit.db.pool.java.naming.factory.initial}</prop>
</props>
</property>
</bean>
</beans>