You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@sling.apache.org by Guillaume Lucazeau <gl...@gmail.com> on 2015/11/19 16:44:52 UTC

Connect Jackrabbit to Oracle DB

Hello,

sorry for spamming the mailing list but I'm still discovering Sling and
trying to anticipate questions from my client.

I'm trying to show that Jackrabbit can be persisted in an Oracle DB,
following this article:
https://sling.apache.org/documentation/tutorials-how-tos/jackrabbit-persistence.html

But I don't see these bundles in the Felix console: "Apache Derby" and
"Jackrabbit Embedded Repository".

And when I start Sling, no repository.xml file is created in
sling/repository/.

I'm currently testing with the webapp deployed into Tomcat 7, but I had the
same issue with the standalone jar.

I've tried to create the repository file from
http://svn.apache.org/repos/asf/sling/trunk/bundles/jcr/jackrabbit-server/src/main/resources/repository.xml
and to modify it with OraclePersistenceManager configuration, but it's not
taken in account.

If someone with experience on this topic could give me a few hints that
would be very helpful.

Thank you!
Guillaume

Re: Connect Jackrabbit to Oracle DB

Posted by Dirk Rudolph <di...@netcentric.biz>.
You can at least give it a try and maybe report problems directly to the Oak developers. 

But otherwise yes, I would recommend to do so. 

Cheers,
Dirk Rudolph | Senior Software Engineer

Netcentric AG

M: +41 79 642 37 11
D: +49 174 966 84 34

dirk.rudolph@netcentric.biz <ma...@netcentric.biz> | www.netcentric.biz <http://www.netcentric.biz/>
> On 23 Nov 2015, at 15:48, Guillaume Lucazeau <gl...@gmail.com> wrote:
> 
> Thank you Dirk, I will look at those pages. I've just seen quickly that
> RDBDocumentStore for Oracle is marked as "experimental". Does it mean I
> should really avoid to use it in production, and maybe use Sling 7 and
> Jackrabbit 2.x?
> 
> On Sun, Nov 22, 2015 at 10:28 PM, Dirk Rudolph <di...@netcentric.biz>
> wrote:
> 
>> Hi,
>> 
>> Have a look at
>> 
>> https://jackrabbit.apache.org/oak/docs/osgi_config.html
>> 
>> And
>> 
>> 
>> https://jackrabbit.apache.org/oak/docs/apidocs/org/apache/jackrabbit/oak/plugins/document/DocumentNodeStoreService.html
>> 
>> To find the properties accepted by the Document odeStoreServive.
>> 
>> The one you are looking for might be
>> 
>> 
>> https://jackrabbit.apache.org/oak/docs/apidocs/org/apache/jackrabbit/oak/plugins/document/rdb/RDBDocumentStore.html
>> 
>> I think you can configure it using RDB instead of the default service
>> configuration MONGO.
>> 
>> Cheers, D
>> 
>> On Sunday, 22 November 2015, Guillaume Lucazeau <gl...@gmail.com>
>> wrote:
>> 
>>> Hello Robert,
>>> 
>>> Thank you for your reply, yes I'm testing Sling8.
>>> 
>>> Would you know where I can find documentation about this specific topic
>> on
>>> Oak? I looked up the configuration pages here
>>> http://jackrabbit.apache.org/oak and did some web searches but didn't
>> find
>>> any real procedure. Is it at least possible? Using an Oracle database is
>>> mandatory to my client.
>>> 
>>> Do you know which Oak version is included in Sling 8?
>>> 
>>> Thank you!
>>> Guillaume
>>> 
>>> On Fri, Nov 20, 2015 at 2:29 PM, Robert Munteanu <rombert@apache.org
>>> <javascript:;>> wrote:
>>> 
>>>> Hi Guillame,
>>>> 
>>>> On Thu, 2015-11-19 at 16:44 +0100, Guillaume Lucazeau wrote:
>>>>> Hello,
>>>>> 
>>>>> sorry for spamming the mailing list but I'm still discovering Sling
>>>>> and
>>>>> trying to anticipate questions from my client.
>>>> 
>>>> No need to be sorry, if our docs are not clear enough or out-of-date we
>>>> need to know about it :-)
>>>> 
>>>>> 
>>>>> I'm trying to show that Jackrabbit can be persisted in an Oracle DB,
>>>>> following this article:
>>>>> 
>> https://sling.apache.org/documentation/tutorials-how-tos/jackrabbit-p
>>>>> ersistence.html
>>>>> 
>>>>> But I don't see these bundles in the Felix console: "Apache Derby"
>>>>> and
>>>>> "Jackrabbit Embedded Repository".
>>>>> 
>>>>> And when I start Sling, no repository.xml file is created in
>>>>> sling/repository/.
>>>> 
>>>> Sounds to me like you're using Sling 8. Is that correct? For Sling 8 we
>>>> moved to Jackrabbit Oak as the persistence solution, and Oak is
>>>> configured differently.
>>>> 
>>>> Thanks,
>>>> 
>>>> Robert
>>>> 
>>>>> I'm currently testing with the webapp deployed into Tomcat 7, but I
>>>>> had the
>>>>> same issue with the standalone jar.
>>>>> 
>>>>> I've tried to create the repository file from
>>>>> 
>> http://svn.apache.org/repos/asf/sling/trunk/bundles/jcr/jackrabbit-se
>>>>> rver/src/main/resources/repository.xml
>>>>> and to modify it with OraclePersistenceManager configuration, but
>>>>> it's not
>>>>> taken in account.
>>>>> 
>>>>> If someone with experience on this topic could give me a few hints
>>>>> that
>>>>> would be very helpful.
>>>>> 
>>>>> Thank you!
>>>>> Guillaume
>>>> 
>>>> 
>>> 
>> 
>> 
>> --
>> 
>> Dirk Rudolph | Senior Software Engineer
>> 
>> Netcentric AG
>> 
>> M: +41 79 642 37 11
>> D: +49 174 966 84 34
>> 
>> dirk.rudolph@netcentric.biz | www.netcentric.biz
>> 


