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.
