Why am I seeing database errors related to time and date?

Submitted: January 31, 2007

Why am I seeing database errors related to time and date?

Entries in the catalina.out and portal.log files related to time and date errors with the database are generally caused by the misconfiguration of a property.  This property resides in the following file:

/portal/unicon/Academus/portal-tomcat-a/webapps/portal/WEB-INF/classes/properties/common-factory.properties

 

The property that is misconfigured is the following:

 

net.unicon.sdk.time.implementation

 

There are three possible settings for this property depending on what type of database your portal runs on (Postgres, Oracle, or MS-SQL).  You should update the property to reflect the database type you are running on:

 

For Postgres: net.unicon.sdk.time.implementation=net.unicon.portal.util.PostgresTimeServiceImpl

For Oracle: net.unicon.sdk.time.implementation=net.unicon.portal.util.OracleTimeServiceImpl

For MS-SQL: net.unicon.sdk.time.implementation=net.unicon.portal.util.NTPTimeServiceImpl