[PATCH] J2EEStore (schema 2) needs to commit

[Joel Boehland <jo...@memes.com>]

Hi!
I have been using the J2EEStore that 
uses the newer db schema, and I have 
found a problem when using under 
jboss/tomcat.  For some reason in the 
commit() and rollback() methods, the 
sections where the connection is called 
with connection.commit() or 
connection.rollback() are commented out, 
with a comment that says: "Not needed as 
transactional".  I found this to not be 
true, at least when using the datasource 
provided with jboss-- nothing will ever 
be committed to the db. I found that 
when I uncommented these sections, it 
all works fine. I am providing a patch 
that uncomments these sections.

I have also included a rough postgresql 
schema ported from the ones provided for 
hsql and mssql. It doesn't have any of 
the referential integrity constraints, 
as I have found them to cause problems. 
Hopefully I will have some time to look 
into this a little more to see if I can 
add the ref-integrity stuff later.

Please let me know if either the patch 
or the postgresql schema are 
unacceptable to be included into the 
slide codebase, and I will try to fix it 
so that it is acceptable.

Thanks!
Joel Boehland