I believe that there is a problem with how the DDL statements are being
constructed. I would like to know if anyone else sees this as a problem.
DSLContext create = DSL.using(getConnection(), SQLDialect.DERBY);
Queries queries = create.ddl(getUserSchema());
The "ALTER" queries do not have their constraints named. In the exception
below, the name of the constraint is expected but the keyword "foreign" was
encountered. In the original creation script for the database all
constraints were named but the name 'EdgeArc' was not captured by the
create.ddl() statement.
ALTER TABLE Arc ADD CONSTRAINT EdgeArc FOREIGN KEY (Edge) REFERENCES Edge
(ID);
SQLException when executing alter table "APP"."ARC" add constraint foreign
key ("EDGE") references "EDGE" ("ID")
java.sql.SQLSyntaxErrorException: Syntax error: Encountered "foreign" at
line 1, column 41.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at
dbtools.dbutil.EmbeddedDerbyDatabase.executeCommand(EmbeddedDerbyDatabase.java:680)
at
dbtools.dbutil.EmbeddedDerbyDatabase.executeCommands(EmbeddedDerbyDatabase.java:710)
at
dbtools.dbutil.EmbeddedDerbyDatabase.duplicate(EmbeddedDerbyDatabase.java:210)
at
dbtools.dbutil.EmbeddedDerbyDatabase.testWrting(EmbeddedDerbyDatabase.java:910)
at
dbtools.dbutil.EmbeddedDerbyDatabase.main(EmbeddedDerbyDatabase.java:882)
Caused by: ERROR 42X01: Syntax error: Encountered "foreign" at line 1,
column 41.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.sql.compile.ParserImpl.parseStatementOrSearchCondition(Unknown
Source)
at org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown
Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
