activerecord-jdbcpostgresql-adaqpter adds id to insert columns even if it
should be returned by the database
------------------------------------------------------------------------------------------------------------
Key: JRUBY-4781
URL: http://jira.codehaus.org/browse/JRUBY-4781
Project: JRuby
Issue Type: Bug
Components: JRuby-extras
Environment: RedHat EL 5
jruby 1.5.0.RC2 (ruby 1.8.7 patchlevel 249) (2010-04-28 7c245f3) (Java
HotSpot(TM) Client VM 1.6.0_14) [i386-java]
actionmailer (2.3.5)
actionpack (2.3.5)
activerecord (2.3.5)
activerecord-jdbc-adapter (0.9.6, 0.9.5)
activerecord-jdbcpostgresql-adapter (0.9.6, 0.9.5)
activeresource (2.3.5)
activesupport (2.3.5)
builder (2.1.2)
columnize (0.3.1)
geokit (1.5.0)
glassfish (1.0.2)
jdbc-postgres (8.4.701)
jruby-openssl (0.7)
log4r (1.1.7)
mocha (0.9.8)
rack (1.0.1)
rails (2.3.5)
rake (0.8.7)
rcov (0.9.8)
rspec (1.3.0)
ruby-debug (0.10.3)
ruby-debug-base (0.10.3.2)
sources (0.0.1)
wirble (0.1.3)
Reporter: Uwe Kubosch
After updating to 0.9.6 we get this error:
2010-05-06 20:55:48 ERROR : ActiveRecord::ActiveRecordError: ERROR: syntax
error at or near ")"
Position: 369: INSERT INTO "audit_logs" ("operation", "model_name",
"record_id", "new_values", "source", "user_id", "created_at", "updated_at",
"id") VALUES('UPDATE', 'OslOrder', 'bqpYCav9Kr36e29m5gVyKq', '---
eta: 2010-05-06 19:16:00 Z
pta: 2010-05-06 19:20:00 Z
updated_at: 2010-05-06 18:55:47.889000 Z
', 'FDB', NULL, '2010-05-06 18:55:47.986000', '2010-05-06 18:55:47.986000', ?)
RETURNING "id" (ActiveRecord::StatementInvalid)
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract_adapter.rb:219:in
`log'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9.6-java/lib/active_record/connection_adapters/jdbc_adapter.rb:653:in
`select'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9.6-java/lib/active_record/connection_adapters/jdbc_adapter.rb:576:in
`select_one'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/database_statements.rb:19:in
`select_value'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-0.9.6-java/lib/jdbc_adapter/jdbc_postgre.rb:240:in
`insert'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:2908:in
`create'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/timestamp.rb:53:in
`create_with_timestamps'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/callbacks.rb:266:in
`create_with_callbacks'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:2874:in
`create_or_update'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/callbacks.rb:250:in
`create_or_update_with_callbacks'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:2555:in
`save!'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/validations.rb:1088:in
`save_with_validation!'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/dirty.rb:87:in
`save_with_dirty!'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/transactions.rb:200:in
`save_with_transactions!'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in
`transaction'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/transactions.rb:182:in
`transaction'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/transactions.rb:200:in
`save_with_transactions!'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/transactions.rb:208:in
`rollback_active_record_state!'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/transactions.rb:200:in
`save_with_transactions!'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/validations.rb:1059:in
`create!'
/usr/local/aifudis.admin/app/models/auditing.rb:39:in `after_update'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/observer.rb:171:in
`update'
/usr/local/aifudis.admin/platform/jruby/lib/ruby/1.8/observer.rb:185:in
`notify_observers'
/usr/local/aifudis.admin/platform/jruby/lib/ruby/1.8/observer.rb:184:in `each'
/usr/local/aifudis.admin/platform/jruby/lib/ruby/1.8/observer.rb:184:in
`notify_observers'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/callbacks.rb:357:in
`notify'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/callbacks.rb:350:in
`callback'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/callbacks.rb:283:in
`update_with_callbacks'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:2874:in
`create_or_update'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/callbacks.rb:250:in
`create_or_update_with_callbacks'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:2555:in
`save!'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/validations.rb:1088:in
`save_with_validation!'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/dirty.rb:87:in
`save_with_dirty!'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/transactions.rb:200:in
`save_with_transactions!'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in
`transaction'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/transactions.rb:182:in
`transaction'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/transactions.rb:200:in
`save_with_transactions!'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/transactions.rb:208:in
`rollback_active_record_state!'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/transactions.rb:200:in
`save_with_transactions!'
/usr/local/aifudis.admin/app/models/fdb_data_fetcher.rb:104:in `update_order'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in
`transaction'
/usr/local/aifudis.admin/platform/jruby-1.5.0.RC2/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/transactions.rb:182:in
`transaction'
/usr/local/aifudis.admin/app/models/fdb_data_fetcher.rb:79:in `update_order'
/usr/local/aifudis.admin/app/models/fdb_data_fetcher.rb:68:in `import_orders'
/usr/local/aifudis.admin/app/models/fdb_data_fetcher.rb:67:in `each'
/usr/local/aifudis.admin/app/models/fdb_data_fetcher.rb:67:in `import_orders'
/usr/local/aifudis.admin/app/models/fdb_data_fetcher.rb:30:in `initialize'
/usr/local/aifudis.admin/app/models/fdb_data_fetcher.rb:17:in `loop'
/usr/local/aifudis.admin/app/models/fdb_data_fetcher.rb:17:in `initialize'
/usr/local/aifudis.admin/app/models/fdb_data_fetcher.rb:11:in `new'
/usr/local/aifudis.admin/app/models/fdb_data_fetcher.rb:11:in `start'
(eval):1
--
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
