LiveCycle on JBoss with Oracle having multiple schemas

Sometimes user may face issues while configuring LiveCycle on JBoss with Oracle having multiple schema.  One of the them are TIMERS and HILOSEQUENCES tables not found. This issue can be resolved using the following steps-

For JBOSS 4.2.1

  1. Timers Table- Please edit $JBOSS_HOME/server/$PROFILE/deploy/ejb-deployer.xml file to change the table name from TIMERS to something like schemaname.tablename.
  2. HILOSEQUENCES Table – Please edit $JBOSS_HOME/server/$PROFILE/deploy/uuid-key-generator.sar/META-INF/jboss-service.xml file to change the table name from HILOSEQUENCES to something like schemaname.tablename.

For JBoss 5.1 and 5.2.0

  1. Timers Table- Please edit $JBOSS_HOME/server/$PROFILE/deploy/ejb2-timer-service.xml file to change the table name from TIMERS to something like schemaname.tablename.
  2. HILOSEQUENCES Table – Please edit $JBOSS_HOME/server/$PROFILE/deploy/uuid-key-generator.sar/META-INF/jboss-service.xml file to change the table name from HILOSEQUENCES to something like schemaname.tablename.

References:

  1.  https://access.redhat.com/site/documentation/en-US/JBoss_Enterprise_Web_Platform/5/html/Administration_And_Configuration_Guide/ch11s03s06.html

About Pulkit Agarwal

Pulkit Agarwal is a Lead Software Engineer at Adobe Systems. He is working for Adobe LiveCycle Enterprise Suite. he is a team member of Foundation team. He is based out of Noida, India.
This entry was posted in Adobe LiveCycle ES3. Bookmark the permalink.

Comments are closed.