JRuby - jdbc-postgres no suitable driver found for jdbc:postgresql when running from JAR

Question

I am getting a 'No suitable driver found' error when running my jar generated with warbler. However when I run it as ruby the code succeeds. The command to load the driver returns true, leading me to believe it can still load the driver while in the jar. However I am unable to figure out why DriverManager.get_connection is erroring with No driver found. Especially since when running from Ruby it succeeds.

Ruby function being called

def self.connect(opts)
    connection = nil
    begin
      driver = Jdbc::PostgreSQL.load_driver

      connection = DriverManager.get_connection("jdbc:postgresql://host:port/postgres", opts[:username], opts[:password])
      connection.auto_commit = false
    rescue
       puts $!, $@
       ... 
    end
    connection
  end

Running Ruby

Test Connection Succeeded

Running JAR

No suitable driver found for jdbc:postgresql://host:port/postgres java.sql.DriverManager.getConnection(DriverManager.java:602) java.sql.DriverManager.getConnection(DriverManager.java:185)

warbler.rb

Gems to include

config.gems += ["trollop", "builder", "jdbc-postgres"]

Ruby imports

require, java_import

# All support libraries required to be included
[
  'java',
  'ostruct',
  'trollop',
  'logger',
  'fileutils',
  'yaml',
  'jdbc/postgres'
].each do |require_name|
  require require_name
end


 # All java imported namespaces
    [
        'java.sql.DriverManager'
    ].each do |namespace|
      java_import namespace
    end

It seems like something is not making it into the JAR which is causing the failure. Any suggestions would be greatly appreciated.

zack · Accepted Answer · 2014-03-21 11:38:55Z

1

I got this working by removing the jdbc-postgres Gem, then specifically including the PostgreSQL JDBC JAR. I extracted the relative parts and left out the general error handling and functions.

require postgresql-9.3-1101.jdbc4.jar

Java::JavaClass.for_name "org.postgresql.Driver"
Java::JavaClass.for_name "java.util.Properties"

props = java.util.Properties.new
props.set_property :user, opts[:username]
props.set_property :password, opts[:password]

connection = org.postgresql.Driver.new.connect(get_jdbcurl(opts), props)

answered Mar 21, 2014 at 11:38

zack

113 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

kares · Accepted Answer · 2014-03-20 07:07:40Z

0

likely PostreSQL's driver class does not get initialized (it's on the CP but no one used it so far) ... thus doing something of a Java::JavaClass.for_name Jdbc::PostgreSQL.driver_name (before DriverManager.get_connection) will register it with the DriverManager

answered Mar 20, 2014 at 7:07

kares

7,2011 gold badge31 silver badges38 bronze badges

1 Comment

zack Over a year ago

Thanks, I added the initialize call, with no change and I ended up trying a bunch of calls to ensure the driver was being loaded. Everything ended up with the same exception when in the JAR. I ended up changing how I was using org.postgresql.Driver class to get it working.

Collectives™ on Stack Overflow

JRuby - jdbc-postgres no suitable driver found for jdbc:postgresql when running from JAR

Ruby function being called

Running Ruby

Running JAR

warbler.rb

Ruby imports

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Ruby function being called

Running Ruby

Running JAR

warbler.rb

Ruby imports

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related