Multiple JCR and IDM databases on EPP

Solution In Progress - Updated -

Issue

Can not start more than one instance of EPP configured to use the same Oracle database and one schema for each IDM and JCR database.
The first instance of EPP successful starts. However, the second instance starts with error. The following can be seen in the server.log:

Caused by: 
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

IDM tables are created in the database with the schema EPP_01. On the second instance start up, the IDM tables are identified that already exist in EPP_01 schema instead of search for the tables in EPP_02 schema:

INFO  [org.hibernate.tool.hbm2ddl.SchemaUpdate] (main) updating schema
INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (main) table found: EPP_01.JBID_ATTR_BIN_VALUE
INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (main) columns: [value, bin_value_id]
INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (main) foreign keys: []
INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (main) indexes: [sys_c0021079]
INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (main) table found: EPP_01.JBID_CREDEN_BIN_VALUE
INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (main) columns: [value, bin_value_id]
INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (main) foreign keys: []
INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (main) indexes: [sys_c0021081]
INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (main) table found: EPP_01.JBID_IO
....

Environment

JBoss Enterprise Portal Platform (EPP) 5.2

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content