I searched for more information on OTN, and it seems that this column was
first introduced in the 10.2 release of Oracle 10g.
My Oracle database is in 10.1.0.5 so ...
I'm not sure to be able to do the job locally (modify
"org.jooq.util.database.OracleDatabase.java" class and rebuild ...)
...
Philippe Colin
Le mardi 7 mai 2013 11:07:42 UTC+2, Philippe Colin a écrit :
> Hi,
> I'm very interrested in using jOOQ for some of my professional needs, but
> ...
> for my firt use of jooq-codegen-3.0.0, I've got this error :
>
> ******************************************************************************************************
> mai 07, 2013 10:22:10 AM org.jooq.tools.JooqLogger error
> SEVERE: Error while fetching functions
> org.jooq.exception.DataAccessException: SQL [select
> "SYS"."ALL_OBJECTS"."OWNER",
> "SYS"."ALL_OBJECTS"."OBJECT_NAME", "SYS"."ALL_OBJECTS"."OBJECT_ID",
> "SYS"."ALL_
> PROCEDURES"."AGGREGATE" from "SYS"."ALL_OBJECTS" left outer join
> "SYS"."ALL_PROC
> EDURES" on ("SYS"."ALL_OBJECTS"."OWNER" = "SYS"."ALL_PROCEDURES"."OWNER"
> and "SY
> S"."ALL_OBJECTS"."OBJECT_TYPE" = "SYS"."ALL_PROCEDURES"."OBJECT_TYPE" and
> "SYS".
> "ALL_OBJECTS"."OBJECT_NAME" = "SYS"."ALL_PROCEDURES"."OBJECT_NAME") where
> (upper
> ("SYS"."ALL_OBJECTS"."OWNER") in (?, ?) and
> "SYS"."ALL_OBJECTS"."OBJECT_TYPE" in
> (?, ?)) order by "SYS"."ALL_OBJECTS"."OWNER" asc,
> "SYS"."ALL_OBJECTS"."OBJECT_N
> AME" asc, "SYS"."ALL_OBJECTS"."OBJECT_ID" asc]; *ORA-00904:
> "SYS"."ALL_PROCEDURES
> "."OBJECT_TYPE" : identificateur non valide*
> at org.jooq.impl.Utils.translate(Utils.java:1021)
> at
> org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContex
> t.java:462)
> at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:287)
> at
> org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:309)
> at org.jooq.impl.SelectImpl.fetch(SelectImpl.java:953)
> at
> org.jooq.util.oracle.OracleDatabase.getRoutines0(OracleDatabase.java:
> 347)
> at
> org.jooq.util.AbstractDatabase.getRoutines(AbstractDatabase.java:605)
> at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:237)
> at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:170)
> at org.jooq.util.GenerationTool.run(GenerationTool.java:291)
> at org.jooq.util.GenerationTool.main(GenerationTool.java:135)
> at org.jooq.util.GenerationTool.main(GenerationTool.java:122)
> Caused by: java.sql.SQLException: ORA-00904:
> "SYS"."ALL_PROCEDURES"."OBJECT_TYPE
> " : identificateur non valide
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590)
> at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973)
> at
> oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:
> 850)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav
> a:2599)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
> nt.java:2963)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
> edStatement.java:658)
> at
> oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStat
> ement.java:736)
> at
> org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedS
> tatement.java:189)
> at
> org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:23
> 1)
> at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:283)
>
> ************************************************************************************************
>
> The Oracle database has the following version :
> *Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bit
> Production *
> *With the Partitioning, OLAP and Data Mining options*
>
> I checked that the view sys.all_procedures has really no column
> "OBJECT_TYPE".
>
> Here is the structure of *SYS.ALL_PROCEDURES* :
>
> *OWNER* VARCHAR2 30 Not Null
> *OBJECT_NAME* VARCHAR2 30 Not Null
> *PROCEDURE_NAME* VARCHAR2 30
> *AGGREGATE* VARCHAR2 3
> *PIPELINED* VARCHAR2 3
> *IMPLTYPEOWNER* VARCHAR2 30
> *IMPLTYPENAME* VARCHAR2 30
> *PARALLEL* VARCHAR2 3
> *INTERFACE* VARCHAR2 3
> *DETERMINISTIC* VARCHAR2 3
> *AUTHID* VARCHAR2 12
>
> Thanx for help and best regards
>
> Philippe Colin
>
>
--
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.
