Setting additional EDC Datasource connection properties
There are additional properties you might want to set for an EDC Datasource connection.
Note: It is a good practice to test your connection before and after changing additional properties.
Connection Pooling
Corticon uses C3P0, an open source JDBC connection pooling product, for connection pooling to Hibernate. The following properties might help tune connection pooling.
The following properties let you tune connection pooling:
Table 39. Settable C3P0 properties and their default value
Property Name
Default value
Comment
hibernate.c3p0.min_size
1
Minimum number of Connections a pool will maintain at any given time.
hibernate.c3p0.max_size
100
Maximum number of Connections a pool will maintain at any given time.
hibernate.c3p0.timeout
1800
Number of seconds a Connection will remain pooled but unused before being discarded. Zero sets idle connections to never expire.
hibernate.c3p0.max_statements
50
Size of C3P0's PreparedStatement cache.
Enter zero ( 0 ) to turn statement caching off. Then--depending on the alternative connection pooling mechanism requirements--you might need to declare required JAR and configuration files on the classpath.
You can bypass the use of C3P0 for connection pooling by setting the Property name hibernate.use.c3p0.connection_pool to the value false.
For more information about C3P0 and its use with Hibernate, see their JDBC3 Connection and Statement Pooling page at http://www.mchange.com/projects/c3p0/index.html#appendix_d.
Corticon has no recommendations for adjusting the properties in the Hibernate product. Refer to their web location for details. Then consult with Progress Corticon Support to note the behaviors you are attempting to adjust before taking action.
Database Time Zone
When your application stores date/time values in the database, you might need to set the following property:
com.corticon.edc.dateTimezone. This property pertains to only the DateTime data type, and lets you declare how DateTime values are expressed in the database:
Value
Purpose
JDK_DEFAULT_TIMEZONE
Declares that date/time values will be expressed in the Java Virtual Machine (JVM) time zone. Use this setting if your date/time values are expressed in “local” time.
UTC
Declares that date/time values will be expressed in GMT. This setting is typical for internet applications that are used across time zones.
America/Los_Angeles
Declares that date/time values will be expressed in America/Los Angeles time.
Europe/Paris
Declares that date/time values will be expressed in Europe/Paris time.
GMT+01:00
Declares that date/time values will be expressed in time zone GMT plus one hour.
Set your override values in the Property table of the Vocabulary editor's EDC tab, as illustrated:
