The J2EEStore2 classes use SQL sub-select statements, which are not yet supported by mySQL. Therefore, I found, that the new schema could not be implemented in mySQL without rewriting a large portion of J2EEStore2, using multiple SQL statements bundled in a transaction instead of using SQL sub-selects. A few months ago, I had spent some time doing some of this rewriting, but instead decided to invest my time by moving to PostgreSQL, which is much more SQL92 compliant and can do sub-selects.
-----Original Message----- From: Mark Hortman [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 8:12 AM To: 'Slide Developers Mailing List' Subject: RE: Latest J2EEStore2 based on the new Database Schema Thanks Ashok for the contribution, does anyone have the script for the schema for mySQL, or should I attempt it? Kumar, Ashok wrote: > Hi Christopher, > > Here is the latest version of J2EEStore2 version based on the new database schema. -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
