Forgot to say that JNDIDatabasePersistenceManager also needs a
property tableSpace so that it could be set via repository.xml. :)
On Mon, Mar 3, 2008 at 4:56 PM, Rohnny Moland <[EMAIL PROTECTED]> wrote:
> Sorry for late reply. We ended up using a customized
> JNDIDatabasePersistenceManager instead for oracle support in
> jackrabbit 1.4. The only problem is that it has come a new property in
> oracle.ddl for tablespace support. The oracle persistence manager has
> support for this, but not the JNDIDatabasePersistenceManager. So, the
> same support for tablespaces in oracle persistence manager needs to be
> added to JNDIDatabasePersistenceManager
> (DatabasePersistenceManager.java) as well.
>
> From
> org.apache.jackrabbit.core.persistence.db.OraclePersistenceManager.checkSchema:
> ..
> // set the tablespace if it is defined
> String tspace;
> if (tableSpace == null || "".equals(tableSpace)) {
> tspace = "";
> } else {
> tspace = "tablespace " + tableSpace;
> }
> sql = Text.replace(sql, TABLE_SPACE_VARIABLE,
> tspace).trim();
> ..
>
> I wonder if this could be added to the next jackrabbit 1.4.2 release?
> JCR-1309 is no hurry really as long as it is possible to use
> jackrabbit + jndi + oracle with JNDIDatabasePersistenceManager. The
> changes that needs to be made to DatabasePersistenceManager.java is
> rather small.
>
> Kind regards,
> Rohnny
>
> On Thu, Feb 28, 2008 at 1:46 PM, Thomas Mueller
>
> <[EMAIL PROTECTED]> wrote:
>
>
> > Hi,
> >
> > Sorry for the confusion... Actually the main problem was fixed in
> > http://issues.apache.org/jira/browse/JCR-1305 and this is in
> > Jackrabbit core 1.4.1. As Jukka wrote the scope of JCR-1309 is bigger,
> > and you probably you don't need it. Jackrabbit 1.4.1 should be OK.
> >
> > Could you post the JNDI configuration, the repository.xml and the
> > workspace.xml files?
> >
> >
> > > I also tried to define it as a resource in tomcat, but it says that
> > > the data source factory is not supported
> >
> > Could you post the stack trace and error messages? If you got error
> > messages and stack traces in Jackrabbit, could you post that as well
> > please?
> >
> > Regards,
> > Thomas
> >
>