Need help with oracle adapter

Hi all,
I have been struggling with this problem for a while.
I cannot insert into a table (simple action) with auto-increment
mechanism.

I have got:
rvm with ruby 1.8.7
gem -v is: 1.6.2
rails -v is" 3.0.5
ruby-oci8 1.0.6
activerecord-oracle-adapter, not the enhanced one,
the version I used is 1.0.0.9250.

all above versions are required.

I created a table " programs" with primary key id.
I also created a sequence for auto-increment. : programs_seq
I also created a trigger before insert into that table:
programs_trigger

The table name is programs, therefore, the model name is program

class Program < ActiveRecord::Base
set_primary_key “id”
set_sequence_name “programs_seq”
end

when i try to insert into that table via sqlplus is works, but when I
use rails console I could not, it gives me along errors or exceptions
with primary key,

First part of the errors:
NoMethodError: undefined method `primary_key’ for
#ActiveRecord::ConnectionAdapters::OracleAdapter:0xb728b434

It is very long message, sorry about that.

Please help, I searched for a solution but with no luck.
any help will be appreciated.

Cheers,
Faisal

On 9 Apr 2011, at 03:11, fAisAl [email protected] wrote:

activerecord-oracle-adapter, not the enhanced one,
the version I used is 1.0.0.9250.

Have you tried the enhanced one? I seem to recall that is the actively
maintained one.

Fred

Thank you Fred,
Yes I could have used that, but as a requirement from host, I must use
the old adapter not the enhanced one.

Cheers,
Faisal

On Apr 9, 3:13pm, Frederick C. [email protected]

On 9 Apr 2011, at 07:19, fAisAl [email protected] wrote:

Thank you Fred,
Yes I could have used that, but as a requirement from host, I must use
the old adapter not the enhanced one.

You’ll probably need to use an older version of rails (ie 2.x) then

Fred

On Sat, Apr 9, 2011 at 2:07 AM, fAisAl [email protected] wrote:

Thank you Fred for your suggestion. I might leave that at end when no
other available solutions.

activerecord-oracle-adapter’s last official version of Rails it worked
with
was Rails 2 (2.1 if I recall correctly). It was replaced years ago
by activerecord-oracle_enhanced-adapter which works with Rails 2.3.* and
Rails 3. If you wish to use the older adapter you are going to have to
use
an earlier version of Rails 2. I would suggest you tell your host to get
with the times and install activerecord-oracle_enhanced-adapter. If they
refuse then you are stuck with having to use an older version of Rails
2. At
that point I would seriously consider switching hosting providers.

B.

Thank you Fred for your suggestion. I might leave that at end when no
other available solutions.

Faisal

On Apr 9, 3:44pm, Frederick C. [email protected]

Thank you for you help Bryan, I am very satisfied by our answer.
I will try to tell my host that to upgrade their environment.

Thank for all who tried to help and also thanks for Fred for early
answer.

Cheers all,
Faisal

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs