Rails - Mar 2005 - Problem with Rails and OCI8

Using Rails 0.10.1 , following error when I have OCI8 (ver 1.9)
installed .. Older rails (0.9) did not have this problem, AFAIK.
Uninstalling OCI8 from site_ruby makes the problem go away.

Ideas? Thanks. 

/usr/lib/ruby/gems/1.8/gems/activerecord-1.8.0/lib/active_record/connection_adapters/oci_adapter.rb:253:
undefined method `define_a_column'' for class `OCI8::Cursor''
(NameError)
        from /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in
`require__''
        from /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in
`require''
        from
/usr/lib/ruby/gems/1.8/gems/activesupport-1.0.1/lib/active_support/dependencies.rb:197:in
`require''
        from
/usr/lib/ruby/gems/1.8/gems/activerecord-1.8.0/lib/active_record.rb:67
        from /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in
`require__''
        from /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in
`require''
        from /usr/lib/ruby/site_ruby/1.8/rubygems.rb:164:in `activate''
        from /usr/lib/ruby/site_ruby/1.8/rubygems.rb:38:in
`require_gem_with_options''
        from /usr/lib/ruby/site_ruby/1.8/rubygems.rb:32:in
`require_gem''
        from ./script/../config/environment.rb:28
        from ./script/server:46:in `require''
        from ./script/server:46

Hello,
I''m receiving the same problem as Avik was having with Rails and OCI8.
His solution was to remove oci8 from site_ruby - I can''t do that
because
I actually want to use the oracle adapter.

I''m getting the error:

/usr/lib/ruby/gems/1.8/gems/activerecord-1.9.1/lib/active_record/connect
ion_adapters/oci_adapter.rb:252:
undefined method `define_a_column'' for class `OCI8::Cursor''
(NameError)
from /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in
`require__''
from /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in
`require''
from
/usr/lib/ruby/gems/1.8/gems/activesupport-1.0.1/lib/active_support/depen
dencies.rb:197:in
`require''
... 

It''s failing when it tries to alias the method
"define_a_column" so that
it can override some behavior in that method. Has anyone got a real fix
for this? 

I took a look at oci8.rb and the method is defined for OCI8::Cursor, so
I''m not sure why Ruby is complaining.

Thanks,
Chris

I hate to keep responding to my own threads :)

Especially since it usually meant I didn''t try to find the answer hard
enough on my own.

In the interest of info-sharing, this problem was occurring because the
oci8 library was failing to properly load the oci8lib.so native
extensions on my machine (but not letting me know this).

The real underlying problem was that the ci8 native driver doesn''t work
correctly unless you have set up your ORACLE_HOME, ORACLE_SID and
LD_LIBRARY_PATH environment variables. I did this manually to compile
it, then when I rebooted the driver mysteriously stopped working and was
manifesting itself by: 

Throwing the error and stacktrace seen below, and making it seem like
httpd was down since every request from users was timing out (Because
FastCGI doesn''t like it when you have uncaught exceptions popping up
recursively).

Thanks,
Chris
> -----Original Message-----
> From: rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
[mailto:rails-
> bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org] On Behalf Of
Williams, Chris
> Sent: Monday, April 04, 2005 11:46 AM
> To: avik-1oDqGaOF3Lkdnm+yROfE0A@public.gmane.org;
rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
> Subject: Re: [Rails] Problem with Rails and OCI8
> 
> Hello,
> I''m receiving the same problem as Avik was having with Rails and
OCI8.
> His solution was to remove oci8 from site_ruby - I can''t do that
because
> I actually want to use the oracle adapter.
> 
> I''m getting the error:
> 
>
/usr/lib/ruby/gems/1.8/gems/activerecord-1.9.1/lib/active_record/connect
> ion_adapters/oci_adapter.rb:252:
> undefined method `define_a_column'' for class
`OCI8::Cursor''
> (NameError)
> from /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in
> `require__''
> from /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in
> `require''
> from
>
/usr/lib/ruby/gems/1.8/gems/activesupport-1.0.1/lib/active_support/depen
> dencies.rb:197:in
> `require''
> ...
> 
> It''s failing when it tries to alias the method
"define_a_column" so
that
> it can override some behavior in that method. Has anyone got a real
fix
> for this?
> 
> I took a look at oci8.rb and the method is defined for OCI8::Cursor,
so
> I''m not sure why Ruby is complaining.
> 
> Thanks,
> Chris
> _______________________________________________
> Rails mailing list
> Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
> http://lists.rubyonrails.org/mailman/listinfo/rails