-
1. Re: Connections never close. Two many connections exception
kukeltje Mar 18, 2008 10:59 PM (in response to ffernandez)I'd suggest using real connectionpools from you appserver with datasources instead of plain hibernate and c3p0
-
2. Re: Connections never close. Two many connections exception
ffernandez Mar 19, 2008 4:40 AM (in response to ffernandez)Thanks Ronald,
Is there anyway to use a Local Datasource? I mean, I haven´t got any appserver because my application is "standalone". I have JBPM running inside a "standalone" application.
Thanks in advanced. -
3. Re: Connections never close. Two many connections exception
kukeltje Mar 19, 2008 6:28 AM (in response to ffernandez)Ahhh... hmmm... no sorry, I have no clue on this. c3p0 should fill that gap afaik.
-
4. Re: Connections never close. Two many connections exception
mputz Mar 19, 2008 6:47 AM (in response to ffernandez)if an app server is out of the picture, have a look at the following URLs, which contain helpful information on the c3p0 configuration options, especially in the combination with Hibernate:
http://www.hibernate.org/214.html
http://www.mchange.com/projects/c3p0/index.html#hibernate-specific
I'm wondering why you have set idle_test_period to zero:<property name="hibernate.c3p0.idle_test_period">0</property>
From the first link above:
If this is a number greater than 0, c3p0 will test all idle, pooled but unchecked-out connections, every this number of seconds.
I would start off with the values as shown in the sample config on the first link above and thus set it to 100 (seconds). Let us know if you start to see a difference. -
5. Re: Connections never close. Two many connections exception
ffernandez Mar 19, 2008 8:15 AM (in response to ffernandez)Thanks,
The error was inside in my application code. There was a jbpmContext that was never closed, so this connection was always active.
I'm using c3p0 with success.
Thanks again and forgiveness for the inconvenience. -
6. Re: Connections never close. Two many connections exception
kukeltje Mar 19, 2008 8:35 AM (in response to ffernandez)@ffernandez:
Would you care to summarize this somewhere on the wiki? -
8. Re: Connections never close. Two many connections exception
kukeltje Mar 24, 2008 3:00 PM (in response to ffernandez)cool, thanks