Multiple JCR and IDM databases on EPP
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.