Re: Connect Jackrabbit to Oracle DB

Posted by Guillaume Lucazeau <gl...@gmail.com>.
Thank you Dirk, I will look at those pages. I've just seen quickly that
RDBDocumentStore for Oracle is marked as "experimental". Does it mean I
should really avoid to use it in production, and maybe use Sling 7 and
Jackrabbit 2.x?

On Sun, Nov 22, 2015 at 10:28 PM, Dirk Rudolph <di...@netcentric.biz>
wrote:

> Hi,
>
> Have a look at
>
> https://jackrabbit.apache.org/oak/docs/osgi_config.html
>
> And
>
>
> https://jackrabbit.apache.org/oak/docs/apidocs/org/apache/jackrabbit/oak/plugins/document/DocumentNodeStoreService.html
>
> To find the properties accepted by the Document odeStoreServive.
>
> The one you are looking for might be
>
>
> https://jackrabbit.apache.org/oak/docs/apidocs/org/apache/jackrabbit/oak/plugins/document/rdb/RDBDocumentStore.html
>
> I think you can configure it using RDB instead of the default service
> configuration MONGO.
>
> Cheers, D
>
> On Sunday, 22 November 2015, Guillaume Lucazeau <gl...@gmail.com>
> wrote:
>
> > Hello Robert,
> >
> > Thank you for your reply, yes I'm testing Sling8.
> >
> > Would you know where I can find documentation about this specific topic
> on
> > Oak? I looked up the configuration pages here
> > http://jackrabbit.apache.org/oak and did some web searches but didn't
> find
> > any real procedure. Is it at least possible? Using an Oracle database is
> > mandatory to my client.
> >
> > Do you know which Oak version is included in Sling 8?
> >
> > Thank you!
> > Guillaume
> >
> > On Fri, Nov 20, 2015 at 2:29 PM, Robert Munteanu <rombert@apache.org
> > <javascript:;>> wrote:
> >
> > > Hi Guillame,
> > >
> > > On Thu, 2015-11-19 at 16:44 +0100, Guillaume Lucazeau wrote:
> > > > Hello,
> > > >
> > > > sorry for spamming the mailing list but I'm still discovering Sling
> > > > and
> > > > trying to anticipate questions from my client.
> > >
> > > No need to be sorry, if our docs are not clear enough or out-of-date we
> > > need to know about it :-)
> > >
> > > >
> > > > I'm trying to show that Jackrabbit can be persisted in an Oracle DB,
> > > > following this article:
> > > >
> https://sling.apache.org/documentation/tutorials-how-tos/jackrabbit-p
> > > > ersistence.html
> > > >
> > > > But I don't see these bundles in the Felix console: "Apache Derby"
> > > > and
> > > > "Jackrabbit Embedded Repository".
> > > >
> > > > And when I start Sling, no repository.xml file is created in
> > > > sling/repository/.
> > >
> > > Sounds to me like you're using Sling 8. Is that correct? For Sling 8 we
> > > moved to Jackrabbit Oak as the persistence solution, and Oak is
> > > configured differently.
> > >
> > > Thanks,
> > >
> > > Robert
> > >
> > > > I'm currently testing with the webapp deployed into Tomcat 7, but I
> > > > had the
> > > > same issue with the standalone jar.
> > > >
> > > > I've tried to create the repository file from
> > > >
> http://svn.apache.org/repos/asf/sling/trunk/bundles/jcr/jackrabbit-se
> > > > rver/src/main/resources/repository.xml
> > > > and to modify it with OraclePersistenceManager configuration, but
> > > > it's not
> > > > taken in account.
> > > >
> > > > If someone with experience on this topic could give me a few hints
> > > > that
> > > > would be very helpful.
> > > >
> > > > Thank you!
> > > > Guillaume
> > >
> > >
> >
>
>
> --
>
> Dirk Rudolph | Senior Software Engineer
>
> Netcentric AG
>
> M: +41 79 642 37 11
> D: +49 174 966 84 34
>
> dirk.rudolph@netcentric.biz | www.netcentric.biz
>

