Fixture insert generation process, columns of Oracle datatype "DATE" have the
string "TIMESTAMP" prefixed before the value to be inserted
-----------------------------------------------------------------------------------------------------------------------------------------
Key: JRUBY-2961
URL: http://jira.codehaus.org/browse/JRUBY-2961
Project: JRuby
Issue Type: Bug
Components: ActiveRecord-JDBC
Affects Versions: ActiveRecord-JDBC 0.8.2
Environment: OS X 10.5 (expect OS independent)
Oracle 10.2 (expect version independent, but specific to Oracle)
Jruby 1.1.3 and 1.1.4
Reporter: David Filiatrault
Priority: Blocker
During the fixture insert generation process, columns of Oracle datatype "DATE"
have the string "TIMESTAMP" prefixed before the value to be inserted, as seen
below.
------------------------
$ jruby holiday_test.rb
Loaded suite holiday_test
Started
E
Finished in 1.632811 seconds.
1) Error:
test_halloween(HolidayTest):
ActiveRecord::StatementInvalid: ActiveRecord::ActiveRecordError: ORA-01438:
value larger than specified precision allowed for this column
: INSERT INTO holidays (dt_end, dt_start, name, plusstd, plusrush, holidayid)
VALUES (TIMESTAMP'2008-09-04 00:00:00', TIMESTAMP'2008-08-31 00:00:00',
'Technology day', 2, 0, 257597727)
/opt/jruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract/database_statements.rb:73:in
`transaction'
/opt/jruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/fixtures.rb:518:in
`create_fixtures'
/opt/jruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract_adapter.rb:78:in
`disable_referential_integrity'
/opt/jruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/fixtures.rb:509:in
`create_fixtures'
/opt/jruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:1263:in
`silence'
/opt/jruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/fixtures.rb:508:in
`create_fixtures'
/opt/jruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/fixtures.rb:963:in
`load_fixtures'
/opt/jruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/fixtures.rb:929:in
`setup_fixtures'
/opt/jruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/callbacks.rb:173:in
`evaluate_method'
/opt/jruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/callbacks.rb:161:in
`call'
/opt/jruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/callbacks.rb:90:in
`run'
/opt/jruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/callbacks.rb:90:in
`each'
/opt/jruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/callbacks.rb:90:in
`run'
/opt/jruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/callbacks.rb:272:in
`run_callbacks'
/opt/jruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/testing/setup_and_teardown.rb:31:in
`run_with_callbacks'
1 tests, 0 assertions, 0 failures, 1 errors
--------------
Attached is the .yml fixture, model, unit test files. Will add the table
generation script after submitting, either as an attachment if permitted or as
a comment.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
