quiee在Tomcat6下配置JNDI数据源

最新推荐文章于 2021-08-12 14:29:35 发布

woshimyc

最新推荐文章于 2021-08-12 14:29:35 发布

阅读量170

点赞数

分类专栏： quiee

本文链接：https://blog.csdn.net/woshimyc/article/details/117928828

版权

quiee 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1、环境

（1）tomcat 6.0

（2）quiee

2、步骤

（1）tomcat -> conf ->context.xml 配置数据源

<Resource name="dataName1"      
        auth="Container"  
        type="javax.sql.DataSource"  
        driverClassName="oracle.jdbc.OracleDriver"  
        url="jdbc:oracle:thin:@192.10.29.218:1521:orcl"  
        username="test"  
        password="****"  
        maxActive="500"  
        maxIdle="500"  
        maxWait="36000"
		
		logAbandoned="true"  
		removeAbandoned="true" 
		removeAbandonedTimeout="10"
		
		validationQuery = "select 1 from dual"
		testWhileIdle = "true"
		testOnBorrow = "false"
		timeBetweenEvictionRunsMillis = "30000"
		minEvictableIdleTimeMillis = "1800000"
		numTestsPerEvictionRun="3"
		/>
	<Resource name="dataName2"      
        auth="Container"  
        type="javax.sql.DataSource"  
        driverClassName="com.mysql.jdbc.Driver"  
        url="jdbc:mysql://192.10.29.218:6666/screen?autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=utf-8"  
        username="test"  
        password="****"  
        maxActive="30"  
        maxIdle="20"  
        maxWait="36000"
		
		logAbandoned="true"  
		removeAbandoned="true" 
		removeAbandonedTimeout="10"
		
		validationQuery = "select 1 from dual"
		testWhileIdle = "true"
		testOnBorrow = "false"
		timeBetweenEvictionRunsMillis = "30000"
		minEvictableIdleTimeMillis = "1800000"
		numTestsPerEvictionRun="3"
		/>

（2）quiee -> WEB-INF -> reportConfig.xml 配置参数

    <config>
      <name>JNDIPrefix</name>
      <value>java:comp/env</value>
    </config>
    <config>
      <name>dataSource</name>
      <value>dataName1,oracle;dataName2,mysql;</value>
    </config>

（3）测试地址

http://localhost:8080/quiee/reportJsp/showReport.jsp?raq=viewInv.raq