[Mongrel] oci8 problems

Andrew Stone stonelists at gmail.com
Wed Jan 24 23:09:43 EST 2007


I feel stupid having to ask this, but I haven't found an answer.  I
installed ruby-oci8 in order to load data from an oracle db into postgres
(part of a jsp to rails conversion).  In order to run my ruby script I know
I need to set ORACLE_HOME and LD_LIBRARY_PATH environment variables to get
it to work (and it does work).

I've tried setting ENV['ORACLE_HOME'] and ENV['LD_LIBRARY_PATH'] in
config/envrironment.rb (before the Rails::Initializer.run do |config|
line), but this doesn't fix the issue.  I don't know where to set it so
mongrel will pick it up.

By the way, I'm not even trying to use the oracle active record adapter with
rails.  I just have oci8 installed for the migration script.

Please help.

Thanks in advance,
andy


The error in full from mongrel.log:

/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.1/lib/active_record/connection_adapters/oracle_adapter.rb:536:
undefined method `define_a_column' for class `OCI8::Cursor' (NameError)
        from
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'
        from /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.0/lib/active_support/dependencies.rb:496:in
`require'
        from /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.0/lib/active_support/dependencies.rb:343:in
`new_constants_in'
        from /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.0/lib/active_support/dependencies.rb:496:in
`require'
        from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.1
/lib/active_record.rb:81
        from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.1
/lib/active_record.rb:80
        from
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'
        from /usr/local/lib/ruby/gems/1.8/gems/rails-1.2.1/lib/initializer.rb:162:in
`require_frameworks'
         ... 10 levels...
        from /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/bin/mongrel_rails:83:in
`run'
        from /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/command.rb:211:in
`run'
        from /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1
/bin/mongrel_rails:243
        from /usr/local/bin/mongrel_rails:16
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.1/lib/active_record/connection_adapters/oracle_adapter.rb:536:
undefined method `define_a_column' for class `OCI8::Cursor' (NameError)
        from
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'
        from /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.0/lib/active_support/dependencies.rb:496:in
`require'
        from /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.0/lib/active_support/dependencies.rb:343:in
`new_constants_in'
        from /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.0/lib/active_support/dependencies.rb:496:in
`require'
        from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.1
/lib/active_record.rb:81
        from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.1
/lib/active_record.rb:80
        from
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'
        from /usr/local/lib/ruby/gems/1.8/gems/rails-1.2.1/lib/initializer.rb:162:in
`require_frameworks'
         ... 10 levels...
        from /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/bin/mongrel_rails:83:in
`run'
        from /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/command.rb:211:in
`run'
        from /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1
/bin/mongrel_rails:243
        from /usr/local/bin/mongrel_rails:16
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://rubyforge.org/pipermail/mongrel-users/attachments/20070124/4863b632/attachment-0001.html 


More information about the Mongrel-users mailing list