With regard to "Justis Peters" comments: > I am passionate about this issue for only two reasons: > - MySQL does not support subqueries > - MySQL does not support UNION statements
I totally agree! This has been my main reason for not using MySQL for certain projects. However things have moved on: Mysql 4 (production release) supports UNION statements. Mysql 4.1 (currently in alpha release) supports subqueries. More interestingly, the merging of the "industrial strength" SAPDB with MySQL should end up with MySQL losing it's "toy database" stigma. Back on topic: I've used OJB with mysql and hsqldb (embedded mode). The second has been a little tricky due to the single connection limit. I had no problems with mysql. If you're not going to use any direct SQL to query the database, and no other apps are accessing the database, then as far as OJB is concerned it doesnt matter! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
