JRuby, Rails and MYSQL Ready for Primetime?

[Ray Hooker]

This is a follow-up to my previous post raising the question of JRuby, Rails
and mysql integration. As my previous post indicated, I was able to bring
up the app which connects to MYSQL just fine under the Netbeans built-in
JRuby, GlassFish and Mongrel (though Glassfish does not display the images
in my layout for some reason). Since I may need to deploy to a server
other than Glassfish, I tried the WAR file generation. When I try to bring
the app up under both Glassfish and Tomcat, it gives the error "unable to
connect".

Yes I know that it may be that it now is trying to access MYSQL like it is
remote versus an inner process call but I cannot confirm that. Does anyone
have a hint or cookbook on how to achieve this? I have tried posting my
question to the MYSQL forum but noone is answering... the docs indicate that
skip-networking should be commented out, but it does not exist in my.ini..
also I disabled my windows firewall for the test.

Also wondered about JDBC, but I saw quite a few errors reported last year
but no resolution reported. As before, is there a well-worn path for
bringing this up under windows with MYSQL, JRuby, Rails?

Thanks,

Ray
--
View this message in context: http://www.nabble.com/JRuby%2C-Rails-and-MYSQL--Ready-for-Primetime--tp23635002p23635002.html
Sent from the NetBeans Ruby Users mailing list archive at Nabble.com.

[Brandon Hauff]

Hi Ray,

I have been using JRuby on Rails for a while now. I use a local mysql
database for testing, but normally connect to a DB2 database. I will
describe what works for me:

JRuby 1.2.0 installed at c:\jruby-1.2.0
Gems:
- Rails 2.2.2
- Rails 2.3.2
- activerecord-jdbc-adapter 0.9.0 (There are some problem with 0.9.1)
- activerecord-jdbcmysql-adapter 0.9.0
- jdbc-mysql 5.0.4
- glassfish 0.9.3
- mongrel 1.1.5
- rack 0.9.1

Your database.yml should look like this:

development:
adapter: jdbcmysql
database: fulfillment_development
username: user
password: password
host: localhost

I always use mongrel for testing my app in development. I use the
glassfish gem, not the glassfish v3, for deployment. It is a simple as
changing to your projects directory and then executing 'glassfish -e
production -p port -d'. Vivek Pandey has some great blog posts about
using the glassfish gem: http://weblogs.java.net/blog/vivekp/

Hope this helps,

Brandon

[Ray Hooker]

Brandon, I started by first trying to upgrade to Rails 2.3.2. I did the
upgrade for both Jruby and regular. You can see the gem list below. I
changed the environment to specify Rails 2.3.2, but when I try to run the
app again under Glassfish using Netbeans, it says:
SEVERE: Missing the Rails 2.3.2 gem. Please `gem install -v=2.3.2 rails`,
update your RAILS_GEM_VERSION setting in config/environment.rb for the Rails
version you do have installed, or comment out RAILS_GEM_VERSION to use the
latest version installed.
SEVERE:

It says the same thing for WEBrick. What is going on? Is there a separate
install for Netbeans??

Ray
*** LOCAL GEMS ***

actionmailer (2.3.2, 2.1.0)
actionpack (2.3.2, 2.1.0)
activerecord (2.3.2, 2.1.0)
activerecord-jdbc-adapter (0.9.1)
activerecord-jdbcmysql-adapter (0.9.1)
activeresource (2.3.2, 2.1.0)
activesupport (2.3.2, 2.1.0)
jdbc-mysql (5.0.4)
jruby-ldap (0.0.1)
rails (2.3.2, 2.1.0)
rake (0.8.4)
rspec (1.2.0)
ruby-net-ldap (0.0.4)
sources (0.0.1)
warbler (0.9.13)
--
View this message in context: http://www.nabble.com/JRuby%2C-Rails-and-MYSQL--Ready-for-Primetime--tp23635002p23637239.html
Sent from the NetBeans Ruby Users mailing list archive at Nabble.com.

[Ray Hooker]

I thought I found the problem but... I see that I needed to specify a new
platform. So I decided to add the JRuby 1.2.0 where everything is
installed. I left Glassfish as the server but every time I bring it up, it
runs the built in JRuby.

When I try WEBBrick instead, it does come up but has a routing error when I
try to specify a particular route (e.g.
http://localhost:8080/myapplication/customers). It works under the previous
version. Did something change with routing in 2.3.2 or is there another
issue?

Ray
--
View this message in context: http://www.nabble.com/JRuby%2C-Rails-and-MYSQL--Ready-for-Primetime--tp23635002p23637444.html
Sent from the NetBeans Ruby Users mailing list archive at Nabble.com.

[Brandon Hauff]

Hi Ray,

I do not use Glassfish in development because I have never had luck with
it. I always use mongrel, and I suggest you give that a whirl. I
forgot to mention that if you installed JRuby into C:\jruby-1.2.0 like I
suggested that you would need to add it as a platform in Netbeans. I
never have used the Built-in Netbeans JRuby platform.

Just to try and eliminate some extra variables try this.

Make sure your command line is using c:\jruby-1.2.0 and try:

Rails -d mysql testing
cd testing
jruby script/generate scaffold Post title:string body:text
edit the database.yml to match my earlier email
rake db:create:all
rake db:migrate
jruby script/server # make sure the mongrel gem is installed

goto http://localhost:30000/posts and see if you have a functioning
rails app!

Thanks,

Brandon

[Peter Williams]

Hi Ray,

First, for NetBeans + JRuby + GlassFish, Arun's blog has lots of helpful
information -- http://weblogs.java.net/blog/arungupta/

Regarding database configuration, the current implementations of
jdbc${dbtype} seem to work ok -- specifically, I've had good luck with
jdbcmysql and jdbcpostgres. Note Nick's comment regarding "rack
db:create*" not working well.

Ray Hooker wrote:

[Ray Hooker]

So thanks for the suggestions. I was finally able to sync up the gems (for
both JRuby and standard Ruby). I did have to fix the MYSQL connection
which was a pain. I am using MYSQL 5.1 and so I had to get the libmysql.dll
from version 5.0. So mongrel does indeed work.

I am having trouble with warbler. Have you used warbler? I would like the
option of deploying to tomcat (or Glassfish if it works). I ran into a
number of issues. If you have gotten it to work, what are your versions,
etc.?

Ray
--
View this message in context: http://www.nabble.com/JRuby%2C-Rails-and-MYSQL--Ready-for-Primetime--tp23635002p23663258.html
Sent from the NetBeans Ruby Users mailing list archive at Nabble.com.

[Brandon Hauff]

Hi Ray,

Glad you got your setup running. Unfortunately, I have not used
warbler. Only the glassfish gem.