Storefront
BEA AquaLogic Commerce Services Deployment Guide 35
The following parameters can be configured in ep-treecache.xml's EvictionPolicyConfig element
• timeToLiveSeconds - The idle time in seconds that should elapse before a node is removed
from the tree cache. A value of 0 denotes no limit.
• maxAgeSeconds - The maximum time in seconds that a node in the tree cache can exist
regardless of idle time. A value of 0 denotes no limit.
There are additional configurable parameters in ep-treecache.xml, however, we do not
recommend that you modify them unless you are performing advanced JBoss Cache optimization
or troubleshooting.
hibernate-config.xml
Hibernate is used in AquaLogic Commerce Services for object to relational database mapping.
The hibernate-config.xml file used to configure Hibernate is located in the following application-
specific paths.
• Storefront – <ALCS_APP_HOME>\commerceServices\WEB-
INF\conf\spring\dataacess\hibernate\
• Commerce Manager – <ALCS_APP_HOME>\commerceServicesManager\WEB-
INF\conf\spring\dataacess\hibernate\
• Connect – <ALCS_APP_HOME>\commerceServicesConnect\WEB-
INF\conf\spring\dataacess\hibernate\
Setting Hibernate properties for a production environment
Ensure that the "hibernate.show_sql" property is set to false in production, since having it turned
on adversely affects performance. The setting of this property determines whether or not the
Hibernate generated SQL is written to system log files.
The "hibernate.dialect" property needs to be set to a value appropriate for the database type that
your application is using. Below are the values for each database.
• org.hibernate.dialect.MySQLDialect
• org.hibernate.dialect.OracleDialect
• org.hibernate.dialect.SQLServerDialect
The following is a set of example hibernate settings found in hibernate-config.xml.
<property name="hibernateProperties">
<props>
<prop
key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
<prop key="hibernate.show_sql">false</prop>
<prop key="hibernate.jdbc.use_streams_for_binary">true</prop>
