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
This archive was generated by hypermail 2.0.0 : Tue Jul 10 2007 - 19:39:54 EDT