Tomcat配置多数据源.docxVIP

Tomcat配置多数据源测试的tomcat为apache-tomcat-6.0.18 ，数据库为mysql和oracle。配置步骤如下：1、把数据库的JDBC驱动放入D:\apache-tomcat-6.0.18\lib目录下2、在D:\apache-tomcat-6.0.18\conf\web.xml文件中，将下面代码加入到web.xml中： resource-ref descriptionDB Connection/description res-ref-namejdbc/mysql/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref resource-ref descriptionDB Connection/description res-ref-namejdbc/oracle/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref3、在D:\apache-tomcat-6.0.18\conf\server.xml文件中,在Host节点下添加Context子节点，配置如下? Context path=/ljqtest docBase=ljqtest debug=5 reloadable=true crossContext=true Resource name=jdbc/mysql type=javax.sql.DataSource username=root password=mysqldriverClassName=org.gjt.mm.mysql.Driverurl=jdbc:mysql://localhost:3306/shopmaxIdle=2maxWait=50maxActive=4 parameter nameremoveAbandoned/name valuetrue/value /parameter /Resource Resource name=jdbc/oracle type=javax.sql.DataSource username=test password=testdriverClassName=oracle.jdbc.driver.OracleDriverurl=jdbc:oracle:thin:@localhost:1521:ORCLmaxIdle=2maxWait=50maxActive=4 parameter nameremoveAbandoned/name valuetrue/value /parameter /Resource /Context /Host或者 Context path=/uimcardprj docBase=uimcardprj debug=5 reloadable=true crossContext=true Resource name=jdbc/ycxkDB type=javax.sql.DataSource username=ycxk password=xmzh driverClassName=oracle.jdbc.driver.OracleDriver url=jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 50)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl))) maxIdle=