This will be fixed in jOOQ 3.2: https://github.com/jOOQ/jOOQ/issues/2584
The problematic query could be fixed by joining on ALL_OBJECTS.OBJECT_ID = ALL_PROCEDURES.OBJECT_ID instead of using (OWNER, OBJECT_NAME, OBJECT_TYPE). The commit will be pushed in a larger push. Cheers Lukas 2013/7/2 Venkat Sadasivam <[email protected]> > I am good with Oracle 11g. > > > On Tuesday, 2 July 2013 08:56:51 UTC-4, Lukas Eder wrote: > >> I just checked, Oracle 10g downloads are no longer available to customers >> with no commercial Oracle product licenses (e.g. me): >> http://www.oracle.com/**technetwork/database/** >> enterprise-edition/downloads/**index.html<http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html> >> >> I'm afraid that I won't be able to easily integration-test jOOQ with >> Oracle 10g any further right now. Fixing this query may still be possible, >> but it's a bit of a "blind flight". >> I'm hoping to improve this situation in the near future. >> >> Cheers >> Lukas >> >> >> 2013/7/2 Lukas Eder <[email protected]> >> >>> >>> >>> >>> 2013/7/2 Venkat Sadasivam <[email protected]> >>> >>> Do you support Oracle 10g? >>> >>> >>> Yes, 10g should be supported by jOOQ, although I currently do not have >>> the infrastructure set up to integration test both 10g and 11g with jOOQ. >>> >>> >>>> 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 >>>> >>> >>> Thanks for reporting. It seems that this column was introduced in 10gR2: >>> https://forums.oracle.com/**thread/529899<https://forums.oracle.com/thread/529899> >>> >>> It wasn't available in 10gR1 yet. I have registered #2584 for this. >>> https://github.com/jOOQ/jOOQ/**issues/2584<https://github.com/jOOQ/jOOQ/issues/2584> >>> >>> The offending query is in org.jooq.util.oracle.** >>> OracleDatabase.getRoutines0(): >>> >>> for (Record record : create().select( >>> ALL_OBJECTS.OWNER, >>> ALL_OBJECTS.OBJECT_NAME, >>> ALL_OBJECTS.OBJECT_ID, >>> ALL_PROCEDURES.AGGREGATE) >>> .from(ALL_OBJECTS) >>> .leftOuterJoin(ALL_PROCEDURES) >>> .on(ALL_OBJECTS.OWNER.equal(**ALL_PROCEDURES.OWNER)) >>> .and(ALL_OBJECTS.OBJECT_TYPE.** >>> equal(ALL_PROCEDURES.OBJECT_**TYPE)) >>> .and(ALL_OBJECTS.OBJECT_NAME.** >>> equal(ALL_PROCEDURES.OBJECT_**NAME)) >>> .where(ALL_OBJECTS.OWNER.** >>> upper().in(getInputSchemata()) >>> >>> .and(ALL_OBJECTS.OBJECT_TYPE.**in<http://ALL_OBJECTS.OBJECT_TYPE.in>("FUNCTION", >>> "PROCEDURE"))) >>> .orderBy( >>> ALL_OBJECTS.OWNER, >>> ALL_OBJECTS.OBJECT_NAME, >>> ALL_OBJECTS.OBJECT_ID) >>> .fetch()) { ... >>> >>> I'm sure there's a way to express the same query without using >>> ALL_PROCEDURES.OBJECT_TYPE >>> >>> Cheers >>> Lukas >>> >> >> -- > 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.