Re: Connect Jackrabbit to Oracle DB

Posted by Dirk Rudolph <di...@netcentric.biz>.
Hi,

Have a look at

https://jackrabbit.apache.org/oak/docs/osgi_config.html

And

https://jackrabbit.apache.org/oak/docs/apidocs/org/apache/jackrabbit/oak/plugins/document/DocumentNodeStoreService.html

To find the properties accepted by the Document odeStoreServive.

The one you are looking for might be

https://jackrabbit.apache.org/oak/docs/apidocs/org/apache/jackrabbit/oak/plugins/document/rdb/RDBDocumentStore.html

I think you can configure it using RDB instead of the default service
configuration MONGO.

Cheers, D

On Sunday, 22 November 2015, Guillaume Lucazeau <gl...@gmail.com> wrote:

> Hello Robert,
>
> Thank you for your reply, yes I'm testing Sling8.
>
> Would you know where I can find documentation about this specific topic on
> Oak? I looked up the configuration pages here
> http://jackrabbit.apache.org/oak and did some web searches but didn't find
> any real procedure. Is it at least possible? Using an Oracle database is
> mandatory to my client.
>
> Do you know which Oak version is included in Sling 8?
>
> Thank you!
> Guillaume
>
> On Fri, Nov 20, 2015 at 2:29 PM, Robert Munteanu <rombert@apache.org
> <javascript:;>> wrote:
>
> > Hi Guillame,
> >
> > On Thu, 2015-11-19 at 16:44 +0100, Guillaume Lucazeau wrote:
> > > Hello,
> > >
> > > sorry for spamming the mailing list but I'm still discovering Sling
> > > and
> > > trying to anticipate questions from my client.
> >
> > No need to be sorry, if our docs are not clear enough or out-of-date we
> > need to know about it :-)
> >
> > >
> > > I'm trying to show that Jackrabbit can be persisted in an Oracle DB,
> > > following this article:
> > > https://sling.apache.org/documentation/tutorials-how-tos/jackrabbit-p
> > > ersistence.html
> > >
> > > But I don't see these bundles in the Felix console: "Apache Derby"
> > > and
> > > "Jackrabbit Embedded Repository".
> > >
> > > And when I start Sling, no repository.xml file is created in
> > > sling/repository/.
> >
> > Sounds to me like you're using Sling 8. Is that correct? For Sling 8 we
> > moved to Jackrabbit Oak as the persistence solution, and Oak is
> > configured differently.
> >
> > Thanks,
> >
> > Robert
> >
> > > I'm currently testing with the webapp deployed into Tomcat 7, but I
> > > had the
> > > same issue with the standalone jar.
> > >
> > > I've tried to create the repository file from
> > > http://svn.apache.org/repos/asf/sling/trunk/bundles/jcr/jackrabbit-se
> > > rver/src/main/resources/repository.xml
> > > and to modify it with OraclePersistenceManager configuration, but
> > > it's not
> > > taken in account.
> > >
> > > If someone with experience on this topic could give me a few hints
> > > that
> > > would be very helpful.
> > >
> > > Thank you!
> > > Guillaume
> >
> >
>


