[jira] Updated: (CAY-1040) More control at creating AUTO_PK_SUPPORT table

["Ari Maniatis (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CAY-1040?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ari Maniatis updated CAY-1040:
------------------------------

    Fix Version/s: Undefined future

> More control at creating AUTO_PK_SUPPORT table
> ----------------------------------------------
>
>                 Key: CAY-1040
>                 URL: https://issues.apache.org/jira/browse/CAY-1040
>             Project: Cayenne
>          Issue Type: Improvement
>          Components: Cayenne Core Library
>    Affects Versions: 3.0
>         Environment: 3.0M3
>            Reporter: Borut Bolcina
>            Assignee: Andrus Adamchik
>             Fix For: Undefined future
>
>
> When running DbGenerator with:
>         generator.setShouldCreatePKSupport(true);
> it would be GREAT if one could control if the DELETE and INSERT statements should be executed (maybe even automatically based on error at CREATE). The method could be:
>         generator.setShouldCreatePKSupport(true, false);
> where second false would suppress the execution of DELETE FROM AUTO_PK_SUPPORT and INSERT INTO AUTO_PK_SUPPORT if CREATE fails.
> What do you think?
> Sample output:
>  INFO [14:49:11.712] CREATE TABLE AUTO_PK_SUPPORT (  TABLE_NAME CHAR(100) NOT NULL,  NEXT_ID BIGINT NOT NULL, UNIQUE (TABLE_NAME))
>  INFO [14:49:11.712] *** error.
> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'AUTO_PK_SUPPORT' already exists
>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1026)
>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
>         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
>         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
>         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
>         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
>         at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734)
>         at org.apache.cayenne.access.DbGenerator.safeExecute(DbGenerator.java:352)
>         at org.apache.cayenne.access.DbGenerator.runGenerator(DbGenerator.java:330)
>         at com.interseek.portal.server.Bootstrap.createTables(Bootstrap.java:155)
>         at com.interseek.portal.server.Bootstrap.<init>(Bootstrap.java:58)
>         at com.interseek.portal.server.Bootstrap.main(Bootstrap.java:71)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:585)
>         at org.codehaus.mojo.exec.ExecJavaMojo$1.run(ExecJavaMojo.java:271)
>         at java.lang.Thread.run(Thread.java:595)
>  INFO [14:49:11.712] DELETE FROM AUTO_PK_SUPPORT WHERE TABLE_NAME IN ('table1', 'table2', 'table3')
>  INFO [14:49:11.728] INSERT INTO AUTO_PK_SUPPORT (TABLE_NAME, NEXT_ID) VALUES ('table1', 200)
>  INFO [14:49:11.728] INSERT INTO AUTO_PK_SUPPORT (TABLE_NAME, NEXT_ID) VALUES ('table2', 200)
>  INFO [14:49:11.728] INSERT INTO AUTO_PK_SUPPORT (TABLE_NAME, NEXT_ID) VALUES ('table3', 200)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.