tomcat+spring+jndi同时部署多个项目配置多数据源

tomcat的conf--->context.xml中的<Context></context>标签中添加

<Resource name="jdbc/db1"

                     type="javax.sql.DataSource"

                    driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"

                    url="jdbc:sqlserver://数据库地址：端口号；databaseName=数据库名"

                    username="数据库用户名"

                    password="数据库密码"

                    maxActive=“100”

                    maxIdle="30"

                    maxWait="10000"/>

 

<Resource name="jdbc/db2"

                     type="javax.sql.DataSource"

                    driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"

                    url="jdbc:sqlserver://数据库地址：端口号；databaseName=数据库名"

                    username="数据库用户名"

                    password="数据库密码"

                    maxActive=“100”

                    maxIdle="30"

                    maxWait="10000"/>

 

 

Spring配置：

第一个项目

aplicationgContext.xml

<bean id="springDataSource" class="org.springframework.jndi.JndiObjectFactoryBean"

                   <property name="jndiName"

                             <value>java:comp/env/jdbc/db1</value>

                   </property>

</bean>

第二个项目

aplicationgContext.xml

<bean id="springDataSource" class="org.springframework.jndi.JndiObjectFactoryBean"

                   <property name="jndiName"

                             <value>java:comp/env/jdbc/db2</value>

                   </property>

</bean>