# Problem with set\_sequence\_name please help

**URL:** <https://www.ruby-forum.com/t/problem-with-set-sequence-name-please-help/195665>\
**Category:** Rails\
**Created:** [September 27, 2010, 9:39pm UTC](https://www.ruby-forum.com/t/problem-with-set-sequence-name-please-help/195665 "2010-09-27T21:39:49Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![cyberjom](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/a183cd/32.png) [@cyberjom](https://www.ruby-forum.com/u/cyberjom)\
**Post date:** [September 27, 2010, 9:39pm UTC](https://www.ruby-forum.com/t/problem-with-set-sequence-name-please-help/195665/1 "2010-09-27T21:39:49Z")

</div>

I’m building rails 3 with legacy oracle 10g db. which it’s sequence is  
non rails convension.

I have try this.

class AdCourt \< ActiveRecord::Base  
set\_sequence\_name ‘COURT\_SEQ’  
end

with rails console :

AdCourt.sequence\_name I have got “COURT\_SEQ” which look ok.

When

AdCourt.create!(:caption =\> ‘AAAA’, :code =\> ‘1111’, :version =\> 0,  
:created\_by\_id =\> 0)

it’s still using “ad\_courts\_seq” which not exist.

ActiveRecord::StatementInvalid: ActiveRecord::ActiveRecordError:  
ORA-02289: sequence does not exist  
: select ad\_courts\_seq.nextval id from dual  
from  
/Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activerecord-3.0.0/lib/active\_record/connection\_adapters/abstract\_adapter.rb:202:in  
`log' from /Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activerecord-jdbc-adapter-0.9.7-java/lib/active_record/connection_adapters/jdbc_adapter.rb:582:in`execute’  
from  
/Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activerecord-jdbc-adapter-0.9.7-java/lib/jdbc\_adapter/jdbc\_oracle.rb:390:in  
`select' from /Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activerecord-jdbc-adapter-0.9.7-java/lib/active_record/connection_adapters/jdbc_adapter.rb:578:in`select\_one’  
from  
/Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activerecord-jdbc-adapter-0.9.7-java/lib/jdbc\_adapter/jdbc\_oracle.rb:163:in  
`insert' from /Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/arel-1.0.1/lib/arel/engines/sql/engine.rb:30:in`create’  
from  
/Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/arel-1.0.1/lib/arel/algebra/relations/writes.rb:24:in  
`call' from /Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/arel-1.0.1/lib/arel/session.rb:17:in`create’  
from  
/Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/arel-1.0.1/lib/arel/algebra/relations/relation.rb:159:in  
`insert' from /Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activerecord-3.0.0/lib/active_record/relation.rb:14:in`insert’  
from  
/Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activerecord-3.0.0/lib/active\_record/persistence.rb:271:in  
`create' from /Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activerecord-3.0.0/lib/active_record/timestamp.rb:47:in`create’  
from  
/Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activerecord-3.0.0/lib/active\_record/callbacks.rb:281:in  
`create' from /Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activesupport-3.0.0/lib/active_support/callbacks.rb:428:in`\_run\_create\_callbacks’  
from  
/Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activerecord-3.0.0/lib/active\_record/callbacks.rb:281:in  
`create' from /Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activerecord-3.0.0/lib/active_record/persistence.rb:247:in`create\_or\_update’  
from  
/Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activerecord-3.0.0/lib/active\_record/callbacks.rb:277:in  
`create_or_update' from /Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activesupport-3.0.0/lib/active_support/callbacks.rb:428:in`\_run\_save\_callbacks’  
from  
/Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activerecord-3.0.0/lib/active\_record/callbacks.rb:277:in  
`create_or_update' from /Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activerecord-3.0.0/lib/active_record/persistence.rb:56:in`save!’  
from  
/Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activerecord-3.0.0/lib/active\_record/validations.rb:49:in  
`save!' from /Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activerecord-3.0.0/lib/active_record/attribute_methods/dirty.rb:30:in`save!’  
from  
/Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activerecord-3.0.0/lib/active\_record/transactions.rb:242:in  
`save!' from /Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activerecord-3.0.0/lib/active_record/transactions.rb:289:in`with\_transaction\_returning\_status’  
from  
/Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activerecord-3.0.0/lib/active\_record/connection\_adapters/abstract/database\_statements.rb:139:in  
`transaction' from /Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activerecord-3.0.0/lib/active_record/transactions.rb:204:in`transaction’  
from  
/Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activerecord-3.0.0/lib/active\_record/transactions.rb:287:in  
`with_transaction_returning_status' from /Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activerecord-3.0.0/lib/active_record/transactions.rb:242:in`save!’  
from  
/Users/cyberjom/.rvm/gems/jruby-1.5.2/gems/activerecord-3.0.0/lib/active\_record/validations.rb:34:in  
`create!’