well, that's what I mean i only make a request for getMetaData stmnt = conn.createStatement rs = stmnt.executeQuery 'select * from my_foreign_table' meta = rs.getMetaData
On Tue, Jul 21, 2020 at 10:42 AM Jeremy Evans <[email protected]> wrote: > On Tuesday, July 21, 2020 at 6:40:00 AM UTC-7, Charles Monteiro wrote: >> >> 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. >> > > Sequel uses getMetaData.getColumns on the JDBC connection object: > https://github.com/jeremyevans/sequel/blob/master/lib/sequel/adapters/jdbc.rb#L644 > > If you can provide the JDBC code that returns the schema information for > the linked table, I can probably get this working in Sequel. However, > without that, there isn't much I can do. > > 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/e6bad712-d50f-40c2-b049-d49c666907c6o%40googlegroups.com > <https://groups.google.com/d/msgid/sequel-talk/e6bad712-d50f-40c2-b049-d49c666907c6o%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/CANzC3aQX8r-u1bjeXOzsCRYwm%2B8ebDw6yhwMHq3pJcz_F5a81w%40mail.gmail.com.
