Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (nike.apache.org: domain of mr.abanjo@gmail.com designates
 209.85.219.32 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:mime-version:content-type;
        b=cO/bi0NwuP5r9visQ8NU0kdDgvbEWbhbWAnfXiiY0hvY+qMQ+KXpCmR8IvqCoMYLdD
         uvJcKMMQfsL6s8s45C0hOhpXsZ1jaZBMUgiXT51YXCzW0nNM//dQS5UsoCkP2kCJA8Ij
         hBr45QoluSVMTwCqwd8Z+y/pdecbA7qh4+/sM=
Message-ID: <90cd2d0901140546p6c6fa14di6c9cbd7840da95f4@mail.gmail.com>
Date: Wed, 14 Jan 2009 14:46:49 +0100
From: mr.abanjo <mr.abanjo@gmail.com>
To: user@cayenne.apache.org
Subject: DB Generation
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_346625_1687280.1231940810002"

------=_Part_346625_1687280.1231940810002
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,i have configured a simple cayenne datamap for my application with 2
table.
All works fine, i can read/write into them without problem.

Now, i want to create at runtime the database schema, so if is the first
time and the database is empty i can generate it on the fly.
I do it with this code (taken from petstore sample in cayenne's wiki):


      DataDomain domain =
Configuration.getSharedConfiguration().getDomain();

      DataNode node = getDataNode(domain);
      DbGenerator generator = new DbGenerator(node.getAdapter(),
getDataMap(domain));
      try {
        generator.runGenerator(node.getDataSource());
      } catch (Exception e) {
        throw new Exception("Error generating DB schema", e);
      }

If i test this code on a HSQLDB it works well.
The strange thing is that after execution i have 3 tables instead of 2...
infact there is also "AUTO_PK_SUPPORT" that i haven't defined in my datamap.
I suppose that it is a table used by canyenne.

But if i test it on MYSQL db it doesn't work.
ONLY the "AUTO_PK_SUPPORT" is created.

Anyone have idea why the same code works in 2 different way?

The user that i use to connect to mysql haves all privileges.


Thanks
Davide

------=_Part_346625_1687280.1231940810002--