Mark, I tried using mySQL a few months ago with some of the earlier releases of J2EEStore2 and had spent some time re-working some of the SQL to accomodate mySQL deficiencies. After a week, I gave up and moved to PostgreSQL because it is also OpenSource, but supports a much fuller SQL92 subset (almost everything), including sub-selects. I am much happier now.
Jason -----Original Message----- From: Mark Hortman [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 9:40 AM To: 'Slide Users Mailing List' Subject: J2EEStore2 and mySQL I tried to get the J2EEStore2 working with mySQL and found out that The new code requires nested select statements to function properly. >From what I have read mySQL does not support nested select statements until Version 4, which is out, but "not ready for production boxes." See raging discussion on Slashdot http://developers.slashdot.org/developers/02/08/01/1936238.shtml?tid=126 So I have abandoned my efforts right now. -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
