Uploaded image for project: 'TorqueBox'
  1. TorqueBox
  2. TORQUE-762

oracle_enhanced errors with No suitable driver found for jdbc:oracle:thin

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 2.0.0
    • Fix Version/s: 2.0.2
    • Component/s: Rails
    • Labels:
      None
    • Environment:

      mac oxs 10.6.8; Java(TM) SE Runtime Environment (build 1.6.0_31-b04-413-10M3623)

    • Workaround:
      Workaround Exists
    • Workaround Description:
      Hide

      See https://gist.github.com/2471698 for a workaround until the issue gets fixed in oracle_enhanced adapter

      Show
      See https://gist.github.com/2471698 for a workaround until the issue gets fixed in oracle_enhanced adapter

      Description

      I got the following error when doing "torquebox run" locally:

      22:02:28,822 ERROR [org.torquebox.core.runtime] (Thread-99) Error during execution: ENV['RAILS_ROOT']=RACK_ROOT
      ENV['RAILS_ENV']=RACK_ENV
      require %q(org/torquebox/web/rails/boot)
      : org.jruby.exceptions.RaiseException: (NativeException) java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@server-name:1531:MYDEV
      at java.sql.DriverManager.getConnection(DriverManager.java:602) [classes.jar:1.6.0_31]
      at java.sql.DriverManager.getConnection(DriverManager.java:154) [classes.jar:1.6.0_31]

      22:02:28,827 ERROR [org.torquebox.core.runtime] (Thread-99) Failed to initialize runtime: : org.jruby.exceptions.RaiseException: (NativeException) java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@uppdev-db.oit.duke.edu:1627:UPPDEV
      at java.sql.DriverManager.getConnection(DriverManager.java:602) [classes.jar:1.6.0_31]
      at java.sql.DriverManager.getConnection(DriverManager.java:154) [classes.jar:1.6.0_31]

      I created a sample application here:

      https://github.com/outten45/torquebox-oracle-sample

      You will need to download and put the ojdbc6.jar into the lib directory. You will also need to create a database.yml with your settings from the database.yml.sample.

      If I run the application in webbrick (rails server) and trinidad (trinidad -p 8080), it works without a problem.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                benbrowning Benjamin Browning
                Reporter:
                outten45 Richard Outten
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: