JRoR./JBoss/MySQL issues

nlsmith · June 3, 2009, 8:47pm

My development environment has changed again. We have gone from
ROR/MySQL to JRoR/Oracle -> JRoR/JBoss/Oracle. Now we have to make it
run under JRoR/JBoss/MySQL. The app runs stand alone JRoR/MySQL with the
JDBC drivers. I am using Warbler to build the War file. I am using JRuby
1.2. Installed Gems are:

*** LOCAL GEMS ***

actionmailer (2.2.2)
actionpack (2.2.2)
activerecord (2.2.2)
ActiveRecord-JDBC (0.5)
activerecord-jdbc-adapter (0.9)
activerecord-jdbcmysql-adapter (0.9)
activeresource (2.2.2)
activesupport (2.2.2)
jdbc-mysql (5.0.4)
jruby-openssl (0.5)
net-sftp (2.0.2)
net-ssh (2.0.11)
parseexcel (0.5.2)
rails (2.2.2)
rake (0.8.6)
rspec (1.2.0)
rubyzip (0.9.1)
rufus-scheduler (2.0.1)
sources (0.0.1)
tzinfo (0.3.13)
warbler (0.9.12)

I realize that most are not the latest, but they are the combination
that work from db:migrate thru running live so far. I have also
mysql-connector-java-5.0.8-bin.jar in several places, including
jruby\lib.

After deplopying the app, I get the following dump to the browser screen
when I try to access the home page:

MissingSourceFile in UsersController#login
no such file to load – mysql
RAILS_ROOT:
C:\Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF

