[Cayenne-dev] [JIRA] Created: (CAY-527) MySql AUTO_PK_SUPPORT

MySql AUTO_PK_SUPPORT
---------------------

Key: CAY-527
URL: http://issues.apache.org/cayenne/browse/CAY-527
Project: Cayenne
Type: Bug

Components: Cayenne Core Library
Versions: 1.2 [BETA]
Environment: WinXP, Java 5
Reporter: Borut Bolčina


Hi,

I am constructing database tables with dbGenerator like this

DbGenerator generator = new DbGenerator(autoDbAdapter, dataMap);

generator.setShouldCreatePKSupport(true);
generator.setShouldCreateFKConstraints(true);
generator.setShouldDropTables(false);

generator.runGenerator(dataSource);

This code executes every time an application is restarted. Becouse setShouldDropTables is set to false, the tables in that database are created only the first time - as it should be. But, becouse setShouldCreatePKSupport is set to true, this gets executec every time

INFO QueryLogger: DELETE FROM AUTO_PK_SUPPORT WHERE TABLE_NAME IN ('source')
INFO QueryLogger: INSERT INTO AUTO_PK_SUPPORT (TABLE_NAME, NEXT_ID) VALUES ('source', 200)

Of course I don't want AUTO_PK_SUPPORT to delete and reset values already there from previous application runs. Is there a way, when this

INFO QueryLogger: *** error.
java.sql.SQLException: Table 'AUTO_PK_SUPPORT' already exists

happens, that the above DELETE and INSERT don't happen?