[
https://issues.apache.org/jira/browse/JCR-2685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Stephan Huttenhuis updated JCR-2685:
------------------------------------
Attachment: JCR-2685.patch
Attached patch that uses the OracleConnectionHelper if the database is oracle
and checks with username.
> DbDataStore: table check fails on Oracle with multiple users
> ------------------------------------------------------------
>
> Key: JCR-2685
> URL: https://issues.apache.org/jira/browse/JCR-2685
> Project: Jackrabbit Content Repository
> Issue Type: Bug
> Components: jackrabbit-core
> Affects Versions: 2.1.0
> Reporter: Stephan Huttenhuis
> Attachments: JCR-2685.patch
>
>
> If several users run several JackRabbit instances on the same Oracle database
> the check if the DATATORE table exists always returns true if one user
> already created the table. As a result, the table is not created for other
> users.
> This can be fixed by supplying the username as schema. This is already
> implemented for the BundleDbPersistenceManager. Here the checkTablesWithUser
> method returns whether the username should be supplied as schema. The default
> is false, but the OraclePersistenceManager returns true. The same mechanism
> should be applied to the DbDataStore. Also, setting the SchemaObjectPrefix
> should always be uppercase.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
