cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ivica Puljic <ivicapul...@gmail.com>
Subject Re: problem with derby and question about mysql
Date Tue, 10 Jul 2007 23:39:15 GMT
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

Mime
View raw message