Hi Georgiev, Thanks for reporting. I have created #1324 for this: https://sourceforge.net/apps/trac/jooq/ticket/1324
Unfortunately, I didn't check whether ALL_COLUMNS.DEFAULTED is available in 10g as well. #1324 should fix this behaviour ASAP. Cheers Lukas 2012/4/19 Georgiev, Rado (MOH) <[email protected]>: > Hi, > > I am getting an exception during code gen with Oracle Database (10g). > This is directly due to the enhancement of ticket 1183: > (http://sourceforge.net/apps/trac/jooq/ticket/1183). I did a search for > this problem on the trac website but found nothing. Note that previous > version (2.0.4 and 2.0.5) worked correctly. > > Here is the actual exception. > 19-Apr-2012 11:57:18 AM org.jooq.tools.JooqLogger error > SEVERE: Error while generating routine SRISTG.SRI_PATIENT_SAFETY_FORM > org.jooq.exception.DataAccessException: AbstractQuery.execute; SQL > [select "SYS"."ALL_ARGUMENTS"."IN_OUT", > "SYS"."ALL_ARGUMENTS"."ARGUMENT_NAME", > "SYS"."ALL_ARGUMENTS"."DATA_TYPE", "SYS"."ALL_ARGUMENTS"."DATA_LENGTH", > "SYS"."ALL_ARGUMENTS"."DATA_PRECISION", > "SYS"."ALL_ARGUMENTS"."DATA_SCALE", "SYS"."ALL_ARGUMENTS"."TYPE_NAME", > "SYS"."ALL_ARGUMENTS"."POSITION", "SYS"."ALL_ARGUMENTS"."DEFAULTED" from > "SYS"."ALL_ARGUMENTS" where ("SYS"."ALL_ARGUMENTS"."OWNER" = ? and > "SYS"."ALL_ARGUMENTS"."OBJECT_NAME" = ? and > "SYS"."ALL_ARGUMENTS"."OBJECT_ID" = ? and > "SYS"."ALL_ARGUMENTS"."OVERLOAD" is null and > "SYS"."ALL_ARGUMENTS"."DATA_LEVEL" = ? and > "SYS"."ALL_ARGUMENTS"."DATA_TYPE" is not null) order by > "SYS"."ALL_ARGUMENTS"."POSITION" asc]; ORA-00904: > "SYS"."ALL_ARGUMENTS"."DEFAULTED": invalid identifier > > at org.jooq.impl.Util.translate(Util.java:472) > at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:150) > at > org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:233) > at > org.jooq.impl.AbstractDelegatingSelect.fetch(AbstractDelegatingSelect.java:97) > at > org.jooq.util.oracle.OracleRoutineDefinition.init0(OracleRoutineDefinition.java:71) > at > org.jooq.util.AbstractRoutineDefinition.init(AbstractRoutineDefinition.java:94) > at > org.jooq.util.AbstractRoutineDefinition.getReturnValue(AbstractRoutineDefinition.java:138) > at > org.jooq.util.DefaultGenerator.printRoutine(DefaultGenerator.java:1805) > at org.jooq.util.DefaultGenerator.generate(DefaultGenerator.java:1498) > at org.jooq.util.DefaultGenerator.generate(DefaultGenerator.java:275) > at org.jooq.util.GenerationTool.main(GenerationTool.java:382) > at org.jooq.util.GenerationTool.main(GenerationTool.java:127) > at gov.moh.ohfs.xls.db.generator.Generator.main(Generator.java:22) > > Here are all the columns for the "SYS"."ALL_ARGUMENTS" table: > OWNER > OBJECT_NAME > PACKAGE_NAME > OBJECT_ID OVERLOAD > SUBPROGRAM_ID > ARGUMENT_NAME > POSITION SEQUENCE > DATA_LEVEL DATA_TYPE > DEFAULT_VALUE > DEFAULT_LENGTH > IN_OUT > DATA_LENGTH > DATA_PRECISION > DATA_SCALE > RADIX > CHARACTER_SET_NAME > TYPE_OWNER > TYPE_NAME > TYPE_SUBNAME > TYPE_LINK > PLS_TYPE > CHAR_LENGTH > CHAR_USED > > As you can see there is no DEFAULTED column which makes for an invalid > identifier in the SQL Syntax > > Here are our database specifications: > Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi > PL/SQL Release 10.2.0.4.0 - Production > CORE 10.2.0.4.0 Production > TNS for Solaris: Version 10.2.0.4.0 - Production > NLSRTL Version 10.2.0.4.0 - Production > > If you need anymore information, I will try to provide as best as I can. > > Regards, > Radoslav Georgiev
