给你看一个配置:
<Host name="nec2k" debug="0" appBase="f:\website"
unpackWARs="true" autoDeploy="true"
xmlValidation="false" xmlNamespaceAware="false">
<Valve className="org.apache.catalina.valves.AccessLogValve"
directory="logs" prefix="nec2k_access_log." suffix=".txt"
pattern="common" resolveHosts="false"/> <Logger className="org.apache.catalina.logger.FileLogger"
directory="logs" prefix="nec2k_log." suffix=".txt"
timestamp="true"/> <Context path="" docBase="f:\website" debug="0" reloadable="true" crossContext="true">
<Resource name="jdbc/oracle" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/oracle">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:[email protected]:1521:nec2k</value>
</parameter>
<parameter>
<name>username</name>
<value>nec2k</value>
</parameter>
<parameter>
<name>password</name>
<value>nec2k</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>60</value>
</parameter>
<parameter>
<name>mixActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
</ResourceParams>
</Context> </Host>
<Host name="nec2k" debug="0" appBase="f:\website"
unpackWARs="true" autoDeploy="true"
xmlValidation="false" xmlNamespaceAware="false">
<Valve className="org.apache.catalina.valves.AccessLogValve"
directory="logs" prefix="nec2k_access_log." suffix=".txt"
pattern="common" resolveHosts="false"/> <Logger className="org.apache.catalina.logger.FileLogger"
directory="logs" prefix="nec2k_log." suffix=".txt"
timestamp="true"/> <Context path="" docBase="f:\website" debug="0" reloadable="true" crossContext="true">
<Resource name="jdbc/oracle" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/oracle">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:[email protected]:1521:nec2k</value>
</parameter>
<parameter>
<name>username</name>
<value>nec2k</value>
</parameter>
<parameter>
<name>password</name>
<value>nec2k</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>60</value>
</parameter>
<parameter>
<name>mixActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
</ResourceParams>
</Context> </Host>
怎么设置。??
应该jdbc:mysql://localhost:3306/mydatabase?autoReconnect=true;
useUnicode=true;characterEncoding=gb2312
但奇怪的是,这样该了之后,可以正常使用连接池了,但中文还是乱码,我之前用
jdbc来连接时,url设置了useUnicode=true,characterEncoding=gb2312时,中文不会
乱码的呀,为什么连接池会乱码?
jdbc:mysql://localhost:3306/mydatabase?autoReconnect=true&
useUnicode=true&characterEncoding=gb2312
就行了,