2014-07-16 14:52 GMT+02:00 <[email protected]>: > Sorry maybe i have answer too quick :( > > i have try to generate code with the last source and i obtain thids error > on all tables : > > juil. 16, 2014 2:37:39 PM org.jooq.tools.JooqLogger error > Grave: Error while generating table BOMODULESLINKS > org.jooq.exception.DataAccessException: SQL [select > trim("r"."RDB$FIELD_NAME"), "r"."RDB$DESCRIPTION", "r"."RDB$DEFAULT_VALUE", > bin_or(case when "r"."RDB$NULL_FLAG" is not null then "r"."RDB$NULL_FLAG" > else cast(? as smallint) end, case when "f"."RDB$NULL_FLAG" is not null > then "f"."RDB$NULL_FLAG" else cast(? as smallint) end) "RDB$NULL_FLAG", > "r"."RDB$DEFAULT_SOURCE", "r"."RDB$FIELD_POSITION", case > "f"."RDB$FIELD_TYPE" when cast(? as smallint) then cast(? as smallint) else > "f"."RDB$CHARACTER_LENGTH" end "CHARACTER_LENGTH", > "f"."RDB$FIELD_PRECISION", -("f"."RDB$FIELD_SCALE") "FIELD_SCALE", case > "f"."RDB$FIELD_TYPE" when cast(? as smallint) then case when > "f"."RDB$FIELD_SUB_TYPE" = cast(? as smallint) then cast(? as > varchar(4000)) when ("f"."RDB$FIELD_SUB_TYPE" = cast(? as smallint) and > "f"."RDB$FIELD_SCALE" < cast(? as smallint)) then cast(? as varchar(4000)) > when "f"."RDB$FIELD_SUB_TYPE" = cast(? as smallint) then cast(? as > varchar(4000)) else cast(? as varchar(4000)) end when cast(? as smallint) > then case when "f"."RDB$FIELD_SUB_TYPE" = cast(? as smallint) then cast(? > as varchar(4000)) when ("f"."RDB$FIELD_SUB_TYPE" = cast(? as smallint) and > "f"."RDB$FIELD_SCALE" < cast(? as smallint)) then cast(? as varchar(4000)) > when "f"."RDB$FIELD_SUB_TYPE" = cast(? as smallint) then cast(? as > varchar(4000)) else cast(? as varchar(4000)) end when cast(? as smallint) > then cast(? as varchar(4000)) when cast(? as smallint) then cast(? as > varchar(4000)) when cast(? as smallint) then cast(? as varchar(4000)) when > cast(? as smallint) then cast(? as varchar(4000)) when cast(? as smallint) > then cast(? as varchar(4000)) when cast(? as smallint) then cast(? as > varchar(4000)) when cast(? as smallint) then case when > "f"."RDB$FIELD_SUB_TYPE" = cast(? as smallint) then cast(? as > varchar(4000)) when ("f"."RDB$FIELD_SUB_TYPE" = cast(? as smallint) and > "f"."RDB$FIELD_SCALE" < cast(? as smallint)) then cast(? as varchar(4000)) > when "f"."RDB$FIELD_SUB_TYPE" = cast(? as smallint) then cast(? as > varchar(4000)) else cast(? as varchar(4000)) end when cast(? as smallint) > then cast(? as varchar(4000)) when cast(? as smallint) then cast(? as > varchar(4000)) when cast(? as smallint) then cast(? as varchar(4000)) when > cast(? as smallint) then cast(? as varchar(4000)) when cast(? as smallint) > then case "f"."RDB$FIELD_SUB_TYPE" when cast(? as smallint) then cast(? as > varchar(4000)) when cast(? as smallint) then cast(? as varchar(4000)) else > cast(? as varchar(4000)) end else cast(? as varchar(4000)) end > "FIELD_TYPE", "f"."RDB$FIELD_SUB_TYPE" from "RDB$RELATION_FIELDS" "r" left > outer join "RDB$FIELDS" "f" on "r"."RDB$FIELD_SOURCE" = > "f"."RDB$FIELD_NAME" where "r"."RDB$RELATION_NAME" = cast(? as char) order > by "r"."RDB$FIELD_POSITION" asc]; GDS Exception. 335544569. Dynamic SQL > Error > SQL error code = -204 > Implementation limit exceeded > block size exceeds implementation restriction > at org.jooq.impl.Utils.translate(Utils.java:1435) > at > org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:505) > at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:340) > at org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:336) > at org.jooq.impl.SelectImpl.fetch(SelectImpl.java:2256) > at > org.jooq.util.firebird.FirebirdTableDefinition.getElements0(FirebirdTableDefinition.java:79) > at > org.jooq.util.AbstractElementContainerDefinition.getElements(AbstractElementContainerDefinition.java:90) > at > org.jooq.util.AbstractTableDefinition.getColumns(AbstractTableDefinition.java:138) > at > org.jooq.util.AbstractTableDefinition.getPrimaryKey(AbstractTableDefinition.java:78) > at org.jooq.util.JavaGenerator.generateTable(JavaGenerator.java:1829) > at org.jooq.util.JavaGenerator.generateTables(JavaGenerator.java:1818) > at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:232) > at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:216) > at org.jooq.util.GenerationTool.run(GenerationTool.java:374) > at org.jooq.util.GenerationTool.main(GenerationTool.java:173) > at org.jooq.util.GenerationTool.main(GenerationTool.java:160) > Caused by: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. > Dynamic SQL Error > SQL error code = -204 > Implementation limit exceeded > block size exceeds implementation restriction > at > org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:141) > > > It seems that the generated sql exeed the 64kb limit size ( > http://www.firebirdfaq.org/faq299/) >
Thanks for the update. Now I remember that this was the reason for this fix: https://github.com/jOOQ/jOOQ/issues/1727 Quite unfortunate :-/ I have reverted that change for now ( https://github.com/jOOQ/jOOQ/issues/3398) -- 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.
