Solved

com.mchange.v2.c3p0.ComboPooledDataSource

Posted on 2010-09-14
3
2,014 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
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
bunnyEars challenge 6 65
powerN  challenge 3 49
array11 challenge 16 52
Requested array size exceeds VM limit 3 50
Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
The viewer will learn how to implement Singleton Design Pattern in Java.

759 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now