Ruby on Rails

I finally found the cause of this. I had a mysql-connector-
java-5.1.13-bin.jar file in my $JRUBY_HOME/lib directory.
When I removed this is went to a mysql-connector-java-5.0.4-bin.jar
file further down in my jruby tree.
I'm not sure if it was the later version of mysql-connector-java that
was causing the problem or whether it didn't like the CONNECTOR/J
jar file in the $JRUBY_HOME/lib directory.

On Oct 27, 8:51 pm, MJW2529 <mjwhite2...@yahoo.com> wrote:
> 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 rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.