Mailing-List: contact dev-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@geronimo.apache.org
Message-ID: <1071678835.1255596031908.JavaMail.jira@brutus>
Date: Thu, 15 Oct 2009 01:40:31 -0700 (PDT)
From: "Quintin Beukes (JIRA)" <jira@apache.org>
To: dev@geronimo.apache.org
Subject: [jira] Commented: (GERONIMO-4906) DB connection problem
In-Reply-To: <1285535120.1255525351461.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/GERONIMO-4906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12765975#action_12765975 ] 

Quintin Beukes commented on GERONIMO-4906:
------------------------------------------

I remember now that I was using c3p0 with Hibernate. These were the options I was referring to:
http://www.mchange.com/projects/c3p0/index.html#configuring_connection_testing

> DB connection problem
> ---------------------
>
>                 Key: GERONIMO-4906
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-4906
>             Project: Geronimo
>          Issue Type: Bug
>      Security Level: public(Regular issues) 
>          Components: databases
>    Affects Versions: 2.0.1
>         Environment: Geronimo running on Windows server 2003 (Virtual Machine)
> Oracle 10g
> Driver jdbc 10.2.0.1
> Spring-Version: 2.0.2
> Hibernate-Version: 3.2.0.cr4
>            Reporter: Jean-Jacques Parent
>         Attachments: config.xml, Errors_samples.txt
>
>
> Your expertise on my problem will be helpful.
> Once a week, I get a DB connectivity problem with my application.
> No new DB transaction can be open. After a few minutes, the situation can come back as normal, if not the Geronimo server has to be restarted.
> I ask our technicians about connectivity and performance, but they found nothing wrong.
> I give you the stack trace in attachment with the different kind of error message.
> You will see that it looks like a network problem, but maybe this could also be due to a jdbc, timeout...? 
> My pool configuration is as follow
> Pool Min Size:25	 
> 	The minimum number of connections in the pool. The default is 0.
> Pool Max Size:140	 
> 	The maximum number of connections in the pool. The default is 10.
> Blocking Timeout: 5000	 (in milliseconds)
> 	The length of time a caller will wait for a connection. The default is 5000.
> Idle Timeout: 5	 (in minutes)
> 	How long a connection can be idle before being closed. The default is 15.
> Any help will be appreciate.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.