我用的是ORACLE816数据库,在环境变量中加载:oracle的两个文件:class12.zip和nls_charset12.zip 用的POOLMAN.XML启动是这样用的: <poolman> <management-mode>local</management-mode> <!-- ========================================================== --> <!-- These entries are an example of JDBC Connection pooling. --> <!-- Many of the parameters are optional. Consult the --> <!-- UsersGuide.html doument and the poolman.xml.template file --> <!-- for guidance and element definitions. --> <!-- ========================================================== --> <datasource> <!-- ============================== --> <!-- Physical Connection Attributes --> <!-- ============================== --> <!-- Standard JDBC Driver info --> <dbname>zxdb_1000</dbname>
用的POOLMAN.XML启动是这样用的:
<poolman> <management-mode>local</management-mode> <!-- ========================================================== -->
<!-- These entries are an example of JDBC Connection pooling. -->
<!-- Many of the parameters are optional. Consult the -->
<!-- UsersGuide.html doument and the poolman.xml.template file -->
<!-- for guidance and element definitions. -->
<!-- ========================================================== --> <datasource> <!-- ============================== -->
<!-- Physical Connection Attributes -->
<!-- ============================== --> <!-- Standard JDBC Driver info --> <dbname>zxdb_1000</dbname>
<driver> oracle.jdbc.driver.OracleDriver</driver>
<url>jdbc:oracle:thin:@172.16.6.21:1521:proj </url> <username>zxdb_1000</username>
<password>zxdb_1000</password> <initialConnections>3</initialConnections>
<maximumSoft>true</maximumSoft>
<minimumSize>3</minimumSize>
<maximumSize>10</maximumSize>
<connectionTimeout>600</connectionTimeout>
<userTimeout>12</userTimeout>
<skimmerFrequency>300</skimmerFrequency>
<shrinkBy>10</shrinkBy>
<debugging>false</debugging>
<logFile>/usr/local/weblib/poolman/poolman.log</logFile>
<cacheEnabled>false</cacheEnabled>
<cacheSize>20</cacheSize>
<cacheRefreshInterval>120</cacheRefreshInterval>
</datasource>
<datasource> <!-- ============================== -->
<!-- Physical Connection Attributes -->
<!-- ============================== --> <!-- Standard JDBC Driver info --> <dbname>zxdb_kf</dbname>
<driver> oracle.jdbc.driver.OracleDriver</driver>
<url>jdbc:oracle:thin:@172.16.6.21:1521:proj </url> <username>zxdb_kf</username>
<password>zxdb_kf</password> <initialConnections>3</initialConnections>
<maximumSoft>true</maximumSoft>
<minimumSize>3</minimumSize>
<maximumSize>10</maximumSize>
<connectionTimeout>600</connectionTimeout>
<userTimeout>12</userTimeout>
<skimmerFrequency>300</skimmerFrequency>
<shrinkBy>10</shrinkBy>
<debugging>false</debugging>
<logFile>/usr/local/weblib/poolman/poolman.log</logFile>
<cacheEnabled>false</cacheEnabled>
<cacheSize>20</cacheSize>
<cacheRefreshInterval>120</cacheRefreshInterval>
</datasource>
<!-- DISABLED FOR PRODUCTION
<admin-agent>
<class>com.sun.jdmk.comm.HtmlAdaptorServer</class>
<name>Adaptor:name=html</name>
<maxClients>10</maxClients>
<port>8082</port>
</admin-agent>
--></poolman>
出现了问题。