Hi Stan, I have thought about that in the past, but interestingly, there isn't any feature request on the road map yet! I've added one: https://github.com/jOOQ/jOOQ/issues/4222
In the mean time, you can easily work around this limitation: 1. Run the code generator directly on the linked database 2. Configure the code generator's schema mapping to generate the DB link name, i.e. TABLE_NAME -> TABLE_NAME@DBLINK ( http://www.jooq.org/doc/latest/manual/code-generation/schema-mapping/) 3. Probably use Settings and RenderNameStyle.AS_IS to remove quotes in order to have the correct syntax (i.e. OWNER.TABLE_NAME@DBLINK instead of "OWNER"."TABLE_NAME@DBLINK") Alternative workaround: 1. Run the code generator directly on the linked database 2. Create synonyms for every linked table, containing the DB link I think that both of the above workarounds will work also with jOOQ 3.2 Hope this helps, Lukas 2015-04-22 15:19 GMT+02:00 Stanislas Nanchen <[email protected]>: > Hi everyone! > > I'm using jooq 3.2 with Oracle 11g and would like to select over a > database link. Something like: > > select * > from T@db_link > where ... > > How can one do that in Jooq? > Thank you for your help! > > Stan. > > -- > 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.
