What steps will reproduce the problem?

1. install OCI8 (I'm using a Linux 2.6.27 kernel on Ubuntu)
2. define database URI as "oracle://#{DB_USER}:#{DB_PWD}@#{DB_HOST}:1521/#{DB_SCHEMA}"
3. Sequel::Model.db = Sequel.connect(DB_URI, :max_connections => 10)

What is the expected output? What do you see instead?

When calling MyModel.db_schema I expect to get a hash of {:column_name => column_schema_hash_with_information_in_it}, instead I get {:column_name => {}} (an empty hash for the column_schema).

What version of the product are you using? On what operating system?

0.9.0.4 on Linux, running Ruby 1.8.7 against Oracle 10.2.0

Please provide any additional information below.

This doesn't happen when using a JDBC connection and running the same version of Sinatra through JRuby. The steps are the same for JRuby except the URI for the database is in the form of "jdbc:oracle:thin:#{DB_USER}/#{DB_PWD}@{DB_HOST}:1521/#{DB_SCHEMA}".

Thanks for an otherwise great framework!

Oops... I didn't mean Sinatra, I meant Sequel. Also, the version information I gave was for Sinatra. The correct version information for Sequel is 2.10.0 on Linux, running Ruby 1.8.7 against Oracle 10.2.0

Sorry.

The Oracle adapter doesn't support getting the schema. As I don't have access to an Oracle database, this isn't something I can fix. The reason it works on JDBC is that the JDBC adapter uses the JDBC metadata methods to get the information (which aren't available in the Oracle adapter).

I'd be happy to accept a patch that adds support to the Oracle adapter for parsing the schema. If you are able to create a patch that works, please reopen this ticket and submit it. As a workaround, you can set the schema information manually using:

class MyModel < Sequel::Model @db_schema = {:column_name=>column_schema_hash_with_information_in_it} end

Thanks, I will work on doing this (if I can figure out how to get this information from Oracle). Is there a test suite to add to as well?

Not sure how to reopen this. So I forked your repository on GitHub, added the fix and test, and sent you a Pull Request.

Thanks for your help.

Thanks for the fix. I can't test it, but it looks good, so I merged it.

I will add some more tests to the spec/oracle_spec.rb to make sure that the writes behave properly. I'll send another pull request when I am done.

The tests for reading the schema passed. I will send that output as well.