On Thursday, March 15, 2012 4:58:01 PM UTC-7, Christian MICHON wrote: > > Hi, > > I've a db at work (Oracle 11g) which I can access using > jdbc:oracle:thin. I verified using the same jdbc driver and > dbvisualizer that I can connect to it and see some content in several > table schemas. > > Yet, when using sequel (the gem and the binary), I point to the > default schema of my oracle login, and I seem unable to set > default_schema on Sequel.connect(). My DB.tables remains empty []. >
Honestly, I don't know much about Oracle. I do test Sequel on Oracle on a regular basis, but the test suite doesn't do anything special related to schemas. How are you attempting to set your default schema? Is there specific SQL you need to send after connecting to set the default schema (the Database :after_connect option handles such cases)? You may want to add a database logger and look at the logged output to see what queries Sequel is sending to Oracle. That way, you aren't in the dark about what Sequel is attempting to do: require 'logger' DB.loggers << Logger.new($stdout) > 1/ how can I list using sequel the list of table schemas ? ie the > containers containing tables and views (these can be very specific and > not shared among oracle logins). I may have a wrong name issue, if I > could see all possible table schemas, this could help. > I'm not sure what the Oracle SQL syntax is to list schemas. Whatever it is, you would probably do DB['SQL Here'].all and the results should contain the information you are looking for. > 2/ how to set it properly ? are there other commands to use than > default_schema ? > > Thanks in advance. > Sorry I can't be more help. If anyone else is more knowledgeable about Oracle, please chime in. Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/sequel-talk/-/3cKfTPkefzoJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
