|
楼主 |
发表于 2019-9-20 10:22:39
|
显示全部楼层
tomcat server.xml配置
<Connector port="9090" URIEncoding="utf-8" maxHttpHeaderSize="8192" compression="on"
maxThreads="2048" minSpareThreads="25" maxSpareThreads="150"
enableLookups="false" redirectPort="8443" acceptCount="2048"
compressionMinSize="10"
connectionTimeout="30000" disableUploadTimeout="true" compressableMimeType="text/html,text/xml,text/css,text/javascript,application/x-javascript,application/javascript,application/xml,application/json"/>
context.xml 配置:
<Resource name="demo" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@172.16.100.74:1521:orcl" username="yk_mms" password="qdgcpt" maxActive="10" maxIdle="5"/>
<Resource name="doc" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@172.16.100.74:1521:orcl" username="x5doc" password="qdgcpt" maxActive="50" maxIdle="5"/>
<Resource name="oa" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@172.16.100.74:1521:orcl" username="oaapp" password="qdgcpt" maxActive="10" maxIdle="5"/>
<Resource name="x5sys" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@172.16.100.74:1521:orcl" username="x5sys" password="qdgcpt" maxActive="150" maxIdle="5"/>
<Resource name="system" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@172.16.100.74:1521:orcl" username="x5sys" password="qdgcpt" maxActive="50" maxIdle="5"/>
<Resource name="ykmms" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@172.16.100.74:1521:orcl" username="yk_mms" password="qdgcpt" maxActive="200" maxIdle="5"/>
<Resource name="sellapp" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@172.16.100.74:1521:orcl" username="yk_mms" password="qdgcpt" maxActive="10" maxIdle="5"/>
</Context>
数据库最大连接数为500
|
|