search

justfriend / bad-robot

Automatically exported from code.google.com/p/bad-robot
0 stars 0 forks source link

Cannot release connection #1

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. 執行了完全同步
2. 查詢了幾次典型查詢和一般查詢
3. 
application閒置了2小時多，再使用一般查詢查資料，會產生以��
�錯誤

使用以下連線資訊 :
        <!-- DB Connection -->
        <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
        <property name="hibernate.connection.username">sopaadmin</property>
        <property name="hibernate.connection.password">systex</property>
        <property name="hibernate.connection.url">jdbc:oracle:thin:@10.10.56.119:1521:OM2ML</property>
        <property name="hibernate.default_schema">SOPAADMIN</property>

        <!-- DB Feature -->
        <property name="hibernate.jdbc.fetch_size">200</property>
        <property name="hibernate.jdbc.batch_size">300</property>
        <property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
        <property name="hibernate.show_sql">false</property>
        <property name="hibernate.formate_sql">false</property>

        <!-- POOL - DBCP (Do not provide DBCP provider since Hibernate 3) -->
        <property name="hibernate.connection.provider_class">com.systex.sop.cvs.util.DBCPConnectionProvider</property>
        <property name="hibernate.connection.autocommit">false</property>
        <property name="hibernate.dbcp.traceConnection">false</property>
    <property name="hibernate.dbcp.initialSize">3</property>
    <property name="hibernate.dbcp.maxActive">10</property>
    <property name="hibernate.dbcp.minIdle">0</property>
    <property name="hibernate.dbcp.maxIdle">10</property>
    <property name="hibernate.dbcp.maxWait">30000</property>

Original issue reported on code.google.com by wmy0...@gmail.com on 16 Feb 2012 at 6:21

Attachments:

GoogleCodeExporter commented 9 years ago 
在hibernate.cfg.xml中加了
<property name="hibernate.dbcp.validationQuery">select 1 from dual</property>
<property name="hibernate.dbcp.testOnBorrow">true</property>
<property name="hibernate.dbcp.testOnReturn">true</property>
再測試會出現:
2012-02-16 14:37:00,499  INFO [main] (BasicTypeRegistry.java:150) - Type 
registration [materialized_clob] overrides previous : 
org.hibernate.type.MaterializedClobType@313d21d6
2012-02-16 14:37:01,217  INFO [main] (SessionFactoryObjectFactory.java:105) - 
Not binding factory to JNDI, no JNDI name configured
2012-02-16 14:37:01,781  INFO [main] (SSSJFrameBase.java:235) - [Message]DB 
Connected
2012-02-16 14:37:15,367  INFO [Thread-5] (SSSJFrameBase.java:235) - 
[Message]查詢筆數：1183, 耗時：00:01.534
2012-02-16 14:37:19,131  INFO [Thread-6] (SSSJFrameBase.java:235) - 
[Message]查詢筆數：77, 耗時：00:00.067
2012-02-16 14:37:25,240  INFO [Thread-7] (SSSJFrameBase.java:235) - 
[Message]查詢筆數：5000, 耗時：00:02.479
2012-02-16 14:37:25,241  INFO [Thread-3] (SSSJFrameBase.java:249) - 
[CxtMsg]資料量超過 (5000) 筆
################################
2012-02-16 15:53:11,674  INFO [Thread-9] (SSSJFrameBase.java:235) - 
[Message]查詢筆數：1183, 耗時：00:58.779
#################################
2012-02-16 15:53:28,603  INFO [Thread-10] (SSSJFrameBase.java:235) - 
[Message]查詢筆數：1183, 耗時：00:00.421

Original comment by wmy0...@gmail.com on 16 Feb 2012 at 8:33

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
<!-- POOL - DBCP (Do not provide DBCP provider since Hibernate 3) -->
<property 
name="hibernate.connection.provider_class">com.systex.sop.cvs.util.DBCPConnectio
nProvider</property>
<property name="hibernate.connection.autocommit">false</property>
<property name="hibernate.dbcp.traceConnection">true</property>
<property name="hibernate.dbcp.initialSize">3</property>
<property name="hibernate.dbcp.maxActive">10</property>
<property name="hibernate.dbcp.minIdle">3</property>
<property name="hibernate.dbcp.maxIdle">10</property>
<property name="hibernate.dbcp.maxWait">30000</property>
<property name="hibernate.dbcp.poolPreparedStatements">true</property>
<property name="hibernate.dbcp.maxOpenPreparedStatements">10</property>
<property name="hibernate.dbcp.validationQuery">SELECT 1 FROM DUAL</property>
<property name="hibernate.dbcp.testOnBorrow">true</property>
<property name="hibernate.dbcp.testOnReturn">true</property>
<property name="hibernate.dbcp.testWhileIdle">true</property>
<property name="hibernate.dbcp.timeBetweenEvictionRunsMillis">60000</property>
<property name="hibernate.dbcp.numTestsPerEvictionRun">10</property>
<property name="hibernate.dbcp.minEvictableIdleTimeMillis">180000</property>

設定已調整，等待二小時再重新查詢時「耗時：00:58.779」再��
�看看..

Original comment by jingwei027 on 18 Feb 2012 at 6:22