-- 

Dirk Rudolph | Senior Software Engineer

Netcentric AG

M: +41 79 642 37 11
D: +49 174 966 84 34

dirk.rudolph@netcentric.biz | www.netcentric.biz

Re: Connect Jackrabbit to Oracle DB

Posted by Guillaume Lucazeau <gl...@gmail.com>.
Hello Robert,

Thank you for your reply, yes I'm testing Sling8.

Would you know where I can find documentation about this specific topic on
Oak? I looked up the configuration pages here
http://jackrabbit.apache.org/oak and did some web searches but didn't find
any real procedure. Is it at least possible? Using an Oracle database is
mandatory to my client.

Do you know which Oak version is included in Sling 8?

Thank you!
Guillaume

On Fri, Nov 20, 2015 at 2:29 PM, Robert Munteanu <ro...@apache.org> wrote:

> Hi Guillame,
>
> On Thu, 2015-11-19 at 16:44 +0100, Guillaume Lucazeau wrote:
> > Hello,
> >
> > sorry for spamming the mailing list but I'm still discovering Sling
> > and
> > trying to anticipate questions from my client.
>
> No need to be sorry, if our docs are not clear enough or out-of-date we
> need to know about it :-)
>
> >
> > I'm trying to show that Jackrabbit can be persisted in an Oracle DB,
> > following this article:
> > https://sling.apache.org/documentation/tutorials-how-tos/jackrabbit-p
> > ersistence.html
> >
> > But I don't see these bundles in the Felix console: "Apache Derby"
> > and
> > "Jackrabbit Embedded Repository".
> >
> > And when I start Sling, no repository.xml file is created in
> > sling/repository/.
>
> Sounds to me like you're using Sling 8. Is that correct? For Sling 8 we
> moved to Jackrabbit Oak as the persistence solution, and Oak is
> configured differently.
>
> Thanks,
>
> Robert
>
> > I'm currently testing with the webapp deployed into Tomcat 7, but I
> > had the
> > same issue with the standalone jar.
> >
> > I've tried to create the repository file from
> > http://svn.apache.org/repos/asf/sling/trunk/bundles/jcr/jackrabbit-se
> > rver/src/main/resources/repository.xml
> > and to modify it with OraclePersistenceManager configuration, but
> > it's not
> > taken in account.
> >
> > If someone with experience on this topic could give me a few hints
> > that
> > would be very helpful.
> >
> > Thank you!
> > Guillaume
>
>

Re: Connect Jackrabbit to Oracle DB

Posted by Robert Munteanu <ro...@apache.org>.
Hi Guillame,

On Thu, 2015-11-19 at 16:44 +0100, Guillaume Lucazeau wrote:
> Hello,
> 
> sorry for spamming the mailing list but I'm still discovering Sling
> and
> trying to anticipate questions from my client.

No need to be sorry, if our docs are not clear enough or out-of-date we
need to know about it :-)

> 
> I'm trying to show that Jackrabbit can be persisted in an Oracle DB,
> following this article:
> https://sling.apache.org/documentation/tutorials-how-tos/jackrabbit-p
> ersistence.html
> 
> But I don't see these bundles in the Felix console: "Apache Derby"
> and
> "Jackrabbit Embedded Repository".
> 
> And when I start Sling, no repository.xml file is created in
> sling/repository/.

Sounds to me like you're using Sling 8. Is that correct? For Sling 8 we
moved to Jackrabbit Oak as the persistence solution, and Oak is
configured differently.

Thanks,

Robert

> I'm currently testing with the webapp deployed into Tomcat 7, but I
> had the
> same issue with the standalone jar.
> 
> I've tried to create the repository file from
> http://svn.apache.org/repos/asf/sling/trunk/bundles/jcr/jackrabbit-se
> rver/src/main/resources/repository.xml
> and to modify it with OraclePersistenceManager configuration, but
> it's not
> taken in account.
> 
> If someone with experience on this topic could give me a few hints
> that
> would be very helpful.
> 
> Thank you!
> Guillaume