On 2/21/07, Shaun Barriball <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]
Sent: 21 February 2007 15:37
To: [email protected]
Subject: Re: [JCR Browser] Oracle JDBC & JCA Connection questions
On 2/21/07, Andrea K. <[EMAIL PROTECTED]> 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. <[EMAIL PROTECTED]> 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
