Hello, Thank you for your patience. I've realised that we had overlooked cross schema type references of OBJECT types in the past, focusing only on cross schema type references in procedures (e.g. procedure in schema A, return type in schema B)
This is now fixed as issue #4347. The fix will ship this week in jOOQ 3.6.2 https://github.com/jOOQ/jOOQ/issues/4347 Thank you very much for reporting this issue! Best Regards, Lukas 2015-05-29 13:21 GMT+02:00 <[email protected]>: > The issue is mainly between the notes schema and the policy_management > schema: > > <?xml version="1.0" encoding="UTF-8" standalone="yes"?> > <configuration> > <jdbc> > <driver>oracle.jdbc.OracleDriver</driver> > <url>jdbc:oracle:thin:@xxxxxxxxxxxxx:1521:XXXX</url> > <user>xxxxxxxxx</user> > <password>xxxxxxxx</password> > > > <generator> > <database> > > <schemata> > <schema> > <inputSchema>SHARED</inputSchema> > </schema> > <schema> > <inputSchema>NOTES</inputSchema> > </schema> > <schema> > <inputSchema>CLAIMS</inputSchema> > </schema> > <schema> > <inputSchema>REMINDERS</inputSchema> > </schema> > <schema> > <inputSchema>POLICY_MANAGEMENT</inputSchema> > </schema> > <schema> > <inputSchema>USER_INTERFACE</inputSchema> > </schema> > </schemata> > </database> > > <target> > <packageName>uk.co.xxxxxxxxxxxxxxx.jooq</packageName> > > <!-- The destination directory of your generated classes --> > <directory>C:/Git/UI/src/main/java</directory> > </target> > </generator> > </configuration> > > > On Friday, 29 May 2015 12:17:26 UTC+1, Lukas Eder wrote: >> >> Thanks for the additional info. >> >> Interesting, that shouldn't be the case. How are you generating the code? >> Are you using two code generation runs, one for each schema (which would >> produce this behaviour), or are you including both schemas in a single code >> generation run? Could you provide us with the code generation config XML >> that you were using? >> >> Best Regards, >> Lukas >> >> >> 2015-05-29 13:12 GMT+02:00 <[email protected]>: >> >>> I did... what I meant to say was: >>> >>> I'm have some issues the way that jooq is dealing with UDTs from and >>> oracle database. >>> >>> Oracle version 11.2.0.3 >>> jooq version 3.6.1 >>> >>> If I define a table UDT as below: >>> >>> create or replace type notes.t_notes as table of r_note >>> >>> >>> And then reference that table type in a UDT in a different schema >>> (having granted execute with grant option on the type to said schema) as >>> below: >>> >>> create or replace type policy.r_policy as object >>> (field1 varchar2(100), >>> notes notes.t_notes) >>> >>> When I run jooq codegen, asking it to look at the UDTs from both >>> schemas, it pulls through all the UDTs and generated the java classes for >>> them but where a UDT references a UDT from another schema if maps to Object: >>> >>> public static final UDTField<RPolicyRecord, Object> POLICY_NOTES = >>> createField("POLICY_NOTES", >>> org.jooq.impl.DefaultDataType.getDefaultDataType("T_NOTES"), R_POLICY, ""); >>> >>> >>> Any help would be much appreciated >>> >>> On Friday, 29 May 2015 12:07:31 UTC+1, Lukas Eder wrote: >>>> >>>> Hello, >>>> >>>> Thanks for your enquiry... Did you perhaps send the E-Mail too early? :) >>>> >>>> Cheers, >>>> Lukas >>>> >>>> 2015-05-29 13:02 GMT+02:00 <[email protected]>: >>>> >>>>> I'm have some issues the way that jooq is dealing with UDTs from and >>>>> oracle database. >>>>> >>>>> Oracle version 11.2.0.3 >>>>> jooq version 3.6.1 >>>>> >>>>> If I define a table UDT as below: >>>>> >>>>> create or replace type schema.tableTypeName as table of objectTypeName >>>>> >>>>> >>>>> And then reference that table type in a UDT in a different schema >>>>> (having granted execute with grant option on the type to said schema) as >>>>> below: >>>>> >>>>> create or replace type differentSchema.differentOjectTypeName as object >>>>> (field 1number(10,2), >>>>> periodic_premium number(10,2)) >>>>> >>>>> >>>>> -- >>>>> 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/d/optout. >>>>> >>>> >>>> -- >>> 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/d/optout. >>> >> >> -- > 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/d/optout. > -- 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/d/optout.
