I'm getting the following error while connecting to mysql using activerecord-jdbcmysql-adapter (1.0.2). Rails 3.0.1.
ActiveRecord::JDBCError: Generated keys not requested. You need to specify Statement.RETURN_GENERATED_KEYS to Statement.executeUpdate() or Connection.prepareStatement().: SET SQL_AUTO_IS_NULL=0 This occurs not matter what application I run it in to e.g. rake, rails console, or from my app. Here's the trace while running it from rake: jruby -S rake db:schema:dump --trace (in /Users/MJW/Sites/test_app) ** Invoke db:schema:dump (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:schema:dump rake aborted! ActiveRecord::JDBCError: Generated keys not requested. You need to specify Statement.RETURN_GENERATED_KEYS to Statement.executeUpdate() or Connection.prepareStatement().: SET SQL_AUTO_IS_NULL=0 /jruby-1.5.3/lib/ruby/gems/1.8/gems/activerecord-3.0.1/lib/ active_record/connection_adapters/abstract_adapter.rb:202:in `log' /jruby-1.5.3/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-1.0.2- java/lib/arjdbc/jdbc/adapter.rb:178:in `execute' /jruby-1.5.3/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-1.0.2- java/lib/arjdbc/mysql/adapter.rb:14:in `configure_connection' /jruby-1.5.3/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-1.0.2- java/lib/arjdbc/mysql/adapter.rb:385:in `initialize' /jruby-1.5.3/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-1.0.2- java/lib/arjdbc/jdbc/connection_methods.rb:6:in `new' /jruby-1.5.3/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-1.0.2- java/lib/arjdbc/jdbc/connection_methods.rb:6:in `jdbc_connection' /jruby-1.5.3/lib/ruby/gems/1.8/gems/activerecord-jdbc-adapter-1.0.2- java/lib/arjdbc/mysql/connection_methods.rb:18:in `mysql_connection' /jruby-1.5.3/lib/ruby/gems/1.8/gems/activerecord-3.0.1/lib/ active_record/connection_adapters/abstract/connection_pool.rb:230:in `new_connection' /jruby-1.5.3/lib/ruby/gems/1.8/gems/activerecord-3.0.1/lib/ active_record/connection_adapters/abstract/connection_pool.rb:238:in `checkout_new_connection' /jruby-1.5.3/lib/ruby/gems/1.8/gems/activerecord-3.0.1/lib/ active_record/connection_adapters/abstract/connection_pool.rb:194:in `checkout' /jruby-1.5.3/lib/ruby/gems/1.8/gems/activerecord-3.0.1/lib/ active_record/connection_adapters/abstract/connection_pool.rb:190:in `loop' /jruby-1.5.3/lib/ruby/gems/1.8/gems/activerecord-3.0.1/lib/ active_record/connection_adapters/abstract/connection_pool.rb:190:in `checkout' /jruby-1.5.3/lib/ruby/1.8/monitor.rb:191:in `mon_synchronize' /jruby-1.5.3/lib/ruby/gems/1.8/gems/activerecord-3.0.1/lib/ active_record/connection_adapters/abstract/connection_pool.rb:189:in `checkout' /jruby-1.5.3/lib/ruby/gems/1.8/gems/activerecord-3.0.1/lib/ active_record/connection_adapters/abstract/connection_pool.rb:96:in `connection' /jruby-1.5.3/lib/ruby/gems/1.8/gems/activerecord-3.0.1/lib/ active_record/connection_adapters/abstract/connection_pool.rb:318:in `retrieve_connection' /jruby-1.5.3/lib/ruby/gems/1.8/gems/activerecord-3.0.1/lib/ active_record/connection_adapters/abstract/connection_specification.rb: 97:in `retrieve_connection' /jruby-1.5.3/lib/ruby/gems/1.8/gems/activerecord-3.0.1/lib/ active_record/connection_adapters/abstract/connection_specification.rb: 89:in `connection' /jruby-1.5.3/lib/ruby/gems/1.8/gems/activerecord-3.0.1/lib/ active_record/railties/databases.rake:327 /jruby-1.5.3/lib/ruby/gems/1.8/gems/activerecord-3.0.1/lib/ active_record/railties/databases.rake:326:in `open' /jruby-1.5.3/lib/ruby/gems/1.8/gems/activerecord-3.0.1/lib/ active_record/railties/databases.rake:326 /jruby-1.5.3/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `call' /jruby-1.5.3/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `execute' /jruby-1.5.3/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `each' /jruby-1.5.3/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `execute' /jruby-1.5.3/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:597:in `invoke_with_call_chain' /jruby-1.5.3/lib/ruby/1.8/monitor.rb:191:in `mon_synchronize' /jruby-1.5.3/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain' /jruby-1.5.3/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:583:in `invoke' /jruby-1.5.3/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2051:in `invoke_task' /jruby-1.5.3/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level' /jruby-1.5.3/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `each' /jruby-1.5.3/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level' /jruby-1.5.3/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling' /jruby-1.5.3/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2023:in `top_level' /jruby-1.5.3/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2001:in `run' /jruby-1.5.3/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling' /jruby-1.5.3/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in `run' /jruby-1.5.3/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:31 /jruby-1.5.3/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:19:in `load' /jruby-1.5.3/bin/rake:19 I've googled extensively to find a solution for this but no luck. Any clues on the cause would be appreciated. Thanks. -- 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
