You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jackrabbit.apache.org by "Andrea K." <ak...@alteanet.it> on 2007/02/21 16:09:39 UTC
Re: [JCR Browser] Oracle JDBC & JCA Connection questions
I explain questione nr. 1:
- OraclePersistenceManager/OracleFileSystem works
- JNDIDatabaseFileSystem/JNDIDatabasePersistenceManager give me the NULL
error creating workspace tables on Oracle 10g.
Any help for question nr. 2?
Thanks a lot.
Andrea -
Stefan Guggisberg wrote:
>
> On 2/20/07, Andrea K. <ak...@alteanet.it> wrote:
>>
>> Hi all,
>> two questions about JackRabbit:
>>
>> 1 - I have some error configuring repository connection over jdbc in
>> repository.xml using Oracle 10g db, creating a repository it returns a
>> strange error, giving me the impossibility to create a table with NULL
>> values. It works correctly when using
>> OraclePersistenceManager/OracleFileSystem, tables ok and connect
>> succesfully
>> to repository. Help needed to user a jdbc connection to database.
>
> sorry, i can't follow you here. you're saying that
> OraclePersistenceManager/OracleFileSystem does work... so what's your
> problem?
>
> cheers
> stefan
>
>>
>> 2 - General questions. I configured JackRabbit as a JCA resource on
>> Oracle
>> 10g AppServer (rar file), it works in the correct manner. The questions
>> are:
>> what is the best way to configure the jca resource (pool, etc...)? what
>> is
>> the best code snippet to connect to and to use repository by my web
>> application?
>>
>> Thanks in advance.
>> Best regards,
>> Andrea -
>> --
>> View this message in context:
>> http://www.nabble.com/Oracle-JDBC---JCA-Connection-questions-tf3261698.html#a9065435
>> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
>>
>>
>
>
--
View this message in context: http://www.nabble.com/Oracle-JDBC---JCA-Connection-questions-tf3261698.html#a9082439
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
Re: Oracle JDBC and persistence managers
Posted by Stefan Guggisberg <st...@gmail.com>.
On 2/21/07, Shaun Barriball <sb...@yahoo.co.uk> wrote:
> The "Oracle JDBC & JCA Connection questions" thread has included a number of
> useful recommendations on which Persistence Managers to use, over and above
> info available on the faq
> (http://jackrabbit.apache.org/faq.html#pm-available)
>
> Is there a good resource which summarises all the latest known info on
> Persistence Managers?
>
> For our own setup I'm specifically interested in:
> 1) what are the benefits of using the SimpleDbPersistenceManager versus
> OraclePersistenceManager when using Oracle? (We're using Oracle and hadn't
> realised there was a dedicated manager)
i wrote the dedicated oracle pm because SimpleDbPersistenceManager
didn't work with certain oracle jdbc driver/db versions. i am
surprised that SimpleDbPersistenceManager works for you on oracle ;)
what i know for sure is that the geenric DatabaseFileSystem doesn't
work with oracle.
>
> 2) is anyone out there using MySql with the SimpleDbPersistenceManager?
>
> We've already found Oracle/SimpleDbPersistenceManager to be much faster than
> DerbyPersistenceManager.
this is hard to believe, i experienced the exact opposite. anyway, i
am glad that it is fast ;)
cheers
stefan
>
> Regards,
> Shaun.
>
> -----Original Message-----
> From: Stefan Guggisberg [mailto:stefan.guggisberg@gmail.com]
> Sent: 21 February 2007 15:37
> To: users@jackrabbit.apache.org
> Subject: Re: [JCR Browser] Oracle JDBC & JCA Connection questions
>
> On 2/21/07, Andrea K. <ak...@alteanet.it> wrote:
> >
> > I explain questione nr. 1:
> > - OraclePersistenceManager/OracleFileSystem works
> > - JNDIDatabaseFileSystem/JNDIDatabasePersistenceManager give me the
> > NULL error creating workspace tables on Oracle 10g.
>
> ok, now i see what you mean. the JNDIDatabase* classes don't support oracle.
> oracle has some, erm..., rather peculiar 'features', like for instance
> treating empty strings as null values, which require specialized handling :(
>
> is there a specific reason for not using OraclePersistenceManager?
>
> anyway, feel free to file a jira enhancement request.
>
> cheers
> stefan
> >
> > Any help for question nr. 2?
> >
> > Thanks a lot.
> > Andrea -
> >
> >
> > Stefan Guggisberg wrote:
> > >
> > > On 2/20/07, Andrea K. <ak...@alteanet.it> wrote:
> > >>
> > >> Hi all,
> > >> two questions about JackRabbit:
> > >>
> > >> 1 - I have some error configuring repository connection over jdbc
> > >> in repository.xml using Oracle 10g db, creating a repository it
> > >> returns a strange error, giving me the impossibility to create a
> > >> table with NULL values. It works correctly when using
> > >> OraclePersistenceManager/OracleFileSystem, tables ok and connect
> > >> succesfully to repository. Help needed to user a jdbc connection to
> > >> database.
> > >
> > > sorry, i can't follow you here. you're saying that
> > > OraclePersistenceManager/OracleFileSystem does work... so what's
> > > your problem?
> > >
> > > cheers
> > > stefan
> > >
> > >>
> > >> 2 - General questions. I configured JackRabbit as a JCA resource on
> > >> Oracle 10g AppServer (rar file), it works in the correct manner.
> > >> The questions
> > >> are:
> > >> what is the best way to configure the jca resource (pool, etc...)?
> > >> what is the best code snippet to connect to and to use repository
> > >> by my web application?
> > >>
> > >> Thanks in advance.
> > >> Best regards,
> > >> Andrea -
> > >> --
> > >> View this message in context:
> > >> http://www.nabble.com/Oracle-JDBC---JCA-Connection-questions-tf3261
> > >> 698.html#a9065435 Sent from the Jackrabbit - Users mailing list
> > >> archive at Nabble.com.
> > >>
> > >>
> > >
> > >
> >
> > --
> > View this message in context:
> > http://www.nabble.com/Oracle-JDBC---JCA-Connection-questions-tf3261698
> > .html#a9082439 Sent from the Jackrabbit - Users mailing list archive
> > at Nabble.com.
> >
> >
>
>
>
> ___________________________________________________________
> Copy addresses and emails from any email account to Yahoo! Mail - quick, easy and free. http://uk.docs.yahoo.com/trueswitch2.html
>
Oracle JDBC and persistence managers
Posted by Shaun Barriball <sb...@yahoo.co.uk>.
The "Oracle JDBC & JCA Connection questions" thread has included a number of
useful recommendations on which Persistence Managers to use, over and above
info available on the faq
(http://jackrabbit.apache.org/faq.html#pm-available)
Is there a good resource which summarises all the latest known info on
Persistence Managers?
For our own setup I'm specifically interested in:
1) what are the benefits of using the SimpleDbPersistenceManager versus
OraclePersistenceManager when using Oracle? (We're using Oracle and hadn't
realised there was a dedicated manager)
2) is anyone out there using MySql with the SimpleDbPersistenceManager?
We've already found Oracle/SimpleDbPersistenceManager to be much faster than
DerbyPersistenceManager.
Regards,
Shaun.
-----Original Message-----
From: Stefan Guggisberg [mailto:stefan.guggisberg@gmail.com]
Sent: 21 February 2007 15:37
To: users@jackrabbit.apache.org
Subject: Re: [JCR Browser] Oracle JDBC & JCA Connection questions
On 2/21/07, Andrea K. <ak...@alteanet.it> wrote:
>
> I explain questione nr. 1:
> - OraclePersistenceManager/OracleFileSystem works
> - JNDIDatabaseFileSystem/JNDIDatabasePersistenceManager give me the
> NULL error creating workspace tables on Oracle 10g.
ok, now i see what you mean. the JNDIDatabase* classes don't support oracle.
oracle has some, erm..., rather peculiar 'features', like for instance
treating empty strings as null values, which require specialized handling :(
is there a specific reason for not using OraclePersistenceManager?
anyway, feel free to file a jira enhancement request.
cheers
stefan
>
> Any help for question nr. 2?
>
> Thanks a lot.
> Andrea -
>
>
> Stefan Guggisberg wrote:
> >
> > On 2/20/07, Andrea K. <ak...@alteanet.it> wrote:
> >>
> >> Hi all,
> >> two questions about JackRabbit:
> >>
> >> 1 - I have some error configuring repository connection over jdbc
> >> in repository.xml using Oracle 10g db, creating a repository it
> >> returns a strange error, giving me the impossibility to create a
> >> table with NULL values. It works correctly when using
> >> OraclePersistenceManager/OracleFileSystem, tables ok and connect
> >> succesfully to repository. Help needed to user a jdbc connection to
> >> database.
> >
> > sorry, i can't follow you here. you're saying that
> > OraclePersistenceManager/OracleFileSystem does work... so what's
> > your problem?
> >
> > cheers
> > stefan
> >
> >>
> >> 2 - General questions. I configured JackRabbit as a JCA resource on
> >> Oracle 10g AppServer (rar file), it works in the correct manner.
> >> The questions
> >> are:
> >> what is the best way to configure the jca resource (pool, etc...)?
> >> what is the best code snippet to connect to and to use repository
> >> by my web application?
> >>
> >> Thanks in advance.
> >> Best regards,
> >> Andrea -
> >> --
> >> View this message in context:
> >> http://www.nabble.com/Oracle-JDBC---JCA-Connection-questions-tf3261
> >> 698.html#a9065435 Sent from the Jackrabbit - Users mailing list
> >> archive at Nabble.com.
> >>
> >>
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/Oracle-JDBC---JCA-Connection-questions-tf3261698
> .html#a9082439 Sent from the Jackrabbit - Users mailing list archive
> at Nabble.com.
>
>
___________________________________________________________
Copy addresses and emails from any email account to Yahoo! Mail - quick, easy and free. http://uk.docs.yahoo.com/trueswitch2.html
Re: [JCR Browser] Oracle JDBC & JCA Connection questions
Posted by Stefan Guggisberg <st...@gmail.com>.
On 2/21/07, Andrea K. <ak...@alteanet.it> wrote:
>
> I explain questione nr. 1:
> - OraclePersistenceManager/OracleFileSystem works
> - JNDIDatabaseFileSystem/JNDIDatabasePersistenceManager give me the NULL
> error creating workspace tables on Oracle 10g.
ok, now i see what you mean. the JNDIDatabase* classes don't support oracle.
oracle has some, erm..., rather peculiar 'features', like for instance
treating empty strings as null values, which require specialized
handling :(
is there a specific reason for not using OraclePersistenceManager?
anyway, feel free to file a jira enhancement request.
cheers
stefan
>
> Any help for question nr. 2?
>
> Thanks a lot.
> Andrea -
>
>
> Stefan Guggisberg wrote:
> >
> > On 2/20/07, Andrea K. <ak...@alteanet.it> wrote:
> >>
> >> Hi all,
> >> two questions about JackRabbit:
> >>
> >> 1 - I have some error configuring repository connection over jdbc in
> >> repository.xml using Oracle 10g db, creating a repository it returns a
> >> strange error, giving me the impossibility to create a table with NULL
> >> values. It works correctly when using
> >> OraclePersistenceManager/OracleFileSystem, tables ok and connect
> >> succesfully
> >> to repository. Help needed to user a jdbc connection to database.
> >
> > sorry, i can't follow you here. you're saying that
> > OraclePersistenceManager/OracleFileSystem does work... so what's your
> > problem?
> >
> > cheers
> > stefan
> >
> >>
> >> 2 - General questions. I configured JackRabbit as a JCA resource on
> >> Oracle
> >> 10g AppServer (rar file), it works in the correct manner. The questions
> >> are:
> >> what is the best way to configure the jca resource (pool, etc...)? what
> >> is
> >> the best code snippet to connect to and to use repository by my web
> >> application?
> >>
> >> Thanks in advance.
> >> Best regards,
> >> Andrea -
> >> --
> >> View this message in context:
> >> http://www.nabble.com/Oracle-JDBC---JCA-Connection-questions-tf3261698.html#a9065435
> >> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
> >>
> >>
> >
> >
>
> --
> View this message in context: http://www.nabble.com/Oracle-JDBC---JCA-Connection-questions-tf3261698.html#a9082439
> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
>
>