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 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/9aaeb0f1-72b6-40b4-ba05-340afccc1cf2o%40googlegroups.com.
