Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@jackrabbit.apache.org
Message-ID: <1958196389.1259582421419.JavaMail.jira@brutus>
Date: Mon, 30 Nov 2009 12:00:21 +0000 (UTC)
From: "premkumar (JIRA)" <jira@apache.org>
To: dev@jackrabbit.apache.org
Subject: [jira] Commented: (JCR-2414) Problem with multiple SCHEMA
In-Reply-To: <964476075.1259577680630.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/JCR-2414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12783627#action_12783627 ] 

premkumar commented on JCR-2414:
--------------------------------

Yes I manually set schemaObjectPrefix to SCOTT.(dot) 

All the necessary tables are there in SCOTT schema. SCOTT1 has nothing. I'm using user SCOTT1 and set schemaObjectPrefix to SCOTT.  in Configuration file.
But when I use user SCOTT, Its working fine. I'm missing anything in repository.xml file ???

> Problem with multiple SCHEMA
> ----------------------------
>
>                 Key: JCR-2414
>                 URL: https://issues.apache.org/jira/browse/JCR-2414
>             Project: Jackrabbit Content Repository
>          Issue Type: Bug
>         Environment: Oracle 9i, Windows XP/Linux
>            Reporter: premkumar
>             Fix For: 1.6.0
>
>         Attachments: repository.xml, workspace.xml
>
>
> 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

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.