Thanks Stephen, I can really not imagine that nobody has used a db schema name in Jackrabbit before. I will give your patch a try... But anyway, can somebody from the Jackrabbit committers clearify the behavior here or comment the status of JCR-1180?
-----Ursprüngliche Nachricht----- Von: Stephen Byrne [mailto:[email protected]] Gesendet: Dienstag, 10. Juli 2012 18:07 An: [email protected] Betreff: Re: How to set the DB schema name for Jackrabbit On 07/10/2012 11:18 AM, [email protected] wrote: > Hi all, > > we are using Jackrabbit 2.2.10. How do I set the DB schema name that > Jackrabbit should use in the BundlePersistenceManagers, DBFileSystems, > DbDataStores etc...? > > I tried to use the property "schemaObjectPrefix" in my repository.xml file > but that doesn`t work. I set the value to something like "SCHEMA.PREFIX_" but > Jackrabbit internally replaces the "." char with another one because it > thought that it is an invalid table name. DbDataStore doesn`t do this, it > just doesn`t call the ConnectionHelper.prepareDbIdentifier method. Maybe > someone has forgotten that. > > The second problem is (after fixing the ConnectionHelper.prepareDbIdentifier > method) that the ConnectionHelper.tableExists check doesn`t work for some > reason and Jackrabbit always tries to create the database tables if the > "schemaCheckEnabled" property is set to "true". So for me it looks like > Jackrabbit is unable to deal with database schema names or do I understand > something 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. -- Stephen Byrne [email protected]
