btw, I can also confirm that if log into that foreign table I can successfully use the #schema call successfully
On Mon, Jul 20, 2020 at 3:37 PM Charles Monteiro <[email protected]> wrote: > confused, and sorry, yes we are calling Sequel::schema from Jruby, I also > figured as much that the JDBC metadata support is being used, just don't > understand why in the case of Oracle its failing to pick up on linked tables > > On Monday, July 20, 2020 at 11:23:50 AM UTC-4, Jeremy Evans wrote: >> >> On Monday, July 20, 2020 at 8:12:17 AM UTC-7, Charles Monteiro wrote: >>> >>> this is all we do to setup the database link >>> >>> CREATE PUBLIC DATABASE LINK foreign_DB1 >>> CONNECT TO foreignOwner IDENTIFIED BY foreignOwner USING 'foreign_DB!'; >>> >>> CREATE PUBLIC SYNONYM foreign_table1 FOR foreign_table1@foreignOwner; >>> >>> thanks for looking into this >>> >> >> I looked more into this. The oracle adapter does not use SQL to get the >> schema, it uses OCI8#describe_table (which comes from ruby-oci8) to get the >> schema. So if you want this supported in the oracle adapter, you need to >> get ruby-oci8 to add support for this. If you are using the jdbc/oracle >> adapter, Sequel uses the JDBC metadata support. >> >> Thanks, >> Jeremy >> > -- > You received this message because you are subscribed to a topic in the > Google Groups "sequel-talk" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/sequel-talk/_DTN8mDkrkk/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sequel-talk/9aaeb0f1-72b6-40b4-ba05-340afccc1cf2o%40googlegroups.com > <https://groups.google.com/d/msgid/sequel-talk/9aaeb0f1-72b6-40b4-ba05-340afccc1cf2o%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Charles A. Monteiro www.monteirosfusion.com sent from the road -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sequel-talk/CANzC3aQDkgjS9pYHYJytn%2BW-akCr__K%3D1cZ%2BTPiBoiBrEZikEw%40mail.gmail.com.
