You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jackrabbit.apache.org by Rohnny Moland <rm...@gmail.com> on 2008/03/03 16:56:15 UTC
Re: using oracle persistence manager with jndi
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
<th...@gmail.com> 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
>
Re: using oracle persistence manager with jndi
Posted by Thomas Mueller <th...@gmail.com>.
Hi,
Sorry I can't help you with JNDIDatabasePersistenceManager. It does
not include the Oracle specific code. To use the Oracle specific code,
I suggest to use the OraclePersistenceManager. As far as I understood,
you tried that already but it didn't work for you.
Could you post the JNDI configuration, the repository.xml and the
workspace.xml files?
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
Re: using oracle persistence manager with jndi
Posted by Rohnny Moland <rm...@gmail.com>.
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 <rm...@gmail.com> 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
>
> <th...@gmail.com> 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
> >
>