Do you support Oracle 10g? I am getting below error when trying to generate the code. Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "SYS"."ALL_PROCEDURES"."OBJECT_TYPE": invalid identifier
On Thursday, 19 April 2012 13:08:06 UTC-4, Lukas Eder wrote: > > 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] <javascript:>>: > > 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 > > -- 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/groups/opt_out.
