Although I can't offer you up a solution, I know this is definitely a problem. My guess is you ran in to this when you had a date chooser field in your Rails app. I found this bug when I was working on the adapter, but I really do not know enough about sqlite3 to know the best way to implement true support for dates and datetimes. I would still love to get some help with the adapter, if anyone has more experience with sqlite3 or the AR-JDBC adapters.
Joe On Sat, Jun 28, 2008 at 4:16 PM, Charles Oliver Nutter <[EMAIL PROTECTED]> wrote: > Hello, and very good to meet you! > > This looks like something may be unimplemented in the sqlite3 adapter, so > I'm reposting this to the JRuby dev list. You may want to open a bug for it > here, possibly with a sample script or application that causes the error > below. > > Bug reports here: http://jira.codehaus.org/browse/JRUBY > > Sotohiro Terashima wrote: > >> Hi,Mr. Charlrs Nutter >> >> My Name is Sotohiro Terashima. >> This is my first mail,but I listened your techtalk at Sun Yoga. >> At that event,I questioned about SQLite3 at JRuby on Rails,and you replied >> this got solution. >> But after that I tried many times to implement a SQLite3 sample,then I got >> failure. >> I could make local database creation using SQLite3. >> After that when I tried to input data to this database,then I get >> following exception. >> What are wrong? >> >> JRuby version is 1.1.2. <http://1.1.2.> >> activerecord -jdbcsqlite3-adapter is 0.8.2. <http://0.8.2.> >> database.yml: >> %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% >> # SQLite version 3.x >> # gem install sqlite3-ruby (not necessary on OS X Leopard) >> development: >> adapter: jdbcsqlite3 >> database: db/development.sqlite3 >> timeout: 5000 >> >> # Warning: The database defined as "test" will be erased and >> # re-generated from your development database when you run "rake". >> # Do not set this db to the same as development or production. >> test: >> adapter: sqlite3 >> database: db/test.sqlite3 >> timeout: 5000 >> >> production: >> adapter: sqlite3 >> database: db/production.sqlite3 >> timeout: 5000 >> >> #################################################### >> ActiveRecord::MultiparameterAssignmentErrors in >> CustomersController#create >> >> 1 error(s) on assignment of multiparameter attributes >> >> RAILS_ROOT: C:/ANetBeans6.1/OpenLaszlo/laszlocustomerapp >> Application Trace | Framework Trace | Full Trace >> >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:2651:in >> `execute_callstack_for_multiparameter_attributes' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:2611:in >> `assign_multiparameter_attributes' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:2364:in >> `attributes=' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:2130:in >> `initialize' >> app/controllers/customers_controller.rb:43:in `new' >> app/controllers/customers_controller.rb:43:in `create' >> :1:in `start' >> >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:2651:in >> `execute_callstack_for_multiparameter_attributes' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:2611:in >> `assign_multiparameter_attributes' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:2364:in >> `attributes=' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:2130:in >> `initialize' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/base.rb:1162:in >> `perform_action' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/filters.rb:580:in >> `call_filters' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/filters.rb:573:in >> `perform_action_with_filters' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/benchmarking.rb:68:in >> `perform_action_with_benchmark' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/1.8/benchmark.rb:293:in `measure' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/benchmarking.rb:68:in >> `perform_action_with_benchmark' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/rescue.rb:201:in >> `perform_action_with_rescue' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/caching/sql_cache.rb:13:in >> `perform_action_with_caching' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract/query_cache.rb:33:in >> `cache' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/query_cache.rb:8:in >> `cache' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/caching/sql_cache.rb:12:in >> `perform_action_with_caching' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/base.rb:529:in >> `process' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/filters.rb:569:in >> `process_with_filters' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/session_management.rb:130:in >> `process_with_session_management_support' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/base.rb:389:in >> `process' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/dispatcher.rb:149:in >> `handle_request' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/dispatcher.rb:107:in >> `dispatch' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/dispatcher.rb:104:in >> `dispatch' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/dispatcher.rb:120:in >> `dispatch_cgi' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/dispatcher.rb:35:in >> `dispatch' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/webrick_server.rb:112:in >> `handle_dispatch' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/webrick_server.rb:78:in >> `service' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/1.8/webrick/httpserver.rb:104:in >> `service' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/1.8/webrick/httpserver.rb:65:in >> `run' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/1.8/webrick/server.rb:173:in >> `start_thread' >> >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:2651:in >> `execute_callstack_for_multiparameter_attributes' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:2611:in >> `assign_multiparameter_attributes' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:2364:in >> `attributes=' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:2130:in >> `initialize' >> app/controllers/customers_controller.rb:43:in `new' >> app/controllers/customers_controller.rb:43:in `create' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/base.rb:1162:in >> `perform_action' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/filters.rb:580:in >> `call_filters' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/filters.rb:573:in >> `perform_action_with_filters' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/benchmarking.rb:68:in >> `perform_action_with_benchmark' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/1.8/benchmark.rb:293:in `measure' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/benchmarking.rb:68:in >> `perform_action_with_benchmark' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/rescue.rb:201:in >> `perform_action_with_rescue' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/caching/sql_cache.rb:13:in >> `perform_action_with_caching' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract/query_cache.rb:33:in >> `cache' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/query_cache.rb:8:in >> `cache' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/caching/sql_cache.rb:12:in >> `perform_action_with_caching' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/base.rb:529:in >> `process' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/filters.rb:569:in >> `process_with_filters' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/session_management.rb:130:in >> `process_with_session_management_support' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/base.rb:389:in >> `process' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/dispatcher.rb:149:in >> `handle_request' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/dispatcher.rb:107:in >> `dispatch' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/dispatcher.rb:104:in >> `dispatch' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/dispatcher.rb:120:in >> `dispatch_cgi' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/dispatcher.rb:35:in >> `dispatch' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/webrick_server.rb:112:in >> `handle_dispatch' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/webrick_server.rb:78:in >> `service' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/1.8/webrick/httpserver.rb:104:in >> `service' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/1.8/webrick/httpserver.rb:65:in >> `run' >> C:/Java/jruby-1.1.2_Rails2.1.0/lib/ruby/1.8/webrick/server.rb:173:in >> `start_thread' >> :1:in `start' >> >> Request >> >> Parameters: >> >> {"authenticity_token"=>"a93d15103b8102ec736d48bfb2fa43be71b1f95f", >> "customer"=>{"zip"=>"１１１１１１１", >> "address"=>"東京都東京１−１−１", >> "first_name"=>"太郎", >> "last_name"=>"東京", >> "birthday(1i)"=>"2007", >> "birthday(2i)"=>"9", >> "birthday(3i)"=>"3", >> "tel"=>"０１−００００−０００１", >> "mail"=>"[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>", >> "mail_mobile"=>"[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>", >> "note"=>"テストデータ１"}, >> "commit"=>"Create"} >> >> Show session dump >> >> --- >> flash: !map:ActionController::Flash::FlashHash {} >> :csrf_id: 08ac71969f1b53a39ae617c935957c26 >> >> Response >> >> Headers: >> >> {"Cache-Control"=>"no-cache", >> "cookie"=>[]} >> > > > --------------------------------------------------------------------- > To unsubscribe from this list, please visit: > > http://xircles.codehaus.org/manage_email > > >
