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
VN:F [1.9.22_1171]
Was this helpful? Please rate the content.
Rating: 5.0/10 (2 votes cast)
LiveCycle on JBoss with Oracle having multiple schemas, 5.0 out of 10 based on 2 ratings

About Pulkit Agarwal

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

Comments are closed.