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 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/e6bad712-d50f-40c2-b049-d49c666907c6o%40googlegroups.com.
