Unfortunatly, I got some deadlock issues when this store makes some delete.
Do you know how to solve this problem ?
Without deletes, everything works fine, I can run 100 threads without any problems but when one thread starts a delete I got a deadlock.
Any help is welcome. So, I'm looking for a J2EE store wich is working with MySql
Christophe
[EMAIL PROTECTED] wrote:
The slidestore.j2ee.J2EEStore work was done by Ashok to provide a merged store, which is transactionally correct. We use a version of it in our product.
We discovered in the original J2EEStore model, where the stores were
separate classes that the transactions were not clean and database
deadlocks could occour. The issue was locking of tables could occour
when multiple transactions worked at the same time or when large files
were added, in addition when transmission problems occurred rollbacks
did not complete cleanly. The DB pooling (we use Jakarta DBCP in Tomcat)
would end up using two separate transactions for the two stores and this
clearly created those issues.
The merged stores use a common connection for both content and descriptors which is tied to a slide transaction, this stops the deadlocks and ensures accurate rollback. In addition we added the ability to compress the content going into the blob of the DB using zip compression. We found when using large XML files this improved overall performance.
I believe that org.apache.slide.store.impl.rdbms.J2EEStore is a refactor of the slidestore.j2ee.J2EEStore , this uses an adaptor and generally a nicer Java approach, but I believe was not finished. I am not sure if it corrected/dealt with the transactional issues, but from a brief look it auto-committed the connection so I am not sure it does transactions cleanly.
Hopefully that helps some. We can re-post the latest version of the
store we use. It has been tested with the latest from CVS, but really it
needs refactoring into the same style as
org.apache.slide.store.impl.rdbms.J2EEStore .
Rgds CB
-----Original Message-----
From: Oliver Zeigermann [mailto:[EMAIL PROTECTED] Sent: Monday, November 03, 2003 4:45 AM
To: Slide Developers Mailing List
Subject: Re: REQUEST FOR HELP/COMMENT: Store problems
I did some investigations as well. My aim is to concentrate the scattered efforts and merge all our work into one implementation everyone can live with.
It seems a lot of branching has occured, and there are two main branches
of the J2EE stuff:
org.apache.slide.store.impl.rdbms.J2EEStore
- CVS HEAD
- Modifications to support MySQL by Grant Gongaware June 2003:http://www.mail-archive.com/[EMAIL PROTECTED]/msg03870.
html
- Modifications for Oracle by Doug Harmon June 2003 (not published): http://www.mail-archive.com/[EMAIL PROTECTED]/msg03869.html
slidestore.j2ee.J2EEStore
- CVS HEAD
- Patches by Ashok Kumar January 2003 (does not build on CVS HEAD, but rather replaces it, as it combines both stores): http://www.mail-archive.com/[EMAIL PROTECTED]/msg05504.html seemingly as an update of http://www.mail-archive.com/[EMAIL PROTECTED]/msg05504.html
- Stuff posted by Willie Vu June 2003 (might be based on Ashok's work, but unclear to me): http://www.mail-archive.com/[EMAIL PROTECTED]/msg03917.html
My questions: 1.) Are there more sub-branches / modifications of either main branch? 2.) Why does branch one use an adapter, while branch two does not? 3.) Which RDBMS are supported by either branch #1 and #2?
Thanks for ANY input.
Oliver
Colin Britton wrote:
Ashok and I will revisit where it all got to and try and either patch
the unfinished rdbms.J2EEStore or figure something out. This needs cleaning up as right now the different versions are confusing.
rgds CB
----- Original Message ----- From: "Oliver Zeigermann" <[EMAIL PROTECTED]> To: "Slide Developers Mailing List" <[EMAIL PROTECTED]> Sent: Friday, October 24, 2003 5:33 AM Subject: Re: REQUEST FOR HELP/COMMENT: Store problems
Hi Christopher,
thanks for commenting!
Christopher Lenz wrote:
The rdbms.J2EEStore was my attempt to refactor the JDBC and J2EE
stores based on a new schema submitted by Ashok Kumar. Unfortunately it was never finished, and AFAIK it doesn't even work correctly in its current incarnation.
Ooops! Thanks for telling me! What about the stuff in slidestore.j2ee? Does it work?
Ashok has since posted updated versions of the new schema and store
implementation, which unfortunately also resulted in the code base being forked (i.e. Ashok did not switch to the version committed in slide's CVS repository and build upon that version).
So the posted updates were not applied at all? Or all to slidestore.j2ee?
While it may appear that this implementation is a "production quality
store", it is a work in progress that has never been finished, and
*will* never get finished if nobody picks up where I left. But as this is open-source, *you* can be the one to continue it if you see the potential ;-)
Understood. I will have to concentrate on the file store first. If I get it stable, let's see what I can do.
Oliver
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
