Hi, I''ve been trying to get JRuby 1.5.3 with Rails 3 to run on the Tomcat6 server with little success. Has anyone been able to do this? If so, what issues did you have to overcome to get this to work? Also, is this a combination that you would recommend for a production site, or is it all too new and untested? The latest issue I''m stuck on right now is with the mysql-connector- java-5.0.4 which comes with jruby 1.5.3 which keeps returning JDBCError: Generated keys not requested. Any feedback on this 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
can you run $ jruby -S rails server ? how does your Gemfile look like ? how do you setup your war files ? with warbler ? regards, Kristian On Oct 30, 6:21 am, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote:> Hi, > I''ve been trying to get JRuby 1.5.3 with Rails 3 to run on the Tomcat6 > server with little success. > Has anyone been able to do this? If so, what issues did you have to > overcome to get this to work? > Also, is this a combination that you would recommend for a production > site, or is it all too new and untested? > The latest issue I''m stuck on right now is with the mysql-connector- > java-5.0.4 which comes with jruby 1.5.3 which keeps returning > JDBCError: Generated keys not requested. > Any feedback on this 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org 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.
I setup the war file with warbler. Here''s the Gemfile: source ''http://rubygems.org'' gem ''rails'', ''3.0.1'' # Bundle edge Rails instead: # gem ''rails'', :git => ''git://github.com/rails/rails.git'' #gem ''sqlite3-ruby'', :require => ''sqlite3'' gem "activerecord-jdbcmysql-adapter", ''1.0.2'', :require =>''arjdbc'' if defined?(JRUBY_VERSION) # Use unicorn as the web server # gem ''unicorn'' # Deploy with Capistrano # gem ''capistrano'' # To use debugger # gem ''ruby-debug'' # Bundle the extra gems: # gem ''bj'' # gem ''nokogiri'' # gem ''sqlite3-ruby'', :require => ''sqlite3'' # gem ''aws-s3'', :require => ''aws/s3'' # Bundle gems for the local environment. Make sure to # put test-only gems in this group so their generators # and rake tasks are available in development mode: # group :development, :test do # gem ''webrat'' # end In the config/warbler.rb file I also have the following line uncommented: config.gems += ["activerecord-jdbcmysql-adapter", "jruby-openssl"] Also, the "jruby -S rails server" command brings up the WEBrick server not Tomcat. I propose to run Tomcat in the production environment. On Oct 31, 12:49 am, mkristian <meier.krist...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> can you run > $ jruby -S rails server > ? > how does your Gemfile look like ? > how do you setup your war files ? with warbler ? > > regards, Kristian > > On Oct 30, 6:21 am, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote: > > > Hi, > > I''ve been trying to get JRuby 1.5.3 with Rails 3 to run on the Tomcat6 > > server with little success. > > Has anyone been able to do this? If so, what issues did you have to > > overcome to get this to work? > > Also, is this a combination that you would recommend for a production > > site, or is it all too new and untested? > > The latest issue I''m stuck on right now is with the mysql-connector- > > java-5.0.4 which comes with jruby 1.5.3 which keeps returning > > JDBCError: Generated keys not requested. > > Any feedback on this 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org 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.
my typical Gemfile starts like this and works without a problem with
jetty and your error does not look tomcat-related. I would not use
config.gems just add the gems you need in Gemfile.
# -*- mode: ruby -*-
source ''http://rubygems.org''
gem ''rails'', ''3.0.0''
# Bundle edge Rails instead:
# gem ''rails'', :git =>
''git://github.com/rails/rails.git''
gem ''mysql2'', :require => ''sqlite3''
unless defined?(JRUBY_VERSION)
gem "activerecord-jdbc-adapter" if defined?(JRUBY_VERSION)
gem "jdbc-mysql", :require => false if defined?(JRUBY_VERSION)
in my Gemfile.lock I see
activerecord-jdbc-adapter (0.9.4-java)
maybe that setup helps.
regards, Kristian
On Nov 1, 9:47 am, MJW2529
<mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org>
wrote:> I setup the war file with warbler. Here''s the Gemfile:
>
> source ''http://rubygems.org''
> gem ''rails'', ''3.0.1''
>
> # Bundle edge Rails instead:
> # gem ''rails'', :git =>
''git://github.com/rails/rails.git''
>
> #gem ''sqlite3-ruby'', :require =>
''sqlite3''
> gem "activerecord-jdbcmysql-adapter", ''1.0.2'',
:require =>''arjdbc'' if
> defined?(JRUBY_VERSION)
>
> # Use unicorn as the web server
> # gem ''unicorn''
>
> # Deploy with Capistrano
> # gem ''capistrano''
>
> # To use debugger
> # gem ''ruby-debug''
>
> # Bundle the extra gems:
> # gem ''bj''
> # gem ''nokogiri''
> # gem ''sqlite3-ruby'', :require =>
''sqlite3''
> # gem ''aws-s3'', :require => ''aws/s3''
>
> # Bundle gems for the local environment. Make sure to
> # put test-only gems in this group so their generators
> # and rake tasks are available in development mode:
> # group :development, :test do
> # gem ''webrat''
> # end
>
> In the config/warbler.rb file I also have the following line
> uncommented:
>
> config.gems += ["activerecord-jdbcmysql-adapter",
"jruby-openssl"]
>
> Also, the "jruby -S rails server" command brings up the WEBrick
> server not Tomcat.
> I propose to run Tomcat in the production environment.
>
> On Oct 31, 12:49 am, mkristian
<meier.krist...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
>
> > can you run
> > $ jruby -S rails server
> > ?
> > how does your Gemfile look like ?
> > how do you setup your war files ? with warbler ?
>
> > regards, Kristian
>
> > On Oct 30, 6:21 am, MJW2529
<mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote:
>
> > > Hi,
> > > I''ve been trying to get JRuby 1.5.3 with Rails 3 to run
on the Tomcat6
> > > server with little success.
> > > Has anyone been able to do this? If so, what issues did you have
to
> > > overcome to get this to work?
> > > Also, is this a combination that you would recommend for a
production
> > > site, or is it all too new and untested?
> > > The latest issue I''m stuck on right now is with the
mysql-connector-
> > > java-5.0.4 which comes with jruby 1.5.3 which keeps returning
> > > JDBCError: Generated keys not requested.
> > > Any feedback on this 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
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.
Thanks for your help so far Kristan. I''ve put the entries that you suggested into my Gemfile and redeployed to Tomcat but I still get the following error back. SEVERE: Application Error org.jruby.rack.RackInitializationException: 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 When I deploy this under the WEBrick server it runs fine (although I not creating a war file for the WEBrick server). Is there anyway to ensure that the deployed war file is using the same stack as my development environment? Thanks. On Nov 1, 1:21 pm, mkristian <meier.krist...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> my typical Gemfile starts like this and works without a problem with > jetty and your error does not look tomcat-related. I would not use > config.gems just add the gems you need in Gemfile. > > # -*- mode: ruby -*- > source ''http://rubygems.org'' > > gem ''rails'', ''3.0.0'' > > # Bundle edge Rails instead: > # gem ''rails'', :git => ''git://github.com/rails/rails.git'' > > gem ''mysql2'', :require => ''sqlite3'' unless defined?(JRUBY_VERSION) > gem "activerecord-jdbc-adapter" if defined?(JRUBY_VERSION) > gem "jdbc-mysql", :require => false if defined?(JRUBY_VERSION) > > in my Gemfile.lock I see > activerecord-jdbc-adapter (0.9.4-java) > > maybe that setup helps. > regards, Kristian > > On Nov 1, 9:47 am, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote: > > > I setup the war file with warbler. Here''s the Gemfile: > > > source ''http://rubygems.org'' > > gem ''rails'', ''3.0.1'' > > > # Bundle edge Rails instead: > > # gem ''rails'', :git => ''git://github.com/rails/rails.git'' > > > #gem ''sqlite3-ruby'', :require => ''sqlite3'' > > gem "activerecord-jdbcmysql-adapter", ''1.0.2'', :require =>''arjdbc'' if > > defined?(JRUBY_VERSION) > > > # Use unicorn as the web server > > # gem ''unicorn'' > > > # Deploy with Capistrano > > # gem ''capistrano'' > > > # To use debugger > > # gem ''ruby-debug'' > > > # Bundle the extra gems: > > # gem ''bj'' > > # gem ''nokogiri'' > > # gem ''sqlite3-ruby'', :require => ''sqlite3'' > > # gem ''aws-s3'', :require => ''aws/s3'' > > > # Bundle gems for the local environment. Make sure to > > # put test-only gems in this group so their generators > > # and rake tasks are available in development mode: > > # group :development, :test do > > # gem ''webrat'' > > # end > > > In the config/warbler.rb file I also have the following line > > uncommented: > > > config.gems += ["activerecord-jdbcmysql-adapter", "jruby-openssl"] > > > Also, the "jruby -S rails server" command brings up the WEBrick > > server not Tomcat. > > I propose to run Tomcat in the production environment. > > > On Oct 31, 12:49 am, mkristian <meier.krist...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > can you run > > > $ jruby -S rails server > > > ? > > > how does your Gemfile look like ? > > > how do you setup your war files ? with warbler ? > > > > regards, Kristian > > > > On Oct 30, 6:21 am, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote: > > > > > Hi, > > > > I''ve been trying to get JRuby 1.5.3 with Rails 3 to run on the Tomcat6 > > > > server with little success. > > > > Has anyone been able to do this? If so, what issues did you have to > > > > overcome to get this to work? > > > > Also, is this a combination that you would recommend for a production > > > > site, or is it all too new and untested? > > > > The latest issue I''m stuck on right now is with the mysql-connector- > > > > java-5.0.4 which comes with jruby 1.5.3 which keeps returning > > > > JDBCError: Generated keys not requested. > > > > Any feedback on this 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org 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.
first I have to mention warble produces a production environment, so maybe you need to somehting like $ jruby -S rake :db:setup then you can use the ruby-maven gem $ jruby -S gem install ruby-maven --pre which comes with jetty setup which you can just start with $ jetty-run and this runs in development mode or for production $ jetty-run -e production and of course to compare you should also see that webrick works in production mode $ jruby rails s -e production and then with the ruby-maven gem you can produces another warfile which might be slightly different from what warble produces (target/ XZY.war): $ rmvn package with this we should be able to see whether this is tomcat or the servlet stack as such (since we can compare it jetty). is that all the stacktrace you get, can you increase logging on production - maybe there is more to see. let''s see if this helps to narrow down the issue regards, Kristian On Nov 2, 7:06 am, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote:> Thanks for your help so far Kristan. I''ve put the entries that you > suggested into my Gemfile and redeployed to Tomcat but I still get the > following error back. > SEVERE: Application Error > org.jruby.rack.RackInitializationException: 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 > > When I deploy this under the WEBrick server it runs fine (although I > not creating a war file for the WEBrick server). > Is there anyway to ensure that the deployed war file is using the same > stack as my development environment? > Thanks. > > On Nov 1, 1:21 pm, mkristian <meier.krist...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > my typical Gemfile starts like this and works without a problem with > > jetty and your error does not look tomcat-related. I would not use > > config.gems just add the gems you need in Gemfile. > > > # -*- mode: ruby -*- > > source ''http://rubygems.org'' > > > gem ''rails'', ''3.0.0'' > > > # Bundle edge Rails instead: > > # gem ''rails'', :git => ''git://github.com/rails/rails.git'' > > > gem ''mysql2'', :require => ''sqlite3'' unless defined?(JRUBY_VERSION) > > gem "activerecord-jdbc-adapter" if defined?(JRUBY_VERSION) > > gem "jdbc-mysql", :require => false if defined?(JRUBY_VERSION) > > > in my Gemfile.lock I see > > activerecord-jdbc-adapter (0.9.4-java) > > > maybe that setup helps. > > regards, Kristian > > > On Nov 1, 9:47 am, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote: > > > > I setup the war file with warbler. Here''s the Gemfile: > > > > source ''http://rubygems.org'' > > > gem ''rails'', ''3.0.1'' > > > > # Bundle edge Rails instead: > > > # gem ''rails'', :git => ''git://github.com/rails/rails.git'' > > > > #gem ''sqlite3-ruby'', :require => ''sqlite3'' > > > gem "activerecord-jdbcmysql-adapter", ''1.0.2'', :require =>''arjdbc'' if > > > defined?(JRUBY_VERSION) > > > > # Use unicorn as the web server > > > # gem ''unicorn'' > > > > # Deploy with Capistrano > > > # gem ''capistrano'' > > > > # To use debugger > > > # gem ''ruby-debug'' > > > > # Bundle the extra gems: > > > # gem ''bj'' > > > # gem ''nokogiri'' > > > # gem ''sqlite3-ruby'', :require => ''sqlite3'' > > > # gem ''aws-s3'', :require => ''aws/s3'' > > > > # Bundle gems for the local environment. Make sure to > > > # put test-only gems in this group so their generators > > > # and rake tasks are available in development mode: > > > # group :development, :test do > > > # gem ''webrat'' > > > # end > > > > In the config/warbler.rb file I also have the following line > > > uncommented: > > > > config.gems += ["activerecord-jdbcmysql-adapter", "jruby-openssl"] > > > > Also, the "jruby -S rails server" command brings up the WEBrick > > > server not Tomcat. > > > I propose to run Tomcat in the production environment. > > > > On Oct 31, 12:49 am, mkristian <meier.krist...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > > can you run > > > > $ jruby -S rails server > > > > ? > > > > how does your Gemfile look like ? > > > > how do you setup your war files ? with warbler ? > > > > > regards, Kristian > > > > > On Oct 30, 6:21 am, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote: > > > > > > Hi, > > > > > I''ve been trying to get JRuby 1.5.3 with Rails 3 to run on the Tomcat6 > > > > > server with little success. > > > > > Has anyone been able to do this? If so, what issues did you have to > > > > > overcome to get this to work? > > > > > Also, is this a combination that you would recommend for a production > > > > > site, or is it all too new and untested? > > > > > The latest issue I''m stuck on right now is with the mysql-connector- > > > > > java-5.0.4 which comes with jruby 1.5.3 which keeps returning > > > > > JDBCError: Generated keys not requested. > > > > > Any feedback on this 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org 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.
I''ll go ahead and complete the process that you''ve outlined and see if I can narrow it down. In the meantime here''s the complete trace of the error. Nov 1, 2010 7:10:45 PM org.apache.catalina.core.ApplicationContext log SEVERE: Application Error org.jruby.rack.RackInitializationException: 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 from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/adapter.rb:178:in `execute'' from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- jdbc-adapter-1.0.2-java/lib/arjdbc/mysql/adapter.rb:14:in `configure_connection'' from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- jdbc-adapter-1.0.2-java/lib/arjdbc/mysql/adapter.rb:385:in `initialize'' from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/connection_methods.rb:6:in `new'' from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/connection_methods.rb:6:in `jdbc_connection'' from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- jdbc-adapter-1.0.2-java/lib/arjdbc/mysql/connection_methods.rb:18:in `mysql_connection'' from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ activerecord-3.0.1/lib/active_record/connection_adapters/abstract/ connection_pool.rb:230:in `new_connection'' from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ activerecord-3.0.1/lib/active_record/connection_adapters/abstract/ connection_pool.rb:238:in `checkout_new_connection'' ... 50 levels... from file:/Library/Tomcat/apache-tomcat-6.0.29/webapps/RSM/WEB-INF/ lib/jruby-rack-1.0.3.jar!/vendor/rack-1.2.1/rack/builder.rb:46:in `initialize'' from <script>:2:in `new'' from <script>:2 at org.jruby.rack.DefaultRackApplicationFactory $4.init(DefaultRackApplicationFactory.java:184) at org.jruby.rack.DefaultRackApplicationFactory.getApplication(DefaultRackApplicationFactory.java: 59) at org.jruby.rack.PoolingRackApplicationFactory.getApplication(PoolingRackApplicationFactory.java: 94) at org.jruby.rack.servlet.DefaultServletDispatcher.process(DefaultServletDispatcher.java: 36) at org.jruby.rack.RackFilter.doFilter(RackFilter.java:59) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: 127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: 102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: 109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: 857) at org.apache.coyote.http11.Http11Protocol $Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java: 489) at java.lang.Thread.run(Thread.java:680) Caused by: org.jruby.exceptions.RaiseException: 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 at Kernel.raise(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ activerecord-3.0.1/lib/active_record/connection_adapters/ abstract_adapter.rb:202) at ActiveRecord::ConnectionAdapters::AbstractAdapter.log(/Library/ Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-jdbc- adapter-1.0.2-java/lib/arjdbc/jdbc/adapter.rb:178) at ActiveRecord::ConnectionAdapters::JdbcAdapter.execute(/Library/ Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-jdbc- adapter-1.0.2-java/lib/arjdbc/mysql/adapter.rb:14) at ArJdbc::MySQL.configure_connection(/Library/Tomcat/Home/webapps/ RSM/WEB-INF/gems/gems/activerecord-jdbc-adapter-1.0.2-java/lib/arjdbc/ mysql/adapter.rb:385) at ActiveRecord::ConnectionAdapters::MysqlAdapter.initialize(/Library/ Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-jdbc- adapter-1.0.2-java/lib/arjdbc/jdbc/connection_methods.rb:6) at (unknown).new(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ activerecord-jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/ connection_methods.rb:6) at #<Class:01x1aff2be8>.jdbc_connection(/Library/Tomcat/Home/webapps/ RSM/WEB-INF/gems/gems/activerecord-jdbc-adapter-1.0.2-java/lib/arjdbc/ mysql/connection_methods.rb:18) at #<Class:01x1aff2be8>.mysql_connection(/Library/Tomcat/Home/webapps/ RSM/WEB-INF/gems/gems/activerecord-3.0.1/lib/active_record/ connection_adapters/abstract/connection_pool.rb:230) at ActiveRecord::ConnectionAdapters::ConnectionPool.new_connection(/ Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/ lib/active_record/connection_adapters/abstract/connection_pool.rb:238) at ActiveRecord::ConnectionAdapters::ConnectionPool.checkout_new_connection(/ Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/ lib/active_record/connection_adapters/abstract/connection_pool.rb:194) at ActiveRecord::ConnectionAdapters::ConnectionPool.checkout(/Library/ Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/lib/ active_record/connection_adapters/abstract/connection_pool.rb:190) at Kernel.loop(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ activerecord-3.0.1/lib/active_record/connection_adapters/abstract/ connection_pool.rb:190) at ActiveRecord::ConnectionAdapters::ConnectionPool.checkout(file:/ Library/Tomcat/apache-tomcat-6.0.29/webapps/RSM/WEB-INF/lib/jruby- stdlib-1.5.3.jar!/META-INF/jruby.home/lib/ruby/1.8/monitor.rb:191) at MonitorMixin.mon_synchronize(/Library/Tomcat/Home/webapps/RSM/WEB- INF/gems/gems/activerecord-3.0.1/lib/active_record/connection_adapters/ abstract/connection_pool.rb:189) at ActiveRecord::ConnectionAdapters::ConnectionPool.checkout(/Library/ Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/lib/ active_record/connection_adapters/abstract/connection_pool.rb:96) at ActiveRecord::ConnectionAdapters::ConnectionPool.connection(/ Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/ lib/active_record/connection_adapters/abstract/connection_pool.rb:318) at ActiveRecord::ConnectionAdapters::ConnectionHandler.retrieve_connection(/ Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/ lib/active_record/connection_adapters/abstract/ connection_specification.rb:97) at #<Class:01x1aff2be8>.retrieve_connection(/Library/Tomcat/Home/ webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/lib/active_record/ connection_adapters/abstract/connection_specification.rb:89) at #<Class:01x1aff2be8>.connection(/Library/Tomcat/Home/webapps/RSM/ WEB-INF/gems/gems/arel-1.0.1/lib/arel/engines/sql/engine.rb:9) at Arel::Sql::Engine.connection(/Library/Tomcat/Home/webapps/RSM/WEB- INF/gems/gems/arel-1.0.1/lib/arel/engines/sql/relations/table.rb:37) at Arel::Table.initialize(/Library/Tomcat/Home/webapps/RSM/WEB-INF/ gems/gems/activerecord-3.0.1/lib/active_record/base.rb:850) at (unknown).new(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ activerecord-3.0.1/lib/active_record/base.rb:850) at #<Class:01x1aff2be8>.arel_table(/Library/Tomcat/Home/webapps/RSM/ WEB-INF/gems/gems/activerecord-3.0.1/lib/active_record/base.rb:896) at #<Class:01x1aff2be8>.relation(/Library/Tomcat/Home/webapps/RSM/WEB- INF/gems/gems/activerecord-3.0.1/lib/active_record/named_scope.rb:32) at ActiveRecord::NamedScope::ClassMethods.scoped(/Library/Tomcat/Home/ webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/lib/active_record/ base.rb:441) at #<Class:01x1aff2be8>.limit(/Library/Tomcat/apache-tomcat-6.0.29/ webapps/RSM/WEB-INF/app/models/artist.rb:5) at (unknown).(unknown)(/Library/Tomcat/apache-tomcat-6.0.29/webapps/ RSM/WEB-INF/app/models/artist.rb:239) at (unknown).(unknown)(/Library/Tomcat/apache-tomcat-6.0.29/webapps/ RSM/WEB-INF/app/models/artist.rb:239) at Kernel.require(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ activesupport-3.0.1/lib/active_support/dependencies.rb:239) at ActiveSupport::Dependencies::Loadable.require(/Library/Tomcat/Home/ webapps/RSM/WEB-INF/gems/gems/activesupport-3.0.1/lib/active_support/ dependencies.rb:227) at ActiveSupport::Dependencies::Loadable.load_dependency(/Library/ Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activesupport-3.0.1/lib/ active_support/dependencies.rb:239) at ActiveSupport::Dependencies::Loadable.require(/Library/Tomcat/Home/ webapps/RSM/WEB-INF/gems/gems/activesupport-3.0.1/lib/active_support/ dependencies.rb:346) at ActiveSupport::Dependencies.require_or_load(/Library/Tomcat/Home/ webapps/RSM/WEB-INF/gems/gems/activesupport-3.0.1/lib/active_support/ dependencies.rb:300) at ActiveSupport::Dependencies.depend_on(/Library/Tomcat/Home/webapps/ RSM/WEB-INF/gems/gems/activesupport-3.0.1/lib/active_support/ dependencies.rb:216) at ActiveSupport::Dependencies::Loadable.require_dependency(/Library/ Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/railties-3.0.1/lib/rails/ engine.rb:138) at Rails::Engine.eager_load!(/Library/Tomcat/Home/webapps/RSM/WEB-INF/ gems/gems/railties-3.0.1/lib/rails/engine.rb:137) at Array.each(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ railties-3.0.1/lib/rails/engine.rb:137) at Rails::Engine.eager_load!(/Library/Tomcat/Home/webapps/RSM/WEB-INF/ gems/gems/railties-3.0.1/lib/rails/engine.rb:135) at Array.each(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ railties-3.0.1/lib/rails/engine.rb:135) at Rails::Engine.eager_load!(/Library/Tomcat/Home/webapps/RSM/WEB-INF/ gems/gems/railties-3.0.1/lib/rails/application.rb:108) at Rails::Application.eager_load!(/Library/Tomcat/Home/webapps/RSM/ WEB-INF/gems/gems/railties-3.0.1/lib/rails/application/finisher.rb:41) at (unknown).(unknown)(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/ gems/railties-3.0.1/lib/rails/initializable.rb:25) at Kernel.instance_exec(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/ gems/railties-3.0.1/lib/rails/initializable.rb:25) at Kernel.instance_exec(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/ gems/railties-3.0.1/lib/rails/initializable.rb:25) at Rails::Initializable::Initializer.run(/Library/Tomcat/Home/webapps/ RSM/WEB-INF/gems/gems/railties-3.0.1/lib/rails/initializable.rb:50) at Rails::Initializable.run_initializers(/Library/Tomcat/Home/webapps/ RSM/WEB-INF/gems/gems/railties-3.0.1/lib/rails/initializable.rb:49) at Array.each(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ railties-3.0.1/lib/rails/initializable.rb:49) at Rails::Initializable.run_initializers(/Library/Tomcat/Home/webapps/ RSM/WEB-INF/gems/gems/railties-3.0.1/lib/rails/application.rb:134) at Rails::Application.initialize!(/Library/Tomcat/Home/webapps/RSM/ WEB-INF/gems/gems/railties-3.0.1/lib/rails/application.rb:77) at #<Class:01x4856d15d>.method_missing(/Library/Tomcat/apache- tomcat-6.0.29/webapps/RSM/WEB-INF/config/environment.rb:9) at (unknown).(unknown)(/Library/Tomcat/apache-tomcat-6.0.29/webapps/ RSM/WEB-INF/config/environment.rb:239) at Kernel.require(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ activesupport-3.0.1/lib/active_support/dependencies.rb:239) at ActiveSupport::Dependencies::Loadable.require(/Library/Tomcat/Home/ webapps/RSM/WEB-INF/gems/gems/activesupport-3.0.1/lib/active_support/ dependencies.rb:225) at ActiveSupport::Dependencies::Loadable.load_dependency(/Library/ Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activesupport-3.0.1/lib/ active_support/dependencies.rb:591) at ActiveSupport::Dependencies.new_constants_in(/Library/Tomcat/Home/ webapps/RSM/WEB-INF/gems/gems/activesupport-3.0.1/lib/active_support/ dependencies.rb:225) at ActiveSupport::Dependencies::Loadable.load_dependency(/Library/ Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activesupport-3.0.1/lib/ active_support/dependencies.rb:239) at ActiveSupport::Dependencies::Loadable.require(file:/Library/Tomcat/ apache-tomcat-6.0.29/webapps/RSM/WEB-INF/lib/jruby-rack-1.0.3.jar!/ jruby/rack/rails.rb:161) at JRuby::Rack::RailsBooter::Rails3Environment.load_environment(file:/ Library/Tomcat/apache-tomcat-6.0.29/webapps/RSM/WEB-INF/lib/jruby- rack-1.0.3.jar!/jruby/rack/rails.rb:165) at JRuby::Rack::RailsBooter::Rails3Environment.to_app(file:/Library/ Tomcat/apache-tomcat-6.0.29/webapps/RSM/WEB-INF/lib/jruby- rack-1.0.3.jar!/jruby/rack/rails.rb:186) at #<Class:01x49450f34>.new(<script>:2) at (unknown).(unknown)(file:/Library/Tomcat/apache-tomcat-6.0.29/ webapps/RSM/WEB-INF/lib/jruby-rack-1.0.3.jar!/vendor/rack-1.2.1/rack/ builder.rb:46) at Kernel.instance_eval(file:/Library/Tomcat/apache-tomcat-6.0.29/ webapps/RSM/WEB-INF/lib/jruby-rack-1.0.3.jar!/vendor/rack-1.2.1/rack/ builder.rb:46) at Kernel.instance_eval(file:/Library/Tomcat/apache-tomcat-6.0.29/ webapps/RSM/WEB-INF/lib/jruby-rack-1.0.3.jar!/vendor/rack-1.2.1/rack/ builder.rb:46) at Rack::Builder.initialize(<script>:2) at (unknown).new(<script>:2) at (unknown).(unknown)(:1) Thanks. On Nov 1, 7:48 pm, mkristian <meier.krist...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> first I have to mention warble produces a production environment, so > maybe you need to somehting like > $ jruby -S rake :db:setup > > then you can use the ruby-maven gem > $ jruby -S gem install ruby-maven --pre > which comes with jetty setup which you can just start with > $ jetty-run > and this runs in development mode or for production > $ jetty-run -e production > and of course to compare you should also see that webrick works in > production mode > $ jruby rails s -e production > and then with the ruby-maven gem you can produces another warfile > which might be slightly different from what warble produces (target/ > XZY.war): > $ rmvn package > > with this we should be able to see whether this is tomcat or the > servlet stack as such (since we can compare it jetty). is that all the > stacktrace you get, can you increase logging on production - maybe > there is more to see. > > let''s see if this helps to narrow down the issue > > regards, Kristian > > On Nov 2, 7:06 am, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote: > > > Thanks for your help so far Kristan. I''ve put the entries that you > > suggested into my Gemfile and redeployed to Tomcat but I still get the > > following error back. > > SEVERE: Application Error > > org.jruby.rack.RackInitializationException: 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 > > > When I deploy this under the WEBrick server it runs fine (although I > > not creating a war file for the WEBrick server). > > Is there anyway to ensure that the deployed war file is using the same > > stack as my development environment? > > Thanks. > > > On Nov 1, 1:21 pm, mkristian <meier.krist...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > my typical Gemfile starts like this and works without a problem with > > > jetty and your error does not look tomcat-related. I would not use > > > config.gems just add the gems you need in Gemfile. > > > > # -*- mode: ruby -*- > > > source ''http://rubygems.org'' > > > > gem ''rails'', ''3.0.0'' > > > > # Bundle edge Rails instead: > > > # gem ''rails'', :git => ''git://github.com/rails/rails.git'' > > > > gem ''mysql2'', :require => ''sqlite3'' unless defined?(JRUBY_VERSION) > > > gem "activerecord-jdbc-adapter" if defined?(JRUBY_VERSION) > > > gem "jdbc-mysql", :require => false if defined?(JRUBY_VERSION) > > > > in my Gemfile.lock I see > > > activerecord-jdbc-adapter (0.9.4-java) > > > > maybe that setup helps. > > > regards, Kristian > > > > On Nov 1, 9:47 am, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote: > > > > > I setup the war file with warbler. Here''s the Gemfile: > > > > > source ''http://rubygems.org'' > > > > gem ''rails'', ''3.0.1'' > > > > > # Bundle edge Rails instead: > > > > # gem ''rails'', :git => ''git://github.com/rails/rails.git'' > > > > > #gem ''sqlite3-ruby'', :require => ''sqlite3'' > > > > gem "activerecord-jdbcmysql-adapter", ''1.0.2'', :require =>''arjdbc'' if > > > > defined?(JRUBY_VERSION) > > > > > # Use unicorn as the web server > > > > # gem ''unicorn'' > > > > > # Deploy with Capistrano > > > > # gem ''capistrano'' > > > > > # To use debugger > > > > # gem ''ruby-debug'' > > > > > # Bundle the extra gems: > > > > # gem ''bj'' > > > > # gem ''nokogiri'' > > > > # gem ''sqlite3-ruby'', :require => ''sqlite3'' > > > > # gem ''aws-s3'', :require => ''aws/s3'' > > > > > # Bundle gems for the local environment. Make sure to > > > > # put test-only gems in this group so their generators > > > > # and rake tasks are available in development mode: > > > > # group :development, :test do > > > > # gem ''webrat'' > > > > # end > > > > > In the config/warbler.rb file I also have the following line > > > > uncommented: > > > > > config.gems += ["activerecord-jdbcmysql-adapter", "jruby-openssl"] > > > > > Also, the "jruby -S rails server" command brings up the WEBrick > > > > server not Tomcat. > > > > I propose to run Tomcat in the production environment. > > > > > On Oct 31, 12:49 am, mkristian <meier.krist...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > > > can you run > > > > > $ jruby -S rails server > > > > > ? > > > > > how does your Gemfile look like ? > > > > > how do you setup your war files ? with warbler ? > > > > > > regards, Kristian > > > > > > On Oct 30, 6:21 am, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote: > > > > > > > Hi, > > > > > > I''ve been trying to get JRuby 1.5.3 with Rails 3 to run on the Tomcat6 > > > > > > server with little success. > > > > > > Has anyone been able to do this? If so, what issues did you have to > > > > > > overcome to get this to work? > > > > > > Also, is this a combination that you would recommend for a production > > > > > > site, or is it all too new and untested? > > > > > > The latest issue I''m stuck on right now is with the mysql-connector- > > > > > > java-5.0.4 which comes with jruby 1.5.3 which keeps returning > > > > > > JDBCError: Generated keys not requested. > > > > > > Any feedback on this 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org 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.
from the stacktrace I see that it tries to create a new artist on startup. is this done somehow in an initializer or some so ? the actual error says that the autoincremented ids are not handled correctly. since you say it works with development webrick, it is not config problem as such. but you need to make sure that webrick against the production DB works: $ jruby -S rails server -r production regards Kristian PS still do not believe it is related to the servlet/tomcat as such On Nov 2, 8:32 am, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote:> I''ll go ahead and complete the process that you''ve outlined and see if > I can narrow it down. > In the meantime here''s the complete trace of the error. > > Nov 1, 2010 7:10:45 PM org.apache.catalina.core.ApplicationContext log > SEVERE: Application Error > org.jruby.rack.RackInitializationException: 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 > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/adapter.rb:178:in `execute'' > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > jdbc-adapter-1.0.2-java/lib/arjdbc/mysql/adapter.rb:14:in > `configure_connection'' > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > jdbc-adapter-1.0.2-java/lib/arjdbc/mysql/adapter.rb:385:in > `initialize'' > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/connection_methods.rb:6:in > `new'' > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/connection_methods.rb:6:in > `jdbc_connection'' > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > jdbc-adapter-1.0.2-java/lib/arjdbc/mysql/connection_methods.rb:18:in > `mysql_connection'' > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > activerecord-3.0.1/lib/active_record/connection_adapters/abstract/ > connection_pool.rb:230:in `new_connection'' > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > activerecord-3.0.1/lib/active_record/connection_adapters/abstract/ > connection_pool.rb:238:in `checkout_new_connection'' > ... 50 levels... > from file:/Library/Tomcat/apache-tomcat-6.0.29/webapps/RSM/WEB-INF/ > lib/jruby-rack-1.0.3.jar!/vendor/rack-1.2.1/rack/builder.rb:46:in > `initialize'' > from <script>:2:in `new'' > from <script>:2 > > at org.jruby.rack.DefaultRackApplicationFactory > $4.init(DefaultRackApplicationFactory.java:184) > at > org.jruby.rack.DefaultRackApplicationFactory.getApplication(DefaultRackApplicationFactory.java: > 59) > at > org.jruby.rack.PoolingRackApplicationFactory.getApplication(PoolingRackApplicationFactory.java: > 94) > at > org.jruby.rack.servlet.DefaultServletDispatcher.process(DefaultServletDispatcher.java: > 36) > at org.jruby.rack.RackFilter.doFilter(RackFilter.java:59) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: > 235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: > 206) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: > 233) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: > 191) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: > 127) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: > 102) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: > 109) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: > 298) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: > 857) > at org.apache.coyote.http11.Http11Protocol > $Http11ConnectionHandler.process(Http11Protocol.java:588) > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java: > 489) > at java.lang.Thread.run(Thread.java:680) > Caused by: org.jruby.exceptions.RaiseException: > 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 > at Kernel.raise(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > activerecord-3.0.1/lib/active_record/connection_adapters/ > abstract_adapter.rb:202) > at ActiveRecord::ConnectionAdapters::AbstractAdapter.log(/Library/ > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-jdbc- > adapter-1.0.2-java/lib/arjdbc/jdbc/adapter.rb:178) > at ActiveRecord::ConnectionAdapters::JdbcAdapter.execute(/Library/ > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-jdbc- > adapter-1.0.2-java/lib/arjdbc/mysql/adapter.rb:14) > at ArJdbc::MySQL.configure_connection(/Library/Tomcat/Home/webapps/ > RSM/WEB-INF/gems/gems/activerecord-jdbc-adapter-1.0.2-java/lib/arjdbc/ > mysql/adapter.rb:385) > at ActiveRecord::ConnectionAdapters::MysqlAdapter.initialize(/Library/ > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-jdbc- > adapter-1.0.2-java/lib/arjdbc/jdbc/connection_methods.rb:6) > at (unknown).new(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > activerecord-jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/ > connection_methods.rb:6) > at #<Class:01x1aff2be8>.jdbc_connection(/Library/Tomcat/Home/webapps/ > RSM/WEB-INF/gems/gems/activerecord-jdbc-adapter-1.0.2-java/lib/arjdbc/ > mysql/connection_methods.rb:18) > at #<Class:01x1aff2be8>.mysql_connection(/Library/Tomcat/Home/webapps/ > RSM/WEB-INF/gems/gems/activerecord-3.0.1/lib/active_record/ > connection_adapters/abstract/connection_pool.rb:230) > at ActiveRecord::ConnectionAdapters::ConnectionPool.new_connection(/ > Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/ > lib/active_record/connection_adapters/abstract/connection_pool.rb:238) > at > ActiveRecord::ConnectionAdapters::ConnectionPool.checkout_new_connection(/ > Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/ > lib/active_record/connection_adapters/abstract/connection_pool.rb:194) > at ActiveRecord::ConnectionAdapters::ConnectionPool.checkout(/Library/ > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/lib/ > active_record/connection_adapters/abstract/connection_pool.rb:190) > at Kernel.loop(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > activerecord-3.0.1/lib/active_record/connection_adapters/abstract/ > connection_pool.rb:190) > at ActiveRecord::ConnectionAdapters::ConnectionPool.checkout(file:/ > Library/Tomcat/apache-tomcat-6.0.29/webapps/RSM/WEB-INF/lib/jruby- > stdlib-1.5.3.jar!/META-INF/jruby.home/lib/ruby/1.8/monitor.rb:191) > at MonitorMixin.mon_synchronize(/Library/Tomcat/Home/webapps/RSM/WEB- > INF/gems/gems/activerecord-3.0.1/lib/active_record/connection_adapters/ > abstract/connection_pool.rb:189) > at ActiveRecord::ConnectionAdapters::ConnectionPool.checkout(/Library/ > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/lib/ > active_record/connection_adapters/abstract/connection_pool.rb:96) > at ActiveRecord::ConnectionAdapters::ConnectionPool.connection(/ > Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/ > lib/active_record/connection_adapters/abstract/connection_pool.rb:318) > at > ActiveRecord::ConnectionAdapters::ConnectionHandler.retrieve_connection(/ > Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/ > lib/active_record/connection_adapters/abstract/ > connection_specification.rb:97) > at #<Class:01x1aff2be8>.retrieve_connection(/Library/Tomcat/Home/ > webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/lib/active_record/ > connection_adapters/abstract/connection_specification.rb:89) > at #<Class:01x1aff2be8>.connection(/Library/Tomcat/Home/webapps/RSM/ > WEB-INF/gems/gems/arel-1.0.1/lib/arel/engines/sql/engine.rb:9) > at Arel::Sql::Engine.connection(/Library/Tomcat/Home/webapps/RSM/WEB- > INF/gems/gems/arel-1.0.1/lib/arel/engines/sql/relations/table.rb:37) > at Arel::Table.initialize(/Library/Tomcat/Home/webapps/RSM/WEB-INF/ > gems/gems/activerecord-3.0.1/lib/active_record/base.rb:850) > at (unknown).new(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > activerecord-3.0.1/lib/active_record/base.rb:850) > at #<Class:01x1aff2be8>.arel_table(/Library/Tomcat/Home/webapps/RSM/ > WEB-INF/gems/gems/activerecord-3.0.1/lib/active_record/base.rb:896) > at #<Class:01x1aff2be8>.relation(/Library/Tomcat/Home/webapps/RSM/WEB- > INF/gems/gems/activerecord-3.0.1/lib/active_record/named_scope.rb:32) > at ActiveRecord::NamedScope::ClassMethods.scoped(/Library/Tomcat/Home/ > webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/lib/active_record/ > base.rb:441) > at #<Class:01x1aff2be8>.limit(/Library/Tomcat/apache-tomcat-6.0.29/ > webapps/RSM/WEB-INF/app/models/artist.rb:5) > at (unknown).(unknown)(/Library/Tomcat/apache-tomcat-6.0.29/webapps/ > RSM/WEB-INF/app/models/artist.rb:239) > at (unknown).(unknown)(/Library/Tomcat/apache-tomcat-6.0.29/webapps/ > RSM/WEB-INF/app/models/artist.rb:239) > at Kernel.require(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > activesupport-3.0.1/lib/active_support/dependencies.rb:239) > at ActiveSupport::Dependencies::Loadable.require(/Library/Tomcat/Home/ > webapps/RSM/WEB-INF/gems/gems/activesupport-3.0.1/lib/active_support/ > dependencies.rb:227) > at ActiveSupport::Dependencies::Loadable.load_dependency(/Library/ > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activesupport-3.0.1/lib/ > active_support/dependencies.rb:239) > at ActiveSupport::Dependencies::Loadable.require(/Library/Tomcat/Home/ > webapps/RSM/WEB-INF/gems/gems/activesupport-3.0.1/lib/active_support/ > dependencies.rb:346) > at ActiveSupport::Dependencies.require_or_load(/Library/Tomcat/Home/ > webapps/RSM/WEB-INF/gems/gems/activesupport-3.0.1/lib/active_support/ > dependencies.rb:300) > at ActiveSupport::Dependencies.depend_on(/Library/Tomcat/Home/webapps/ > RSM/WEB-INF/gems/gems/activesupport-3.0.1/lib/active_support/ > dependencies.rb:216) > at ActiveSupport::Dependencies::Loadable.require_dependency(/Library/ > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/railties-3.0.1/lib/rails/ > engine.rb:138) > at Rails::Engine.eager_load!(/Library/Tomcat/Home/webapps/RSM/WEB-INF/ > gems/gems/railties-3.0.1/lib/rails/engine.rb:137) > at Array.each(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > railties-3.0.1/lib/rails/engine.rb:137) > at Rails::Engine.eager_load!(/Library/Tomcat/Home/webapps/RSM/WEB-INF/ > gems/gems/railties-3.0.1/lib/rails/engine.rb:135) > at > ... > > read more »-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org 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.
I ran this against the production environment under WEBrick and it works without error. At the console I see the following output. Notice that it still runs the SQL statement: SET SQL_AUTO_IS_NULL=0 But it doesn''t generate the same error that it does when I run it as a war file. $ jruby -S rails server -e production => Booting WEBrick => Rails 3.0.1 application starting in development on http://0.0.0.0:3000 => Call with -d to detach => Ctrl-C to shutdown server [2010-11-02 09:11:50] INFO WEBrick 1.3.1 [2010-11-02 09:11:50] INFO ruby 1.8.7 (2010-09-28) [java] [2010-11-02 09:11:50] INFO WEBrick::HTTPServer#start: pid=46200 port=3000 Started GET "/albums/list" for 0:0:0:0:0:0:0:1%0 at Tue Nov 02 09:12:06 -0700 2010 SQL (1.0ms) SET SQL_AUTO_IS_NULL=0 Processing by AlbumsController#list as HTML Album Load (10.0ms) SELECT `albums`.* FROM `albums` ORDER BY albums.albumTitle ASC Rendered albums/list.html.erb within layouts/application (220.0ms) Completed 200 OK in 490ms (Views: 265.0ms | ActiveRecord: 11.0ms) As for running this with jetty, I did get it installed but I''m not familiar with maven and was not able to find any detailed instructions for running it within the context of a jruby project. i.e. no idea where the pom.xml file goes or what should be in it. The mvn package command just gave me a bunch of errors. On Nov 1, 11:00 pm, mkristian <meier.krist...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> from the stacktrace I see that it tries to create a new artist on > startup. is this done somehow in an initializer or some so ? > > the actual error says that the autoincremented ids are not handled > correctly. since you say it works with development webrick, it is not > config problem as such. but you need to make sure that webrick against > the production DB works: > > $ jruby -S rails server -r production > > regards Kristian > > PS still do not believe it is related to the servlet/tomcat as such > > On Nov 2, 8:32 am, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote: > > > I''ll go ahead and complete the process that you''ve outlined and see if > > I can narrow it down. > > In the meantime here''s the complete trace of the error. > > > Nov 1, 2010 7:10:45 PM org.apache.catalina.core.ApplicationContext log > > SEVERE: Application Error > > org.jruby.rack.RackInitializationException: 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 > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/adapter.rb:178:in `execute'' > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > jdbc-adapter-1.0.2-java/lib/arjdbc/mysql/adapter.rb:14:in > > `configure_connection'' > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > jdbc-adapter-1.0.2-java/lib/arjdbc/mysql/adapter.rb:385:in > > `initialize'' > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/connection_methods.rb:6:in > > `new'' > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/connection_methods.rb:6:in > > `jdbc_connection'' > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > jdbc-adapter-1.0.2-java/lib/arjdbc/mysql/connection_methods.rb:18:in > > `mysql_connection'' > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > activerecord-3.0.1/lib/active_record/connection_adapters/abstract/ > > connection_pool.rb:230:in `new_connection'' > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > activerecord-3.0.1/lib/active_record/connection_adapters/abstract/ > > connection_pool.rb:238:in `checkout_new_connection'' > > ... 50 levels... > > from file:/Library/Tomcat/apache-tomcat-6.0.29/webapps/RSM/WEB-INF/ > > lib/jruby-rack-1.0.3.jar!/vendor/rack-1.2.1/rack/builder.rb:46:in > > `initialize'' > > from <script>:2:in `new'' > > from <script>:2 > > > at org.jruby.rack.DefaultRackApplicationFactory > > $4.init(DefaultRackApplicationFactory.java:184) > > at > > org.jruby.rack.DefaultRackApplicationFactory.getApplication(DefaultRackApplicationFactory.java: > > 59) > > at > > org.jruby.rack.PoolingRackApplicationFactory.getApplication(PoolingRackApplicationFactory.java: > > 94) > > at > > org.jruby.rack.servlet.DefaultServletDispatcher.process(DefaultServletDispatcher.java: > > 36) > > at org.jruby.rack.RackFilter.doFilter(RackFilter.java:59) > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: > > 235) > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: > > 206) > > at > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: > > 233) > > at > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: > > 191) > > at > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: > > 127) > > at > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: > > 102) > > at > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: > > 109) > > at > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: > > 298) > > at > > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: > > 857) > > at org.apache.coyote.http11.Http11Protocol > > $Http11ConnectionHandler.process(Http11Protocol.java:588) > > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java: > > 489) > > at java.lang.Thread.run(Thread.java:680) > > Caused by: org.jruby.exceptions.RaiseException: > > 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 > > at Kernel.raise(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > activerecord-3.0.1/lib/active_record/connection_adapters/ > > abstract_adapter.rb:202) > > at ActiveRecord::ConnectionAdapters::AbstractAdapter.log(/Library/ > > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-jdbc- > > adapter-1.0.2-java/lib/arjdbc/jdbc/adapter.rb:178) > > at ActiveRecord::ConnectionAdapters::JdbcAdapter.execute(/Library/ > > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-jdbc- > > adapter-1.0.2-java/lib/arjdbc/mysql/adapter.rb:14) > > at ArJdbc::MySQL.configure_connection(/Library/Tomcat/Home/webapps/ > > RSM/WEB-INF/gems/gems/activerecord-jdbc-adapter-1.0.2-java/lib/arjdbc/ > > mysql/adapter.rb:385) > > at ActiveRecord::ConnectionAdapters::MysqlAdapter.initialize(/Library/ > > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-jdbc- > > adapter-1.0.2-java/lib/arjdbc/jdbc/connection_methods.rb:6) > > at (unknown).new(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > activerecord-jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/ > > connection_methods.rb:6) > > at #<Class:01x1aff2be8>.jdbc_connection(/Library/Tomcat/Home/webapps/ > > RSM/WEB-INF/gems/gems/activerecord-jdbc-adapter-1.0.2-java/lib/arjdbc/ > > mysql/connection_methods.rb:18) > > at #<Class:01x1aff2be8>.mysql_connection(/Library/Tomcat/Home/webapps/ > > RSM/WEB-INF/gems/gems/activerecord-3.0.1/lib/active_record/ > > connection_adapters/abstract/connection_pool.rb:230) > > at ActiveRecord::ConnectionAdapters::ConnectionPool.new_connection(/ > > Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/ > > lib/active_record/connection_adapters/abstract/connection_pool.rb:238) > > at > > ActiveRecord::ConnectionAdapters::ConnectionPool.checkout_new_connection(/ > > Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/ > > lib/active_record/connection_adapters/abstract/connection_pool.rb:194) > > at ActiveRecord::ConnectionAdapters::ConnectionPool.checkout(/Library/ > > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/lib/ > > active_record/connection_adapters/abstract/connection_pool.rb:190) > > at Kernel.loop(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > activerecord-3.0.1/lib/active_record/connection_adapters/abstract/ > > connection_pool.rb:190) > > at ActiveRecord::ConnectionAdapters::ConnectionPool.checkout(file:/ > > Library/Tomcat/apache-tomcat-6.0.29/webapps/RSM/WEB-INF/lib/jruby- > > stdlib-1.5.3.jar!/META-INF/jruby.home/lib/ruby/1.8/monitor.rb:191) > > at MonitorMixin.mon_synchronize(/Library/Tomcat/Home/webapps/RSM/WEB- > > INF/gems/gems/activerecord-3.0.1/lib/active_record/connection_adapters/ > > abstract/connection_pool.rb:189) > > at ActiveRecord::ConnectionAdapters::ConnectionPool.checkout(/Library/ > > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/lib/ > > active_record/connection_adapters/abstract/connection_pool.rb:96) > > at ActiveRecord::ConnectionAdapters::ConnectionPool.connection(/ > > Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/ > > lib/active_record/connection_adapters/abstract/connection_pool.rb:318) > > at > > ActiveRecord::ConnectionAdapters::ConnectionHandler.retrieve_connection(/ > > Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/ > > lib/active_record/connection_adapters/abstract/ > > connection_specification.rb:97) > > at #<Class:01x1aff2be8>.retrieve_connection(/Library/Tomcat/Home/ > > webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/lib/active_record/ > > connection_adapters/abstract/connection_specification.rb:89) > > at #<Class:01x1aff2be8>.connection(/Library/Tomcat/Home/webapps/RSM/ > > WEB-INF/gems/gems/arel-1.0.1/lib/arel/engines/sql/engine.rb:9) > > at Arel::Sql::Engine.connection(/Library/Tomcat/Home/webapps/RSM/WEB- > > INF/gems/gems/arel-1.0.1/lib/arel/engines/sql/relations/table.rb:37) > > at Arel::Table.initialize(/Library/Tomcat/Home/webapps/RSM/WEB-INF/ > > gems/gems/activerecord-3.0.1/lib/active_record/base.rb:850) > > at (unknown).new(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > activerecord-3.0.1/lib/active_record/base.rb:850) > > at #<Class:01x1aff2be8>.arel_table(/Library/Tomcat/Home/webapps/RSM/ > > WEB-INF/gems/gems/activerecord-3.0.1/lib/active_record/base.rb:896) > > at #<Class:01x1aff2be8>.relation(/Library/Tomcat/Home/webapps/RSM/WEB- > > INF/gems/gems/activerecord-3.0.1/lib/active_record/named_scope.rb:32) > > at ActiveRecord::NamedScope::ClassMethods.scoped(/Library/Tomcat/Home/ > > webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/lib/active_record/ > > base.rb:441) > > at #<Class:01x1aff2be8>.limit(/Library/Tomcat/apache-tomcat-6.0.29/ > > webapps/RSM/WEB-INF/app/models/artist.rb:5) > > at (unknown).(unknown)(/Library/Tomcat/apache-tomcat-6.0.29/webapps/ > > RSM/WEB-INF/app/models/artist.rb:239) > > at (unknown).(unknown)(/Library/Tomcat/apache-tomcat-6.0.29/webapps/ > > RSM/WEB-INF/app/models/artist.rb:239) > > ... > > read more »-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org 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.
This does seem to be specific to Tomcat. I ran the same war file under the jetty server and it ran without error. I then reran it under Tomcat and I got the SEVERE: Application Error org.jruby.rack.RackInitializationException: 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 error again. On Nov 2, 11:36 am, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote:> I ran this against the production environment under WEBrick and it > works without error. > At the console I see the following output. Notice that it still runs > the SQL statement: SET SQL_AUTO_IS_NULL=0 > But it doesn''t generate the same error that it does when I run it as a > war file. > > $ jruby -S rails server -e production > => Booting WEBrick > => Rails 3.0.1 application starting in development onhttp://0.0.0.0:3000 > => Call with -d to detach > => Ctrl-C to shutdown server > [2010-11-02 09:11:50] INFO WEBrick 1.3.1 > [2010-11-02 09:11:50] INFO ruby 1.8.7 (2010-09-28) [java] > [2010-11-02 09:11:50] INFO WEBrick::HTTPServer#start: pid=46200 > port=3000 > > Started GET "/albums/list" for 0:0:0:0:0:0:0:1%0 at Tue Nov 02 > 09:12:06 -0700 2010 > SQL (1.0ms) SET SQL_AUTO_IS_NULL=0 > Processing by AlbumsController#list as HTML > Album Load (10.0ms) SELECT `albums`.* FROM `albums` ORDER BY > albums.albumTitle ASC > Rendered albums/list.html.erb within layouts/application (220.0ms) > Completed 200 OK in 490ms (Views: 265.0ms | ActiveRecord: 11.0ms) > > As for running this with jetty, I did get it installed but I''m not > familiar with maven and was not able to find any detailed instructions > for running it within the context of a jruby project. i.e. no idea > where the pom.xml file goes or what should be in it. The mvn package > command just gave me a bunch of errors. > > On Nov 1, 11:00 pm, mkristian <meier.krist...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > from the stacktrace I see that it tries to create a new artist on > > startup. is this done somehow in an initializer or some so ? > > > the actual error says that the autoincremented ids are not handled > > correctly. since you say it works with development webrick, it is not > > config problem as such. but you need to make sure that webrick against > > the production DB works: > > > $ jruby -S rails server -r production > > > regards Kristian > > > PS still do not believe it is related to the servlet/tomcat as such > > > On Nov 2, 8:32 am, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote: > > > > I''ll go ahead and complete the process that you''ve outlined and see if > > > I can narrow it down. > > > In the meantime here''s the complete trace of the error. > > > > Nov 1, 2010 7:10:45 PM org.apache.catalina.core.ApplicationContext log > > > SEVERE: Application Error > > > org.jruby.rack.RackInitializationException: 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 > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/adapter.rb:178:in `execute'' > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > jdbc-adapter-1.0.2-java/lib/arjdbc/mysql/adapter.rb:14:in > > > `configure_connection'' > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > jdbc-adapter-1.0.2-java/lib/arjdbc/mysql/adapter.rb:385:in > > > `initialize'' > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/connection_methods.rb:6:in > > > `new'' > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/connection_methods.rb:6:in > > > `jdbc_connection'' > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > jdbc-adapter-1.0.2-java/lib/arjdbc/mysql/connection_methods.rb:18:in > > > `mysql_connection'' > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > > activerecord-3.0.1/lib/active_record/connection_adapters/abstract/ > > > connection_pool.rb:230:in `new_connection'' > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > > activerecord-3.0.1/lib/active_record/connection_adapters/abstract/ > > > connection_pool.rb:238:in `checkout_new_connection'' > > > ... 50 levels... > > > from file:/Library/Tomcat/apache-tomcat-6.0.29/webapps/RSM/WEB-INF/ > > > lib/jruby-rack-1.0.3.jar!/vendor/rack-1.2.1/rack/builder.rb:46:in > > > `initialize'' > > > from <script>:2:in `new'' > > > from <script>:2 > > > > at org.jruby.rack.DefaultRackApplicationFactory > > > $4.init(DefaultRackApplicationFactory.java:184) > > > at > > > org.jruby.rack.DefaultRackApplicationFactory.getApplication(DefaultRackApplicationFactory.java: > > > 59) > > > at > > > org.jruby.rack.PoolingRackApplicationFactory.getApplication(PoolingRackApplicationFactory.java: > > > 94) > > > at > > > org.jruby.rack.servlet.DefaultServletDispatcher.process(DefaultServletDispatcher.java: > > > 36) > > > at org.jruby.rack.RackFilter.doFilter(RackFilter.java:59) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: > > > 235) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: > > > 206) > > > at > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: > > > 233) > > > at > > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: > > > 191) > > > at > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: > > > 127) > > > at > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: > > > 102) > > > at > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: > > > 109) > > > at > > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: > > > 298) > > > at > > > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: > > > 857) > > > at org.apache.coyote.http11.Http11Protocol > > > $Http11ConnectionHandler.process(Http11Protocol.java:588) > > > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java: > > > 489) > > > at java.lang.Thread.run(Thread.java:680) > > > Caused by: org.jruby.exceptions.RaiseException: > > > 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 > > > at Kernel.raise(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > > activerecord-3.0.1/lib/active_record/connection_adapters/ > > > abstract_adapter.rb:202) > > > at ActiveRecord::ConnectionAdapters::AbstractAdapter.log(/Library/ > > > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-jdbc- > > > adapter-1.0.2-java/lib/arjdbc/jdbc/adapter.rb:178) > > > at ActiveRecord::ConnectionAdapters::JdbcAdapter.execute(/Library/ > > > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-jdbc- > > > adapter-1.0.2-java/lib/arjdbc/mysql/adapter.rb:14) > > > at ArJdbc::MySQL.configure_connection(/Library/Tomcat/Home/webapps/ > > > RSM/WEB-INF/gems/gems/activerecord-jdbc-adapter-1.0.2-java/lib/arjdbc/ > > > mysql/adapter.rb:385) > > > at ActiveRecord::ConnectionAdapters::MysqlAdapter.initialize(/Library/ > > > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-jdbc- > > > adapter-1.0.2-java/lib/arjdbc/jdbc/connection_methods.rb:6) > > > at (unknown).new(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > > activerecord-jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/ > > > connection_methods.rb:6) > > > at #<Class:01x1aff2be8>.jdbc_connection(/Library/Tomcat/Home/webapps/ > > > RSM/WEB-INF/gems/gems/activerecord-jdbc-adapter-1.0.2-java/lib/arjdbc/ > > > mysql/connection_methods.rb:18) > > > at #<Class:01x1aff2be8>.mysql_connection(/Library/Tomcat/Home/webapps/ > > > RSM/WEB-INF/gems/gems/activerecord-3.0.1/lib/active_record/ > > > connection_adapters/abstract/connection_pool.rb:230) > > > at ActiveRecord::ConnectionAdapters::ConnectionPool.new_connection(/ > > > Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/ > > > lib/active_record/connection_adapters/abstract/connection_pool.rb:238) > > > at > > > ActiveRecord::ConnectionAdapters::ConnectionPool.checkout_new_connection(/ > > > Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/ > > > lib/active_record/connection_adapters/abstract/connection_pool.rb:194) > > > at ActiveRecord::ConnectionAdapters::ConnectionPool.checkout(/Library/ > > > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/lib/ > > > active_record/connection_adapters/abstract/connection_pool.rb:190) > > > at Kernel.loop(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > > activerecord-3.0.1/lib/active_record/connection_adapters/abstract/ > > > connection_pool.rb:190) > > > at ActiveRecord::ConnectionAdapters::ConnectionPool.checkout(file:/ > > > Library/Tomcat/apache-tomcat-6.0.29/webapps/RSM/WEB-INF/lib/jruby- > > > stdlib-1.5.3.jar!/META-INF/jruby.home/lib/ruby/1.8/monitor.rb:191) > > > at MonitorMixin.mon_synchronize(/Library/Tomcat/Home/webapps/RSM/WEB- > > > INF/gems/gems/activerecord-3.0.1/lib/active_record/connection_adapters/ > > > abstract/connection_pool.rb:189) > > > at ActiveRecord::ConnectionAdapters::ConnectionPool.checkout(/Library/ > > > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/lib/ > > > active_record/connection_adapters/abstract/connection_pool.rb:96) > > > at ActiveRecord::ConnectionAdapters::ConnectionPool.connection(/ > > > Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/ > > > lib/active_record/connection_adapters/abstract/connection_pool.rb:318) > > > at > > > ActiveRecord::ConnectionAdapters::ConnectionHandler.retrieve_connection(/ > > > Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/ > > ... > > read more »-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org 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.
OK - it is somehow related with your tomcat setup. my application works with tomcat6 as well with jetty. I also found your previous post. which was related to mysql-connector- java-5.1.13-bin.jar my WEB-INF/lib directory from the warfile has only jruby-complete.jar + jruby-rack.jar in it, everything else comes from the gems in WEB-INF/ gems. next thought is that the tomcat has mysql-connector-java-5.1.13- bin.jar in shared lib for warfiles ? with regards, Kristian On Nov 2, 11:51 pm, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote:> This does seem to be specific to Tomcat. I ran the same war file > under the jetty server and it ran without error. > I then reran it under Tomcat and I got the > > SEVERE: Application Error > org.jruby.rack.RackInitializationException: 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 > > error again. > > On Nov 2, 11:36 am, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote: > > > I ran this against the production environment under WEBrick and it > > works without error. > > At the console I see the following output. Notice that it still runs > > the SQL statement: SET SQL_AUTO_IS_NULL=0 > > But it doesn''t generate the same error that it does when I run it as a > > war file. > > > $ jruby -S rails server -e production > > => Booting WEBrick > > => Rails 3.0.1 application starting in development onhttp://0.0.0.0:3000 > > => Call with -d to detach > > => Ctrl-C to shutdown server > > [2010-11-02 09:11:50] INFO WEBrick 1.3.1 > > [2010-11-02 09:11:50] INFO ruby 1.8.7 (2010-09-28) [java] > > [2010-11-02 09:11:50] INFO WEBrick::HTTPServer#start: pid=46200 > > port=3000 > > > Started GET "/albums/list" for 0:0:0:0:0:0:0:1%0 at Tue Nov 02 > > 09:12:06 -0700 2010 > > SQL (1.0ms) SET SQL_AUTO_IS_NULL=0 > > Processing by AlbumsController#list as HTML > > Album Load (10.0ms) SELECT `albums`.* FROM `albums` ORDER BY > > albums.albumTitle ASC > > Rendered albums/list.html.erb within layouts/application (220.0ms) > > Completed 200 OK in 490ms (Views: 265.0ms | ActiveRecord: 11.0ms) > > > As for running this with jetty, I did get it installed but I''m not > > familiar with maven and was not able to find any detailed instructions > > for running it within the context of a jruby project. i.e. no idea > > where the pom.xml file goes or what should be in it. The mvn package > > command just gave me a bunch of errors. > > > On Nov 1, 11:00 pm, mkristian <meier.krist...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > from the stacktrace I see that it tries to create a new artist on > > > startup. is this done somehow in an initializer or some so ? > > > > the actual error says that the autoincremented ids are not handled > > > correctly. since you say it works with development webrick, it is not > > > config problem as such. but you need to make sure that webrick against > > > the production DB works: > > > > $ jruby -S rails server -r production > > > > regards Kristian > > > > PS still do not believe it is related to the servlet/tomcat as such > > > > On Nov 2, 8:32 am, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote: > > > > > I''ll go ahead and complete the process that you''ve outlined and see if > > > > I can narrow it down. > > > > In the meantime here''s the complete trace of the error. > > > > > Nov 1, 2010 7:10:45 PM org.apache.catalina.core.ApplicationContext log > > > > SEVERE: Application Error > > > > org.jruby.rack.RackInitializationException: 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 > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > > jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/adapter.rb:178:in `execute'' > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > > jdbc-adapter-1.0.2-java/lib/arjdbc/mysql/adapter.rb:14:in > > > > `configure_connection'' > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > > jdbc-adapter-1.0.2-java/lib/arjdbc/mysql/adapter.rb:385:in > > > > `initialize'' > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > > jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/connection_methods.rb:6:in > > > > `new'' > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > > jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/connection_methods.rb:6:in > > > > `jdbc_connection'' > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > > jdbc-adapter-1.0.2-java/lib/arjdbc/mysql/connection_methods.rb:18:in > > > > `mysql_connection'' > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > > > activerecord-3.0.1/lib/active_record/connection_adapters/abstract/ > > > > connection_pool.rb:230:in `new_connection'' > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > > > activerecord-3.0.1/lib/active_record/connection_adapters/abstract/ > > > > connection_pool.rb:238:in `checkout_new_connection'' > > > > ... 50 levels... > > > > from file:/Library/Tomcat/apache-tomcat-6.0.29/webapps/RSM/WEB-INF/ > > > > lib/jruby-rack-1.0.3.jar!/vendor/rack-1.2.1/rack/builder.rb:46:in > > > > `initialize'' > > > > from <script>:2:in `new'' > > > > from <script>:2 > > > > > at org.jruby.rack.DefaultRackApplicationFactory > > > > $4.init(DefaultRackApplicationFactory.java:184) > > > > at > > > > org.jruby.rack.DefaultRackApplicationFactory.getApplication(DefaultRackApplicationFactory.java: > > > > 59) > > > > at > > > > org.jruby.rack.PoolingRackApplicationFactory.getApplication(PoolingRackApplicationFactory.java: > > > > 94) > > > > at > > > > org.jruby.rack.servlet.DefaultServletDispatcher.process(DefaultServletDispatcher.java: > > > > 36) > > > > at org.jruby.rack.RackFilter.doFilter(RackFilter.java:59) > > > > at > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: > > > > 235) > > > > at > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: > > > > 206) > > > > at > > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: > > > > 233) > > > > at > > > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: > > > > 191) > > > > at > > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: > > > > 127) > > > > at > > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: > > > > 102) > > > > at > > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: > > > > 109) > > > > at > > > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: > > > > 298) > > > > at > > > > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: > > > > 857) > > > > at org.apache.coyote.http11.Http11Protocol > > > > $Http11ConnectionHandler.process(Http11Protocol.java:588) > > > > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java: > > > > 489) > > > > at java.lang.Thread.run(Thread.java:680) > > > > Caused by: org.jruby.exceptions.RaiseException: > > > > 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 > > > > at Kernel.raise(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > > > activerecord-3.0.1/lib/active_record/connection_adapters/ > > > > abstract_adapter.rb:202) > > > > at ActiveRecord::ConnectionAdapters::AbstractAdapter.log(/Library/ > > > > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-jdbc- > > > > adapter-1.0.2-java/lib/arjdbc/jdbc/adapter.rb:178) > > > > at ActiveRecord::ConnectionAdapters::JdbcAdapter.execute(/Library/ > > > > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-jdbc- > > > > adapter-1.0.2-java/lib/arjdbc/mysql/adapter.rb:14) > > > > at ArJdbc::MySQL.configure_connection(/Library/Tomcat/Home/webapps/ > > > > RSM/WEB-INF/gems/gems/activerecord-jdbc-adapter-1.0.2-java/lib/arjdbc/ > > > > mysql/adapter.rb:385) > > > > at ActiveRecord::ConnectionAdapters::MysqlAdapter.initialize(/Library/ > > > > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-jdbc- > > > > adapter-1.0.2-java/lib/arjdbc/jdbc/connection_methods.rb:6) > > > > at (unknown).new(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > > > activerecord-jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/ > > > > connection_methods.rb:6) > > > > at #<Class:01x1aff2be8>.jdbc_connection(/Library/Tomcat/Home/webapps/ > > > > RSM/WEB-INF/gems/gems/activerecord-jdbc-adapter-1.0.2-java/lib/arjdbc/ > > > > mysql/connection_methods.rb:18) > > > > at #<Class:01x1aff2be8>.mysql_connection(/Library/Tomcat/Home/webapps/ > > > > RSM/WEB-INF/gems/gems/activerecord-3.0.1/lib/active_record/ > > > > connection_adapters/abstract/connection_pool.rb:230) > > > > at ActiveRecord::ConnectionAdapters::ConnectionPool.new_connection(/ > > > > Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/ > > > > lib/active_record/connection_adapters/abstract/connection_pool.rb:238) > > > > at > > > > ActiveRecord::ConnectionAdapters::ConnectionPool.checkout_new_connection(/ > > > > Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/ > > > > lib/active_record/connection_adapters/abstract/connection_pool.rb:194) > > > > at ActiveRecord::ConnectionAdapters::ConnectionPool.checkout(/Library/ > > > > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/lib/ > > > > active_record/connection_adapters/abstract/connection_pool.rb:190) > > > > at Kernel.loop(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > > > activerecord-3.0.1/lib/active_record/connection_adapters/abstract/ > > > > connection_pool.rb:190) > > > > at ActiveRecord::ConnectionAdapters::ConnectionPool.checkout(file:/ > > > > Library/Tomcat/apache-tomcat-6.0.29/webapps/RSM/WEB-INF/lib/jruby- > > ... > > read more »-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org 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.
OK, based on your previous email I''ve finally gotten to the bottom of this. I found a mysql-connector-java-5.1.13-bin.jar file in my $CATALINA_HOME/lib directory. After removing that file the error went away. Kristian, Thank you very much for helping me solve this problem. On Nov 2, 1:33 pm, mkristian <meier.krist...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> OK - it is somehow related with your tomcat setup. > > my application works with tomcat6 as well with jetty. > > I also found your previous post. which was related to mysql-connector- > java-5.1.13-bin.jar > > my WEB-INF/lib directory from the warfile has only jruby-complete.jar > + jruby-rack.jar in it, everything else comes from the gems in WEB-INF/ > gems. > > next thought is that the tomcat has mysql-connector-java-5.1.13- > bin.jar in shared lib for warfiles ? > > with regards, Kristian > > On Nov 2, 11:51 pm, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote: > > > This does seem to be specific to Tomcat. I ran the same war file > > under the jetty server and it ran without error. > > I then reran it under Tomcat and I got the > > > SEVERE: Application Error > > org.jruby.rack.RackInitializationException: 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 > > > error again. > > > On Nov 2, 11:36 am, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote: > > > > I ran this against the production environment under WEBrick and it > > > works without error. > > > At the console I see the following output. Notice that it still runs > > > the SQL statement: SET SQL_AUTO_IS_NULL=0 > > > But it doesn''t generate the same error that it does when I run it as a > > > war file. > > > > $ jruby -S rails server -e production > > > => Booting WEBrick > > > => Rails 3.0.1 application starting in development onhttp://0.0.0.0:3000 > > > => Call with -d to detach > > > => Ctrl-C to shutdown server > > > [2010-11-02 09:11:50] INFO WEBrick 1.3.1 > > > [2010-11-02 09:11:50] INFO ruby 1.8.7 (2010-09-28) [java] > > > [2010-11-02 09:11:50] INFO WEBrick::HTTPServer#start: pid=46200 > > > port=3000 > > > > Started GET "/albums/list" for 0:0:0:0:0:0:0:1%0 at Tue Nov 02 > > > 09:12:06 -0700 2010 > > > SQL (1.0ms) SET SQL_AUTO_IS_NULL=0 > > > Processing by AlbumsController#list as HTML > > > Album Load (10.0ms) SELECT `albums`.* FROM `albums` ORDER BY > > > albums.albumTitle ASC > > > Rendered albums/list.html.erb within layouts/application (220.0ms) > > > Completed 200 OK in 490ms (Views: 265.0ms | ActiveRecord: 11.0ms) > > > > As for running this with jetty, I did get it installed but I''m not > > > familiar with maven and was not able to find any detailed instructions > > > for running it within the context of a jruby project. i.e. no idea > > > where the pom.xml file goes or what should be in it. The mvn package > > > command just gave me a bunch of errors. > > > > On Nov 1, 11:00 pm, mkristian <meier.krist...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > > from the stacktrace I see that it tries to create a new artist on > > > > startup. is this done somehow in an initializer or some so ? > > > > > the actual error says that the autoincremented ids are not handled > > > > correctly. since you say it works with development webrick, it is not > > > > config problem as such. but you need to make sure that webrick against > > > > the production DB works: > > > > > $ jruby -S rails server -r production > > > > > regards Kristian > > > > > PS still do not believe it is related to the servlet/tomcat as such > > > > > On Nov 2, 8:32 am, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote: > > > > > > I''ll go ahead and complete the process that you''ve outlined and see if > > > > > I can narrow it down. > > > > > In the meantime here''s the complete trace of the error. > > > > > > Nov 1, 2010 7:10:45 PM org.apache.catalina.core.ApplicationContext log > > > > > SEVERE: Application Error > > > > > org.jruby.rack.RackInitializationException: 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 > > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > > > jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/adapter.rb:178:in `execute'' > > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > > > jdbc-adapter-1.0.2-java/lib/arjdbc/mysql/adapter.rb:14:in > > > > > `configure_connection'' > > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > > > jdbc-adapter-1.0.2-java/lib/arjdbc/mysql/adapter.rb:385:in > > > > > `initialize'' > > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > > > jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/connection_methods.rb:6:in > > > > > `new'' > > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > > > jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/connection_methods.rb:6:in > > > > > `jdbc_connection'' > > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > > > jdbc-adapter-1.0.2-java/lib/arjdbc/mysql/connection_methods.rb:18:in > > > > > `mysql_connection'' > > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > > > > activerecord-3.0.1/lib/active_record/connection_adapters/abstract/ > > > > > connection_pool.rb:230:in `new_connection'' > > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > > > > activerecord-3.0.1/lib/active_record/connection_adapters/abstract/ > > > > > connection_pool.rb:238:in `checkout_new_connection'' > > > > > ... 50 levels... > > > > > from file:/Library/Tomcat/apache-tomcat-6.0.29/webapps/RSM/WEB-INF/ > > > > > lib/jruby-rack-1.0.3.jar!/vendor/rack-1.2.1/rack/builder.rb:46:in > > > > > `initialize'' > > > > > from <script>:2:in `new'' > > > > > from <script>:2 > > > > > > at org.jruby.rack.DefaultRackApplicationFactory > > > > > $4.init(DefaultRackApplicationFactory.java:184) > > > > > at > > > > > org.jruby.rack.DefaultRackApplicationFactory.getApplication(DefaultRackApplicationFactory.java: > > > > > 59) > > > > > at > > > > > org.jruby.rack.PoolingRackApplicationFactory.getApplication(PoolingRackApplicationFactory.java: > > > > > 94) > > > > > at > > > > > org.jruby.rack.servlet.DefaultServletDispatcher.process(DefaultServletDispatcher.java: > > > > > 36) > > > > > at org.jruby.rack.RackFilter.doFilter(RackFilter.java:59) > > > > > at > > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: > > > > > 235) > > > > > at > > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: > > > > > 206) > > > > > at > > > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: > > > > > 233) > > > > > at > > > > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: > > > > > 191) > > > > > at > > > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: > > > > > 127) > > > > > at > > > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: > > > > > 102) > > > > > at > > > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: > > > > > 109) > > > > > at > > > > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: > > > > > 298) > > > > > at > > > > > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: > > > > > 857) > > > > > at org.apache.coyote.http11.Http11Protocol > > > > > $Http11ConnectionHandler.process(Http11Protocol.java:588) > > > > > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java: > > > > > 489) > > > > > at java.lang.Thread.run(Thread.java:680) > > > > > Caused by: org.jruby.exceptions.RaiseException: > > > > > 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 > > > > > at Kernel.raise(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > > > > activerecord-3.0.1/lib/active_record/connection_adapters/ > > > > > abstract_adapter.rb:202) > > > > > at ActiveRecord::ConnectionAdapters::AbstractAdapter.log(/Library/ > > > > > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-jdbc- > > > > > adapter-1.0.2-java/lib/arjdbc/jdbc/adapter.rb:178) > > > > > at ActiveRecord::ConnectionAdapters::JdbcAdapter.execute(/Library/ > > > > > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-jdbc- > > > > > adapter-1.0.2-java/lib/arjdbc/mysql/adapter.rb:14) > > > > > at ArJdbc::MySQL.configure_connection(/Library/Tomcat/Home/webapps/ > > > > > RSM/WEB-INF/gems/gems/activerecord-jdbc-adapter-1.0.2-java/lib/arjdbc/ > > > > > mysql/adapter.rb:385) > > > > > at ActiveRecord::ConnectionAdapters::MysqlAdapter.initialize(/Library/ > > > > > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-jdbc- > > > > > adapter-1.0.2-java/lib/arjdbc/jdbc/connection_methods.rb:6) > > > > > at (unknown).new(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > > > > activerecord-jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/ > > > > > connection_methods.rb:6) > > > > > at #<Class:01x1aff2be8>.jdbc_connection(/Library/Tomcat/Home/webapps/ > > > > > RSM/WEB-INF/gems/gems/activerecord-jdbc-adapter-1.0.2-java/lib/arjdbc/ > > > > > mysql/connection_methods.rb:18) > > > > > at #<Class:01x1aff2be8>.mysql_connection(/Library/Tomcat/Home/webapps/ > > > > > RSM/WEB-INF/gems/gems/activerecord-3.0.1/lib/active_record/ > > > > > connection_adapters/abstract/connection_pool.rb:230) > > > > > at ActiveRecord::ConnectionAdapters::ConnectionPool.new_connection(/ > > > > > Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-3.0.1/ > > > > > lib/active_record/connection_adapters/abstract/connection_pool.rb:238) > > > > > at > > ... > > read more »-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org 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.
great. and actually it is a drawback that you can not share jdbc drivers between applications when using rails in at one application. maybe future versions of jruby will allow this. regards Kristian On Nov 3, 3:14 am, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote:> OK, based on your previous email I''ve finally gotten to the bottom of > this. > I found a mysql-connector-java-5.1.13-bin.jar file in my > $CATALINA_HOME/lib directory. > After removing that file the error went away. > Kristian, Thank you very much for helping me solve this problem. > > On Nov 2, 1:33 pm, mkristian <meier.krist...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > OK - it is somehow related with your tomcat setup. > > > my application works with tomcat6 as well with jetty. > > > I also found your previous post. which was related to mysql-connector- > > java-5.1.13-bin.jar > > > my WEB-INF/lib directory from the warfile has only jruby-complete.jar > > + jruby-rack.jar in it, everything else comes from the gems in WEB-INF/ > > gems. > > > next thought is that the tomcat has mysql-connector-java-5.1.13- > > bin.jar in shared lib for warfiles ? > > > with regards, Kristian > > > On Nov 2, 11:51 pm, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote: > > > > This does seem to be specific to Tomcat. I ran the same war file > > > under the jetty server and it ran without error. > > > I then reran it under Tomcat and I got the > > > > SEVERE: Application Error > > > org.jruby.rack.RackInitializationException: 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 > > > > error again. > > > > On Nov 2, 11:36 am, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote: > > > > > I ran this against the production environment under WEBrick and it > > > > works without error. > > > > At the console I see the following output. Notice that it still runs > > > > the SQL statement: SET SQL_AUTO_IS_NULL=0 > > > > But it doesn''t generate the same error that it does when I run it as a > > > > war file. > > > > > $ jruby -S rails server -e production > > > > => Booting WEBrick > > > > => Rails 3.0.1 application starting in development onhttp://0.0.0.0:3000 > > > > => Call with -d to detach > > > > => Ctrl-C to shutdown server > > > > [2010-11-02 09:11:50] INFO WEBrick 1.3.1 > > > > [2010-11-02 09:11:50] INFO ruby 1.8.7 (2010-09-28) [java] > > > > [2010-11-02 09:11:50] INFO WEBrick::HTTPServer#start: pid=46200 > > > > port=3000 > > > > > Started GET "/albums/list" for 0:0:0:0:0:0:0:1%0 at Tue Nov 02 > > > > 09:12:06 -0700 2010 > > > > SQL (1.0ms) SET SQL_AUTO_IS_NULL=0 > > > > Processing by AlbumsController#list as HTML > > > > Album Load (10.0ms) SELECT `albums`.* FROM `albums` ORDER BY > > > > albums.albumTitle ASC > > > > Rendered albums/list.html.erb within layouts/application (220.0ms) > > > > Completed 200 OK in 490ms (Views: 265.0ms | ActiveRecord: 11.0ms) > > > > > As for running this with jetty, I did get it installed but I''m not > > > > familiar with maven and was not able to find any detailed instructions > > > > for running it within the context of a jruby project. i.e. no idea > > > > where the pom.xml file goes or what should be in it. The mvn package > > > > command just gave me a bunch of errors. > > > > > On Nov 1, 11:00 pm, mkristian <meier.krist...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > > > from the stacktrace I see that it tries to create a new artist on > > > > > startup. is this done somehow in an initializer or some so ? > > > > > > the actual error says that the autoincremented ids are not handled > > > > > correctly. since you say it works with development webrick, it is not > > > > > config problem as such. but you need to make sure that webrick against > > > > > the production DB works: > > > > > > $ jruby -S rails server -r production > > > > > > regards Kristian > > > > > > PS still do not believe it is related to the servlet/tomcat as such > > > > > > On Nov 2, 8:32 am, MJW2529 <mjwhite2...-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote: > > > > > > > I''ll go ahead and complete the process that you''ve outlined and see if > > > > > > I can narrow it down. > > > > > > In the meantime here''s the complete trace of the error. > > > > > > > Nov 1, 2010 7:10:45 PM org.apache.catalina.core.ApplicationContext log > > > > > > SEVERE: Application Error > > > > > > org.jruby.rack.RackInitializationException: 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 > > > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > > > > jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/adapter.rb:178:in `execute'' > > > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > > > > jdbc-adapter-1.0.2-java/lib/arjdbc/mysql/adapter.rb:14:in > > > > > > `configure_connection'' > > > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > > > > jdbc-adapter-1.0.2-java/lib/arjdbc/mysql/adapter.rb:385:in > > > > > > `initialize'' > > > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > > > > jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/connection_methods.rb:6:in > > > > > > `new'' > > > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > > > > jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/connection_methods.rb:6:in > > > > > > `jdbc_connection'' > > > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord- > > > > > > jdbc-adapter-1.0.2-java/lib/arjdbc/mysql/connection_methods.rb:18:in > > > > > > `mysql_connection'' > > > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > > > > > activerecord-3.0.1/lib/active_record/connection_adapters/abstract/ > > > > > > connection_pool.rb:230:in `new_connection'' > > > > > > from /Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > > > > > activerecord-3.0.1/lib/active_record/connection_adapters/abstract/ > > > > > > connection_pool.rb:238:in `checkout_new_connection'' > > > > > > ... 50 levels... > > > > > > from file:/Library/Tomcat/apache-tomcat-6.0.29/webapps/RSM/WEB-INF/ > > > > > > lib/jruby-rack-1.0.3.jar!/vendor/rack-1.2.1/rack/builder.rb:46:in > > > > > > `initialize'' > > > > > > from <script>:2:in `new'' > > > > > > from <script>:2 > > > > > > > at org.jruby.rack.DefaultRackApplicationFactory > > > > > > $4.init(DefaultRackApplicationFactory.java:184) > > > > > > at > > > > > > org.jruby.rack.DefaultRackApplicationFactory.getApplication(DefaultRackApplicationFactory.java: > > > > > > 59) > > > > > > at > > > > > > org.jruby.rack.PoolingRackApplicationFactory.getApplication(PoolingRackApplicationFactory.java: > > > > > > 94) > > > > > > at > > > > > > org.jruby.rack.servlet.DefaultServletDispatcher.process(DefaultServletDispatcher.java: > > > > > > 36) > > > > > > at org.jruby.rack.RackFilter.doFilter(RackFilter.java:59) > > > > > > at > > > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: > > > > > > 235) > > > > > > at > > > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: > > > > > > 206) > > > > > > at > > > > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: > > > > > > 233) > > > > > > at > > > > > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: > > > > > > 191) > > > > > > at > > > > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: > > > > > > 127) > > > > > > at > > > > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: > > > > > > 102) > > > > > > at > > > > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: > > > > > > 109) > > > > > > at > > > > > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: > > > > > > 298) > > > > > > at > > > > > > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: > > > > > > 857) > > > > > > at org.apache.coyote.http11.Http11Protocol > > > > > > $Http11ConnectionHandler.process(Http11Protocol.java:588) > > > > > > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java: > > > > > > 489) > > > > > > at java.lang.Thread.run(Thread.java:680) > > > > > > Caused by: org.jruby.exceptions.RaiseException: > > > > > > 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 > > > > > > at Kernel.raise(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > > > > > activerecord-3.0.1/lib/active_record/connection_adapters/ > > > > > > abstract_adapter.rb:202) > > > > > > at ActiveRecord::ConnectionAdapters::AbstractAdapter.log(/Library/ > > > > > > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-jdbc- > > > > > > adapter-1.0.2-java/lib/arjdbc/jdbc/adapter.rb:178) > > > > > > at ActiveRecord::ConnectionAdapters::JdbcAdapter.execute(/Library/ > > > > > > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-jdbc- > > > > > > adapter-1.0.2-java/lib/arjdbc/mysql/adapter.rb:14) > > > > > > at ArJdbc::MySQL.configure_connection(/Library/Tomcat/Home/webapps/ > > > > > > RSM/WEB-INF/gems/gems/activerecord-jdbc-adapter-1.0.2-java/lib/arjdbc/ > > > > > > mysql/adapter.rb:385) > > > > > > at ActiveRecord::ConnectionAdapters::MysqlAdapter.initialize(/Library/ > > > > > > Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/activerecord-jdbc- > > > > > > adapter-1.0.2-java/lib/arjdbc/jdbc/connection_methods.rb:6) > > > > > > at (unknown).new(/Library/Tomcat/Home/webapps/RSM/WEB-INF/gems/gems/ > > > > > > activerecord-jdbc-adapter-1.0.2-java/lib/arjdbc/jdbc/ > > > > > > connection_methods.rb:6) > > > > > > at > > ... > > read more »-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org 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.