Application Trace | Framework Trace | Full Trace
/C:/Development/jboss-5.0.1.GA/server/default/deploy/Sub.war/WEB-INF/lib/jruby-complete-1.2.0.jar/META-INF/jruby.home/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
require' /C:/Development/jboss-5.0.1.GA/server/default/deploy/Sub.war/WEB-INF/lib/jruby-complete-1.2.0.jar/META-INF/jruby.home/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:inrequire’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:155:in
require' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activesupport-2.2.2/lib/active_support/core_ext/kernel/requires.rb:7:inrequire_library_or_gem’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activesupport-2.2.2/lib/active_support/core_ext/kernel/reporting.rb:11:in
silence_warnings' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activesupport-2.2.2/lib/active_support/core_ext/kernel/requires.rb:5:inrequire_library_or_gem’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/connection_adapters/mysql_adapter.rb:63:in
mysql_connection' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:innew_connection’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:245:in
checkout_new_connection' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:188:incheckout’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in
loop' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:incheckout’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:183:in
checkout' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:98:inconnection’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/SubInfo.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:326:in
retrieve_connection' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:121:inretrieve_connection’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:113:in
connection' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/query_cache.rb:8:incache’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/actionpack-2.2.2/lib/action_controller/caching/sql_cache.rb:12:in
perform_action_with_caching' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/actionpack-2.2.2/lib/action_controller/base.rb:524:inprocess’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/actionpack-2.2.2/lib/action_controller/filters.rb:606:in
process_with_filters' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/actionpack-2.2.2/lib/action_controller/session_management.rb:134:inprocess_with_session_management_support’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/actionpack-2.2.2/lib/action_controller/base.rb:392:in
process' :1 /C:/Development/jboss-5.0.1.GA/server/default/deploy/Sub.war/WEB-INF/lib/jruby-complete-1.2.0.jar/META-INF/jruby.home/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:inrequire’
/C:/Development/jboss-5.0.1.GA/server/default/deploy/Sub.war/WEB-INF/lib/jruby-complete-1.2.0.jar/META-INF/jruby.home/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
require' /C:/Development/jboss-5.0.1.GA/server/default/deploy/Sub.war/WEB-INF/lib/jruby-complete-1.2.0.jar/monitor.rb:191:inmon_synchronize’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:183:in
handle_request' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:110:indispatch_unlocked’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:123:in
dispatch' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:122:indispatch’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:132:in
dispatch_cgi' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:39:indispatch’
/C:/Development/jboss-5.0.1.GA/server/default/deploy/Sub.war/WEB-INF/lib/jruby-rack-0.9.3.jar/rack/adapter/rails.rb:37:in
serve_rails' /C:/Development/jboss-5.0.1.GA/server/default/deploy/Sub.war/WEB-INF/lib/jruby-rack-0.9.3.jar/rack/adapter/rails.rb:44:incall’
/C:/Development/jboss-5.0.1.GA/server/default/deploy/Sub.war/WEB-INF/lib/jruby-rack-0.9.3.jar/jruby/rack/rails.rb:145:in
call' /C:/Development/jboss-5.0.1.GA/server/default/deploy/Sub.war/WEB-INF/lib/jruby-rack-0.9.3.jar/rack/handler/servlet.rb:17:incall’
/C:/Development/jboss-5.0.1.GA/server/default/deploy/Sub.war/WEB-INF/lib/jruby-complete-1.2.0.jar/META-INF/jruby.home/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
require' /C:/Development/jboss-5.0.1.GA/server/default/deploy/Sub.war/WEB-INF/lib/jruby-complete-1.2.0.jar/META-INF/jruby.home/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:inrequire’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activesupport-2.2.2/lib/active_support/dependencies.rb:155:in
require' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activesupport-2.2.2/lib/active_support/core_ext/kernel/requires.rb:7:inrequire_library_or_gem’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activesupport-2.2.2/lib/active_support/core_ext/kernel/reporting.rb:11:in
silence_warnings' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activesupport-2.2.2/lib/active_support/core_ext/kernel/requires.rb:5:inrequire_library_or_gem’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/connection_adapters/mysql_adapter.rb:63:in
mysql_connection' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:innew_connection’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:245:in
checkout_new_connection' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:188:incheckout’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in
loop' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:incheckout’
/C:/Development/jboss-5.0.1.GA/server/default/deploy/Sub.war/WEB-INF/lib/jruby-complete-1.2.0.jar/monitor.rb:191:in
mon_synchronize' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:183:incheckout’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:98:in
connection' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:326:inretrieve_connection’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:121:in
retrieve_connection' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:113:inconnection’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/activerecord-2.2.2/lib/active_record/query_cache.rb:8:in
cache' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/actionpack-2.2.2/lib/action_controller/caching/sql_cache.rb:12:inperform_action_with_caching’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/actionpack-2.2.2/lib/action_controller/base.rb:524:in
process' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/actionpack-2.2.2/lib/action_controller/filters.rb:606:inprocess_with_filters’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/actionpack-2.2.2/lib/action_controller/session_management.rb:134:in
process_with_session_management_support' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/actionpack-2.2.2/lib/action_controller/base.rb:392:inprocess’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:183:in
handle_request' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:110:indispatch_unlocked’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:123:in
dispatch' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:122:indispatch’
C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:132:in
dispatch_cgi' C:/Development/jboss-5.0.1.GA/server/default/tmp/as102t/Sub.war/WEB-INF/gems/gems/actionpack-2.2.2/lib/action_controller/dispatcher.rb:39:indispatch’
/C:/Development/jboss-5.0.1.GA/server/default/deploy/Sub.war/WEB-INF/lib/jruby-rack-0.9.3.jar/rack/adapter/rails.rb:37:in
serve_rails' /C:/Development/jboss-5.0.1.GA/server/default/deploy/Sub.war/WEB-INF/lib/jruby-rack-0.9.3.jar/rack/adapter/rails.rb:44:incall’
/C:/Development/jboss-5.0.1.GA/server/default/deploy/Sub.war/WEB-INF/lib/jruby-rack-0.9.3.jar/jruby/rack/rails.rb:145:in
call' /C:/Development/jboss-5.0.1.GA/server/default/deploy/Sub.war/WEB-INF/lib/jruby-rack-0.9.3.jar/rack/handler/servlet.rb:17:incall’
:1
This error occurred while loading the following files:
mysql

The mysql-ds.xml in C:\Development\jboss-5.0.1.GA\server\default looks
like this:

<?xml version="1.0" encoding="UTF-8"?> MySqlDS jdbc:mysql://server:3306/sub_development com.mysql.jdbc.Driver u p org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter mySQL

I have tried every combination things I can think of. I even
uninstalled/re-installed/switched version of the jdbc gems. I have
checked that Warbler is getting all the gems into the War file.

Any hints/clues/working examples would be GREAT!!!

Thanks,

Norm

nlsmith · June 4, 2009, 5:45pm

I installed Tomcat this AM and get the same error. So, the error is not
directly related to JBoss.

Anyone? Any hints?

Norm

nlsmith · June 15, 2009, 3:05pm

I switched the database to SQLite and I still get the same error both
with JBoss and Tomcat! The app runs just fine from the command line with
any database I throw at it.

Has anyone successfully gotten JRoR using MySQL to build a War file with
Warbler and deploy it successfully to Tomcat or JBoss? I must be doing
something really stupid, but I have been throwing rocks at this for so
long that I can’t see what I am doing wrong!!

Norm