dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

Public bug reported:

c3p0 properties are being ignored when present in hibernate.properties.

Connection pooling is thus stuck at default (min 3, max 15) and mysql
connections are fragile because they cannot be configured to refresh.

So for example the following settings have no effect:
hibernate.c3p0.max_size = 50

hibernate.c3p0.min_size = 5
hibernate.c3p0.timeout = 300
0
hibernate.c3p0.max_statements = 0

hibernate.c3p0.idle_test_period = 300
hibernate.c3p0.acquire_increment = 1

hibernate.c3p0.max_statements_per_connection = 0

hibernate.c3p0.validate = false

** Affects: dhis2
     Importance: Undecided
     Assignee: Bob Jolliffe (bobjolliffe)
         Status: New

** Changed in: dhis2
     Assignee: (unassigned) => Bob Jolliffe (bobjolliffe)

-- 
c3p0 properties not being read from hibernate.properties
https://bugs.launchpad.net/bugs/603641
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.

Status in DHIS 2 - District Health Information Software: New

Bug description:
c3p0 properties are being ignored when present in hibernate.properties.  

Connection pooling is thus stuck at default (min 3, max 15) and mysql connections are fragile because they cannot be configured to refresh. 

So for example the following settings have no effect:
hibernate.c3p0.max_size = 50

hibernate.c3p0.min_size = 5
hibernate.c3p0.timeout = 300
0
hibernate.c3p0.max_statements = 0

hibernate.c3p0.idle_test_period = 300
hibernate.c3p0.acquire_increment = 1

hibernate.c3p0.max_statements_per_connection = 0

hibernate.c3p0.validate = false