Re: Schema generation fails in HSQLDB when generating foreign key constraints targeting tables with more than one join

+1 to upgrade. (as long as we figure out how to fix the failing SQL scripts) > On Nov 11, 2016, at 4:02 AM, Aristedes Maniatis wrote: > > On 11/11/16 9:07am, Hugi Thordarson wrote: >> Do you think it’s okay for us to upgrade? Any HSQLDB expert care to comment? > > Not an

Re: Schema generation fails in HSQLDB when generating foreign key constraints targeting tables with more than one join

On 11/11/16 9:07am, Hugi Thordarson wrote: > Do you think it’s okay for us to upgrade? Any HSQLDB expert care to comment? Not an expert in HSQLDB (I tend to use Derby as my lightweight embedded db of choice). But I reckon few people are using HSQLDB for any production purposes, so it is really

Re: Schema generation fails in HSQLDB when generating foreign key constraints targeting tables with more than one join

OK then, it seems the schema generation problem is bound to the HSQLDB version Cayenne is using (1.8.0.4). If I upgrade to the current version (2.3.4) or just anything >=2.0.0, schema generation works fine. However, upgrading to 2.3.4 creates other problems in tests, for example the script