Hi Philippe, 2013/5/7 Philippe Colin <[email protected]>
> Lukas, thanks for your quick reply. > I just need tables and fields in my use-case. > I will try this afternoon the workaround of JDBCDatabase and stay you > informed. > And the next workaround for me is to not use codegen at all and to use > plain text queries with jOOQ, which is not a real problem for my needs (for > now, I always used "traditionnal" jdbc programmation). > Even in this case, I think that it will be easier for me to do my job with > jOOQ than without. > If your database schema is static, it would be a shame not to be able to leverage the code generator. We'll certainly find a solution to this problem. Concerning the OBJECT_TYPE field, I think that prior to version 10.2, one > could'nt have a function and a procedure with the same name ... > Interesting. Can you confirm this? > For some ideas of rewriting, I can imagine some ways. > I have to think about that before telling it back to you. > > Best regards > > Philippe Colin > > P.S. : this week-end, I had a little walk through the doc and code of > jOOQ. I think it is well thought, well designed and well implemented. > I dreamed for something like that for many years, and one's done it :D > Like we say in France "Chapeau bas" et "Bravo !" > Ben, nickel, comme on dirait on Suisse ;-) A response to your other mail will follow... Cheers Lukas > Le mardi 7 mai 2013 12:38:28 UTC+2, Lukas Eder a écrit : > >> >> >> >> 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<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.**DataAccessE**xception: SQL [select >>>> "SYS"."ALL_OBJECTS"."OWNER", >>>> "SYS"."ALL_OBJECTS"."OBJECT_**N**AME", "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_ >>>> **TY**PE" 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.**DefaultExecuteCo**ntext.**sqlException(** >>>> DefaultExec**uteContex >>>> t.java:462) >>>> at org.jooq.impl.AbstractQuery.**ex**ecute(AbstractQuery.java:* >>>> *287) >>>> at org.jooq.impl.**AbstractResultQu**ery.fetch(** >>>> AbstractResultQuery.**java:309) >>>> at org.jooq.impl.SelectImpl.**fetch**(SelectImpl.java:953) >>>> at org.jooq.util.oracle.**OracleDat**abase.getRoutines0(** >>>> OracleDatab**ase.java: >>>> 347) >>>> at org.jooq.util.**AbstractDatabase**.getRoutines(** >>>> AbstractDatabase.**java:605) >>>> at org.jooq.util.JavaGenerator.**ge**nerate(JavaGenerator.java: >>>> **237) >>>> at org.jooq.util.JavaGenerator.**ge**nerate(JavaGenerator.java: >>>> **170) >>>> at org.jooq.util.GenerationTool.**r** >>>> un(GenerationTool.java:291) >>>> at org.jooq.util.GenerationTool.**m** >>>> ain(GenerationTool.java:135) >>>> at org.jooq.util.GenerationTool.**m** >>>> ain(GenerationTool.java:122) >>>> Caused by: java.sql.SQLException: ORA-00904: "SYS"."ALL_PROCEDURES"."** >>>> OBJECT**_TYPE >>>> " : identificateur non valide >>>> at oracle.jdbc.dbaccess.DBError.**t**hrowSqlException(DBError.* >>>> *java:**134) >>>> at oracle.jdbc.ttc7.TTIoer.**proces**sError(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(** >>>> TTC7Proto**col.java: >>>> 850) >>>> at oracle.jdbc.driver.**OracleState**ment.**doExecuteQuery(** >>>> OracleStat**ement.jav >>>> a:2599) >>>> at oracle.jdbc.driver.**OracleState**ment.** >>>> doExecuteWithTimeout(**Orac**leStateme >>>> nt.java:2963) >>>> at oracle.jdbc.driver.**OraclePrepa**redStatement.** >>>> executeUpdate(**OraclePrepar >>>> edStatement.java:658) >>>> at oracle.jdbc.driver.**OraclePrepa**redStatement.**execute(** >>>> OraclePreparedStat >>>> ement.java:736) >>>> at org.jooq.tools.jdbc.**DefaultPre**paredStatement.**execute(* >>>> *DefaultPreparedS >>>> tatement.java:189) >>>> at org.jooq.impl.**AbstractResultQu**ery.execute(** >>>> AbstractResultQuer**y.java:23 >>>> 1) >>>> at org.jooq.impl.AbstractQuery.**ex**ecute(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 jooq-user+...@**googlegroups.com. >>> >>> For more options, visit >>> https://groups.google.com/**groups/opt_out<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. > > > -- 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.
