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!'' -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.