Re: problem with derby and question about mysql

From: Ivica Puljic (ivicapulji..mail.com)
Date: Tue Jul 10 2007 - 19:39:15 EDT

  • Next message: Andrus Adamchik: "Re: problems with Oracle stored procedure"

    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