Cool. I just finished coding a solution of mine last night. You are
way ahead of me.
--David
Richard Zeng wrote:
Hi there,
Lots of people here are interested in using MySQL as repository for
Magnolia, of course including myself. But current persistence manager
in Jackrabbit has some problems which can't be used in production
environment.
I was hoping I can use JNDIDatabasePersistenceManager without changing
anything (I hear it from Felipe), but after looking into the source
code, I realise I can't. It uses the same idea like
SimpleDbPersistenceManager, the only difference is get database
connection from JNDI, but keeping use a single database connection.
So I think maybe the best way is writing my own one. I knew Stephen
has already written one (EnterpriseDbPersistenceManager), and David is
planing to write one, but I don't know when I can access it. After
spending hours on debuging, I just finished my first version of
persistence manager using JNDI connection pool. It's working on my
machine now, and I want to share with others. Also I hope you can test
my persistence manager, and let me know any problems.
The general idea is from SimpleDbPersistenceManager and
JNDIDatabasePersistenceManager. Instead of using one single
connection, this persistence manager will get a database connection
from connection pool every time, and close it after using. The code to
access database keeps the same with SimpleDbPersistenceManager.
To use it, you have to follow David's instruction first.
http://www.magnolia.info/wiki/Wiki.jsp?page=UsingMysqlWithMagnolia2.1.5
Then, you need config a connection pool, change your repository config
to use my persistence manager, also you need have mysql.ddl with my
persistence manager. (I was trying to use the one in Jackrabbit
package, but failed. If you know how, let me know.) I think the config
is quite straightforward, but let me know if you have any problem.
Thank you all for your ideas I get from mailing list, especially for
David's help.
Please have a try. Your comments, suggestions are more than welcome.
It looks like I can't attach my code in my email, for the size. I will
try to put it in somewhere else. If you want to have a try, give me an
email and I will email you the code.
Cheers,
Richard Zeng
([EMAIL PROTECTED])
----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/magnolia/developer.html
----------------------------------------------------------------
----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/magnolia/developer.html
----------------------------------------------------------------
