Solved

com.mchange.v2.c3p0.ComboPooledDataSource

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
maven example error 3 52
starter POM and spring-boot-starter,  spring-boot-web 2 43
Apps blocked by Java 9 64
configure dependency in POM for new database 3 17
After being asked a question last year, I went into one of my moods where I did some research and code just for the fun and learning of it all.  Subsequently, from this journey, I put together this article on "Range Searching Using Visual Basic.NET …
This was posted to the Netbeans forum a Feb, 2010 and I also sent it to Verisign. Who didn't help much in my struggles to get my application signed. ------------------------- Start The idea here is to target your cell phones with the correct…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
This video teaches viewers about errors in exception handling.

896 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

14 Experts available now in Live!

Get 1:1 Help Now