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] <javascript:>>:
>
>> 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] <javascript:>.
>> 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.
