Thanks, Jeremy. Somehow I overlooked the connection string difference between plain Postgres and JDBC Postgres. And ActiveRecord was a complete red herring.
-Grant On Apr 28, 1:45 pm, Jeremy Evans <[email protected]> wrote: > On Apr 28, 8:39 am, GrantB <[email protected]> wrote: > > > I'm new to Sequel, and I'm having trouble connecting to my Postgres > > DB. > > > As I understand it, I can't use the ruby-pg gem because it's not JDBC- > > friendly. Some searching has pointed me to activerecord- > > jdbcpostgresql-adapter gem. > > As you are using Sequel and not ActiveRecord, that's not the gem you > want. You want the jdbc-postgres gem. > > > Having installed that, I'm getting an odd exception that I don't > > entirely understand. Is it telling me that it can't find some Sequel > > module? > > > (I hope this paste stays formatted okay) > > 692 ~/dev/jestrunner/trunk$ jirb > > irb(main):001:0> require "rubygems" > > require "seq=> true > > irb(main):002:0> require "sequel" > > => true > > irb(main):003:0> Sequel.connect('postgres:// > > postgres:postg...@localhost:5432/jestrunner_at_db') > > NameError: uninitialized constant Sequel::Postgres::PGError > > This connection string isn't correct. If you want to use jdbc, you > have to provide a jdbc connection string, which will start with > jdbc:postgresql. See the PostgreSQL JDBC driver documentation. > > You do have a another option. There is a pure ruby postgresql driver > called postgres-pr. So gem install postgres-pr (or jeremyevans- > postgres-pr for my fork). That should work with the connection string > you already have. > > Jeremy > > -- > You received this message because you are subscribed to the Google Groups > "sequel-talk" group. > 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 > athttp://groups.google.com/group/sequel-talk?hl=en. -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. 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.
