Solved

com.mchange.v2.c3p0.ComboPooledDataSource

Posted on 2010-09-14
3
2,053 Views
Last Modified: 2013-11-24
Hi Experts,
             
                   i keep getting "Connection Time out" while obtaining a connection using following datasource setup. I open the connection,update a table immediately,close the connection ( no looping or no complex logic written after opening a connection).Not sure why.I'm not getting it consistently rather i get it once in a while.Experts please have your say on this and please guide me how to go about resolving this.
Or is there some property i'm missing from my datasource definition
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
                        <property name="driverClass">
                                    <value>${db.driver}</value>
                        </property>
                        <property name="jdbcUrl">
                                    <value>${db.connection.uri}</value>
                        </property>
                        <property name="user">
                                    <value>${db.username}</value>
                        </property>
                        <property name="password">
                                    <value>${db.password}</value>
                        </property>
                        <property name="initialPoolSize">
                                    <value>0</value>
                        </property>
                        <property name="minPoolSize">
                                    <value>0</value>
                        </property>
                        <property name="maxPoolSize">
                                    <value>80</value>
                        </property>
                        <property name="acquireIncrement">
                                    <value>1</value>
                        </property>
                        <property name="maxStatements">
                                    <value>4000</value>
                        </property> 
                        <property name="numHelperThreads">
                                    <value>11</value>
                        </property>
            </bean>

Open in new window

0
Comment
Question by:prashubk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 92

Expert Comment

by:objects
ID: 33677876
are you sure you are closing connections
0
 
LVL 13

Accepted Solution

by:
Murali Murugesan earned 500 total points
ID: 33678606
try adding these properties,

<property name="acquireRetryAttempts" value="60"/>
<property name="acquireRetryDelay" value="1000"/>
<property name="breakAfterAcquireFailure" value="false"></property>
<property name="debugUnreturnedConnectionStackTraces" value="true"/>

Last one would help to identify if connection is leaked somewhere in the code.

-Murali*
0
 

Author Closing Comment

by:prashubk
ID: 33710702
Thanks all,Hi Murali i tried this in my local machine it dint time out.Let me see it in SIT and come back if i face this issue again.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
null output 3 42
login form jsp example 2 50
Java program running SQL query 5 48
Java pass by reference 3 21
In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Viewers learn about the “while” loop and how to utilize it correctly in Java. Additionally, viewers begin exploring how to include conditional statements within a while loop and avoid an endless loop. Define While Loop: Basic Example: Explanatio…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question