隨筆 - 59  文章 - 70  trackbacks - 0
          <2008年7月>
          293012345
          6789101112
          13141516171819
          20212223242526
          272829303112
          3456789

          常用鏈接

          留言簿(5)

          隨筆分類

          隨筆檔案

          搜索

          •  

          積分與排名

          • 積分 - 174131
          • 排名 - 340

          最新評論

          閱讀排行榜

          評論排行榜

          第一天來公司上班的時候,竟然被配置WEB程序的問題搞了半天。郁悶至極。
          上班也有一年了,連個基礎的東西都搞不定,難怪被本人鄙視
          在tomcat的/conf/server.xml中配置連接池。
          插入以下代碼
          <ResourceParams name="jdbc/MySQLDB">
          <parameter>
          <name>factory</name>
          <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
          </parameter>

          <!-- Don't set this any higher than max_connections on your
          MySQL server, usually this should be a 10 or a few 10's
          of connections, not hundreds or thousands -->

          <parameter>
          <name>maxActive</name>
          <value>30</value>
          </parameter>

          <!-- You don't want to many idle connections hanging around
          if you can avoid it, only enough to soak up a spike in
          the load -->

          <parameter>
          <name>maxIdle</name>
          <value>4</value>
          </parameter>

          <!-- Maximum time to wait for a dB connection to become available
          in ms, in this example 5 seconds. An Exception is thrown if
          this timeout is exceeded. Set to -1 to wait indefinitely.
          -->
          <parameter>
          <name>maxWait</name>
          <value>10000</value>
          </parameter>

          <!-- Don't use autoReconnect=true, it's going away eventually
          and it's a crutch for older connection pools that couldn't
          test connections. You need to decide if your application is
          supposed to deal with SQLExceptions (hint, it should), and
          how much of a performance penalty you're willing to pay
          to ensure 'freshness' of the connection -->

          <parameter>
          <name>validationQuery</name>
          <value>SELECT 1</value>
          </parameter>

          <!-- The most conservative approach is to test connections
          before they're given to your application. For most applications
          this is okay, the query used above is very small and takes
          no real server resources to process, other than the time used
          to traverse the network.

          If you have a high-load application you'll need to rely on
          something else. -->

          <parameter>
          <name>testOnBorrow</name>
          <value>true</value>
          </parameter>

          <!-- Otherwise, or in addition to testOnBorrow, you can test
          while connections are sitting idle -->

          <parameter>
          <name>testWhileIdle</name>
          <value>true</value>
          </parameter>

          <!-- You have to set this value, otherwise even though
          you've asked connections to be tested while idle,
          the idle evicter thread will never run -->

          <parameter>
          <name>timeBetweenEvictionRunsMillis</name>
          <value>10000</value>
          </parameter>

          <!-- Don't allow connections to hang out idle too long,
          never longer than what wait_timeout is set to on the
          server...A few minutes or even fraction of a minute
          is sometimes okay here, it depends on your application
          and how much spikey load it will see -->

          <parameter>
          <name>minEvictableIdleTimeMillis</name>
          <value>20000</value>
          </parameter>

          <!-- Username and password used when connecting to MySQL -->

          <parameter>
          <name>username</name>
          <value>root</value>
          </parameter>

          <parameter>
          <name>password</name>
          <value>sa</value>
          </parameter>

          <!-- Class name for the Connector/J driver -->

          <parameter>
          <name>driverClassName</name>
          <value>com.mysql.jdbc.Driver</value>
          </parameter>

          <!-- The JDBC connection url for connecting to MySQL, notice
          that if you want to pass any other MySQL-specific parameters
          you should pass them here in the URL, setting them using the
          parameter tags above will have no effect, you will also
          need to use & to separate parameter values as the
          ampersand is a reserved character in XML -->

          <parameter>
          <name>url</name>
          <value>jdbc:mysql://localhost:3306/xinhui</value>
          </parameter>

          </ResourceParams>
          竟然報錯!調了半天還是沒出來,主管老是跑過來問,你的配好沒有?
          只能不好意思的答復到:還沒有
          最后將以上的代碼改為
          <Resource name="jdbc/MySQLDB" auth="Container" type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver" maxIdle="20" maxWait="5000" username="root" password="123456" url="jdbc:mysql://localhost:3306/xinhui" maxActive="100" removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true"/>這下竟然成功了。在網上查了下相關的問題,沒有很好的解答。
          應該是tomcat版本的問題吧
          posted on 2008-07-25 09:04 JasonChou 閱讀(175) 評論(0)  編輯  收藏 所屬分類: server&os
          主站蜘蛛池模板: 灵武市| 大城县| 桂林市| 白河县| 北宁市| 镇康县| 宁城县| 娄烦县| 晋中市| 福建省| 会理县| 历史| 徐水县| 新民市| 正阳县| 湟中县| 温泉县| 阿克陶县| 辽中县| 新竹市| 尚义县| 洛隆县| 南川市| 威海市| 寿阳县| 富平县| 广州市| 肥东县| 怀安县| 通许县| 木兰县| 庄浪县| 东源县| 武乡县| 白玉县| 平泉县| 历史| 沭阳县| 宜阳县| 鹰潭市| 临湘市|