Bugs item #16789, was opened at 2008-01-03 07:51
You can respond by visiting:
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=16789&group_id=2014
Category: AR-JDBC
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: activerecord-jdbc-adapter-0.7 oracle issue
Initial Comment:
upgrading from activerecord-jdbc-adapter-0.6 to 0.7 has created the following
issue under oracle 10g when trying to insert a simple record into a table :
NFO | jvm 1 | 2008/01/03 13:39:02 | 13:39:01.924 INFO rails.sonar - Migrating
to PopulateDatabase (3)
INFO | jvm 1 | 2008/01/03 13:39:02 | == PopulateDatabase: migrating
================================================
INFO | jvm 1 | 2008/01/03 13:39:03 | 13:39:03.252 ERROR rails.sonar -
INFO | jvm 1 | 2008/01/03 13:39:03 |
INFO | jvm 1 | 2008/01/03 13:39:03 | ActiveRecord::StatementInvalid
(ActiveRecord::ActiveRecordError: Invalid column index: INSERT INTO metrics
(name, description, direction, value_type) VALUES('cobertura_line_rate', 'Line
Rate Coverage', 1, 6)):
INFO | jvm 1 | 2008/01/03 13:39:03 |
E:/server/sonar-dev/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/transactions.rb:101:in
`transaction'
INFO | jvm 1 | 2008/01/03 13:39:03 |
E:/server/sonar-dev/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/transactions.rb:121:in
`transaction'
INFO | jvm 1 | 2008/01/03 13:39:03 |
E:/server/sonar-dev/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/transactions.rb:129:in
`save_with_transactions'
INFO | jvm 1 | 2008/01/03 13:39:03 |
E:/server/sonar-dev/lib/sonar-web/WEB-INF/gems/gems/activerecord-1.15.6/lib/active_record/base.rb:451:in
`create'
INFO | jvm 1 | 2008/01/03 13:39:03 |
E:/server/sonar-dev/lib/sonar-web/app/controllers/../../db/migrate/003_populate_database.rb:631:in
`insert_metric'
INFO | jvm 1 | 2008/01/03 13:39:03 |
E:/server/sonar-dev/lib/sonar-web/app/controllers/../../db/migrate/003_populate_database.rb:553:in
`insert_metrics'
INFO | jvm 1 | 2008/01/03 13:39:03 |
E:/server/sonar-dev/lib/sonar-web/app/controllers/../../db/migrate/003_populate_database.rb:22:in
`up'
everything worked fine with the 0.6 release.
AR code creating the table :
create_table :metrics do |t|
t.column :name, :string, :null => false, :limit => 64
t.column :value_type, :integer, :null => false
t.column :description, :string, :null => true
t.column :direction, :integer, :null => false, :default => 0
end
AR call to insert the record :
Metric.create(:name => name,
:description => description,
:value_type => value_type,
:direction => direction)
The oracle sequence is correctly created (checked on the oracle server)
----------------------------------------------------------------------
>Comment By: Nick Sieger (nicksieger)
Date: 2008-01-03 22:29
Message:
Sorry about the regression. Can you try to work up a small testcase, attach it
to JRuby's JIRA at http://jira.codehaus.org/browse/JRUBY, and send an email to
the mailing list?
I myself don't have access to Oracle, but hopefully someone else who does can
confirm the behavior.
----------------------------------------------------------------------
You can respond by visiting:
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=16789&group_id=2014
_______________________________________________
Jruby-extras-devel mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/jruby-extras-devel
