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&useUnicode=true&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