I have found at least 1 problem reported here: http://jira.codehaus.org/browse/CASTOR-1231
If you have a table where all the fields are part of the primary key then the SQL generated will be wrong. I have that problem with MS-SQL but I don't know that bug also apply to MySQL. On 10/7/05, Charles Read <[EMAIL PROTECTED]> wrote: > I substituted castor-0.9.9.jar for castor-0.9.7.jar, > rebuilt my webapp and then redeployed it. > > Mostly, everything worked ok. However, at some > point I got a PersistenceException (that in turn was > triggered by an SQLException). The exception message > says that "You have an error in your SQL syntax; ..." > > I am using MySQL 4.1. The webapp works fine > with castor-0.9.7.jar. > > Question: has OQL changed in castor-0.9.9.jar? > > NOTE: I looked at the docs for OQL on castor.org, > but found no reference to OQL changes for 0.9.9. > > Thanks. > ------------------------------------------------- If you wish to unsubscribe from this list, please send an empty message to the following address: [EMAIL PROTECTED] -------------------------------------------------

