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