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:[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
