2013/5/7 Philippe Colin <[email protected]> > 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 ...) > ... >
That's bad news. The earliest Oracle version that was used to integration test jOOQ was 10.2. Nonetheless, if this is the only failing query form jOOQ-meta, maybe it can be re-written. Any ideas with respect to rewriting it to something equivalent? Another option for you might be to try using jOOQ with the org.jooq.util.JDBCDatabase: https://github.com/jOOQ/jOOQ/blob/master/jOOQ-meta/src/main/java/org/jooq/util/jdbc/JDBCDatabase.java This is currently undocumented, and doesn't support stored procedures. But it might be sufficient for your use-cases. Let me know if this works. Cheers Lukas > 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. > > > -- 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.
