[
https://issues.apache.org/jira/browse/JCR-2685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Stephan Huttenhuis updated JCR-2685:
------------------------------------
Description: 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 by using the
OracleConnectionHelper if the database type is Oracle. (was: 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.)
> 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 by using the
> OracleConnectionHelper if the database type is Oracle.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
