Hi Andrus, Many thanks for your fast answer.
> First of all I'd suggest you to use release 2.0.3 - this will spare > you some package renaming going forward (as you may have noticed the > only difference between 1.2.3 and 2.0.3 is that "org.objectstyle" > packages are called "org.apache"). Yes I now. But I will use Cayenne with Click Framework and it's currently on 1.2.3 Cayenne version. > > > Caused by: java.sql.SQLSyntaxErrorException: Table/View > > 'AUTO_PK_SUPPORT' does > > not exist. > > Since the Derby path is a relative file name, could it be that it was > created in one directory, but your app, running from a different > directory than the modeler, accesses a different file? You may try > using absolute file name for the derby DB location. E.g. > "jdbc:derby:c:/databases/testdb;create=true" Yes that was the problem. My guess was that Modeler and Java example would use the same default place for database files, but it's not a case. > > > Then I tried to switch from derby to mysql 5.0 database. Everything > > went ok I > > succsesfully created and commited objects to database. When Cayenne > > Modeler > > generates DB Schema, I select "Create FK Support" but Modeler > > dosn't generate > > sql code for foreign keys. MySQL 5 have support for foreign keys, > > do Modeler > > support this? > > It does - only since version 3.0 which is currently Alpha. OK. Regards, Ivica
