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 1. 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.

Note:

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 making changes.

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: