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 at
http://groups.google.com/group/sequel-talk?hl=en.
