Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: pass (athena.apache.org: local policy)
From: <Sascha.Theves@bosch-si.com>
To: <users@jackrabbit.apache.org>
Subject: AW: How to set the DB schema name for Jackrabbit
Thread-Topic: How to set the DB schema name for Jackrabbit
Thread-Index: Ac1er09l8XztNHWgSqelyEK9c4Abyv//694A///bckA=
Date: Tue, 10 Jul 2012 16:27:34 +0000
Message-ID: 
 <882B1BAE94A0264DA3B80A9C7D83320A0D239611@IMMPWEXC01.innoimm.local>
References: 
 <882B1BAE94A0264DA3B80A9C7D83320A0D2394E1@IMMPWEXC01.innoimm.local>
 <4FFC5318.3020105@lincware.com>
In-Reply-To: <4FFC5318.3020105@lincware.com>
Accept-Language: de-DE, en-US
Content-Language: de-DE
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

Thanks Stephen, I can really not imagine that nobody has used a db schema n=
ame in Jackrabbit before. I will give your patch a try... But anyway, can s=
omebody from the Jackrabbit committers clearify the behavior here or commen=
t the status of JCR-1180?


-----Urspr=FCngliche Nachricht-----
Von: Stephen Byrne [mailto:stephen@lincware.com]=20
Gesendet: Dienstag, 10. Juli 2012 18:07
An: users@jackrabbit.apache.org
Betreff: Re: How to set the DB schema name for Jackrabbit

On 07/10/2012 11:18 AM, Sascha.Theves@bosch-si.com wrote:
> Hi all,
>
> we are using Jackrabbit 2.2.10. How do I set the DB schema name that Jack=
rabbit should use in the BundlePersistenceManagers, DBFileSystems, DbDataSt=
ores etc...?
>
> I tried to use the property "schemaObjectPrefix" in my repository.xml fil=
e but that doesn`t work. I set the value to something like "SCHEMA.PREFIX_"=
 but Jackrabbit internally replaces the "." char with another one because i=
t thought that it is an invalid table name. DbDataStore doesn`t do this, it=
 just doesn`t call the ConnectionHelper.prepareDbIdentifier method. Maybe s=
omeone has forgotten that.
>
> The second problem is (after fixing the ConnectionHelper.prepareDbIdentif=
ier method) that the ConnectionHelper.tableExists check doesn`t work for so=
me reason and Jackrabbit always tries to create the database tables if the =
"schemaCheckEnabled" property is set to "true". So for me it looks like Jac=
krabbit is unable to deal with database schema names or do I understand som=
ething completely wrong?
>
> Regards,
>
> Sascha
>

https://issues.apache.org/jira/browse/JCR-1180

I submitted a patch for this against 2.2.7, but it never got anywhere.

--=20
Stephen Byrne
stephen@lincware.com