Happy New Year,
As promised, I've submitted an initial implementation of a slide store based on Apache OJB O/R tool. I created a new bug report in bugzilla (Bug 32913) and attached the files.
I've implemented all stores except the content store. Need more time to think about it. The BLOB type is not supported by all databases (though most have some support for large objects) and still need to check if OJB have some generic way of dealing with large binary objects.
There is support for changing the table prefix via a build property. The SQL is generated from the peer classes directly using xdoclet and torque. However, torque doesn't do a good job generating the sql script and the create statements may need to be reordered manually so that tables that are target of referencial integrity constraints are created first. Need to check if commons-sql does a better job.
Also I've implemented a mechanism to store property values that consists of lists like version-set or group-member-set in a separate table, one list item per row.
I tested PostgreSQL 7.4.6/8.0.0rc2 and MySQL 4.1.8. Didn't run the full testsuite, just verified that it basically works by creating some folders and files and creating versions/checkout/checkin, etc.
It's a first try, mostly followed the RDBMS logic and converted it to OJB. Need to optimize the mappings and tune OJB for Slide behaviour.
Oliver, please check it out and go ahead an make any adjustments.
As I said I'll think about the BLOB issue but I won't have much time for this during the following 2 or 3 weeks.
Regards,
Carlos
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
