[JCR-2414] Problem with multiple SCHEMA

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Invalid
• Fix Version/s: 1.6
• Component/s: jackrabbit-core
• Environment: Oracle 9i, Windows XP/Linux
• Assignee: Unassigned
• Reporter: premkumar
• Created: 30/Nov/09 10:40
• Updated: 19/Dec/12 14:41
• Resolved: 30/Nov/09 15:37

Description

I'm having 2 schema (scott & scott1) for a single instance orcl. I Inserted all Jackrabbit dll and made schemaCheckEnabled to false for scott schema and its working fine for scott. But when I try for scott1 Its throwing exception (ORA-00942: table or view does not exist). Attached repository.xml for your reference.

javax.jcr.RepositoryException: File system initialization failure.: failed to initialize file system: failed to initialize file system
at org.apache.jackrabbit.core.config.RepositoryConfigurationParser$4.getFileSystem(RepositoryConfigurationParser.java:825)
at org.apache.jackrabbit.core.config.RepositoryConfig.getFileSystem(RepositoryConfig.java:778)
at org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:268)
at org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:627)
at org.apache.jackrabbit.core.jndi.BindableRepository.createRepository(BindableRepository.java:141)
at org.apache.jackrabbit.core.jndi.BindableRepository.init(BindableRepository.java:117)
at org.apache.jackrabbit.core.jndi.BindableRepository.<init>(BindableRepository.java:106)
at org.apache.jackrabbit.core.jndi.BindableRepositoryFactory.getObjectInstance(BindableRepositoryFactory.java:51)
at org.apache.jackrabbit.core.jndi.RegistryHelper.registerRepository(RegistryHelper.java:74)
at com.jcr.test.ContentRepository.<clinit>(ContentRepository.java:65)
Caused by: org.apache.jackrabbit.core.fs.FileSystemException: failed to initialize file system
at org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.init(DatabaseFileSystem.java:226)
at org.apache.jackrabbit.core.fs.db.OracleFileSystem.init(OracleFileSystem.java:137)
at org.apache.jackrabbit.core.config.RepositoryConfigurationParser$4.getFileSystem(RepositoryConfigurationParser.java:818)
... 9 more
Caused by: org.apache.jackrabbit.core.fs.FileSystemException: failed to check existence of file system root entry
at org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.verifyRootExists(DatabaseFileSystem.java:1387)
at org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.init(DatabaseFileSystem.java:220)
... 11 more
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390)
at org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.executeStmt(DatabaseFileSystem.java:1101)
at org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.verifyRootExists(DatabaseFileSystem.java:1375)
... 12 more

Issue Links

• relates to: JCR-2685 DbDataStore: table check fails on Oracle with multiple users