FAQ
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?

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/cayenne/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 1 | next ›
Discussion Overview
groupdev @
categoriescayenne
postedApr 22, '06 at 2:53p
activeApr 22, '06 at 2:53p
posts1
users1
websitecayenne.apache.org

1 user in discussion

Borut Bolčina (JIRA): 1 post

People

Translate

site design / logo © 2022 Grokbase