the interesting thing is that I can actually do a jdbc select without specifying a qualified path i.e. as simple as "select * from my_foreign_table"
will retrieve the data and of course the available meta needed to do the type conversions of the result set record elements so indeed just doing getMetaData to the returned result set i.e. as you point out above, How does sequel go about it ? Does it actually issue a "minimal" query and then retrieve the meta from the result set i.e. if it does then I don't understand why it does not work, so I'm guessing there's another mechanism? BTW, I'm on sequel-5.23.0 in case that makes a diff. thanks again On Mon, Jul 20, 2020 at 4:44 PM Jeremy Evans <[email protected]> wrote: > On Monday, July 20, 2020 at 12:37:48 PM UTC-7, Charles Monteiro 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 >> > > This could be an issue with Oracle's JDBC driver. Sequel just uses > getMetaData.getColumns and similar methods in the JDBC driver. If those > don't return the correct values, there's not much Sequel can do about it. > > Possibly, you need to specify the catalog argument when loading the > metadata? Sequel currently always uses nil for the catalog argument. If > you can show working JDBC code for getting the metadata for the linked > table, I may be able to make the appropriate changes to Sequel. > > 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/d8282f01-0a0b-4eda-b831-6c09d3b113a5o%40googlegroups.com > <https://groups.google.com/d/msgid/sequel-talk/d8282f01-0a0b-4eda-b831-6c09d3b113a5o%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/CANzC3aSe%3DcSx7Ar7SRp9efvxRJYom595tT2eDyHisdi4x4wn_w%40mail.gmail.com.
