Rails - Feb 2013 - Struggling with Jruby Rails + jdbc driver

hi all,

I am having a hard time trying to find out what''s wrong with my setup.
It
used to work smoothly until I decided out of the blue to do a selfupdate 
and upgrade outdated on MacPort, then things started going south very 
quickily. 

Since MacPort kinda broke, I pull it all out and re-install the ports I 
have before, which went pretty smoothly. Then to my surprise any command I 
issue like ruby, gem /bundle started giving me "execv failed: Permission 
denied (13)" error. Not much luck googling that. So after couple hours, I 
pulled the whole thing as well. Remove all rubies from RVM and then 
re-installing them. 

I got to a point where the ruby, gem, bundle functions without problem. Now 
firing up my test project it can no longer connect to the derby database 
anymore. I tried manually adding the jdbc-derby  in the gem file even 
thought I know "activerecord-jdbcderby-adapter" should have that as 
dependency. But it is still giving me class not found error. Suspecting I 
might have screwed my current project setting somehow, I created a brand 
new app and added the same derby active record adaptor and jdbc-derby gem 
in the gem file. Unfortunately I am still having the same problem listed 
later in this post.

Coming from the Java world, the classpath thing is pretty easy to follow 
even with maven.  However I am totally scratching my head on how jruby & 
rails finds and loads the java lib and I can''t seem to find any clear
info
on that. I can see the  Any pointers on how to solve my problem and might 
be potential place where I should look shall be greatly appreciated!!!

I can see the jdbc-derby gem installed under my .rvm dir but have no idea 
how it gets loaded at runtime in jruby and rails:
./gems/jruby-1.7.2/gems/jdbc-derby-10.8.3.0
./gems/jruby-1.7.2/gems/jdbc-derby-10.8.3.0/lib
./gems/jruby-1.7.2/gems/jdbc-derby-10.8.3.0/lib/derby-10.8.3.0.jar
./gems/jruby-1.7.2/gems/jdbc-derby-10.8.3.0/lib/jdbc
./gems/jruby-1.7.2/gems/jdbc-derby-10.8.3.0/lib/jdbc/derby.rb
./gems/jruby-1.7.2/gems/jdbc-derby-10.8.3.0/LICENSE.txt
./gems/jruby-1.7.2/gems/jdbc-derby-10.8.3.0/Rakefile
./gems/jruby-1.7.2/gems/jdbc-derby-10.8.3.0/README.md




Error I am getting:

hello01 $ rails console
Loading development environment (Rails 3.2.12)
irb(main):001:0> User.all
NameError: cannot load Java class org.apache.derby.jdbc.ClientDriver
from org/jruby/javasupport/JavaClass.java:1227:in `for_name''
from org/jruby/javasupport/JavaUtilities.java:34:in `get_proxy_class''
from 
file:/Users/josephli/.rvm/rubies/jruby-1.7.2/lib/jruby.jar!/jruby/java/core_ext/object.rb:26:in
`java_import''
from org/jruby/RubyArray.java:2361:in `map''
from 
file:/Users/josephli/.rvm/rubies/jruby-1.7.2/lib/jruby.jar!/jruby/java/core_ext/object.rb:22:in
`java_import''
from 
/Users/josephli/.rvm/gems/jruby-1.7.2/gems/activerecord-jdbc-adapter-1.2.7/lib/arjdbc/jdbc/driver.rb:24:in
`driver_class''
from org/jruby/RubyModule.java:2291:in `module_eval''
from 
/Users/josephli/.rvm/gems/jruby-1.7.2/gems/activerecord-jdbc-adapter-1.2.7/lib/arjdbc/jdbc/driver.rb:23:in
`driver_class''
from org/jruby/javasupport/JavaObject.java:272:in `synchronized''
from org/jruby/javasupport/JavaProxyMethods.java:90:in `synchronized''
from 
/Users/josephli/.rvm/gems/jruby-1.7.2/gems/activerecord-jdbc-adapter-1.2.7/lib/arjdbc/jdbc/driver.rb:20:in
`driver_class''
from 
/Users/josephli/.rvm/gems/jruby-1.7.2/gems/activerecord-jdbc-adapter-1.2.7/lib/arjdbc/jdbc/driver.rb:8:in
`initialize''
from 
/Users/josephli/.rvm/gems/jruby-1.7.2/gems/activerecord-jdbc-adapter-1.2.7/lib/arjdbc/jdbc/connection.rb:44:in
`configure_jdbc''
from 
/Users/josephli/.rvm/gems/jruby-1.7.2/gems/activerecord-jdbc-adapter-1.2.7/lib/arjdbc/jdbc/connection.rb:24:in
`configure_connection''
from 
/Users/josephli/.rvm/gems/jruby-1.7.2/gems/activerecord-jdbc-adapter-1.2.7/lib/arjdbc/jdbc/connection.rb:82:in
`initialize''
from 
/Users/josephli/.rvm/gems/jruby-1.7.2/gems/activerecord-jdbc-adapter-1.2.7/lib/arjdbc/jdbc/adapter.rb:31:in
`initialize''
... 20 levels...
from 
/Users/josephli/.rvm/gems/jruby-1.7.2/gems/activerecord-3.2.12/lib/active_record/relation.rb:160:in
`to_a''
from 
/Users/josephli/.rvm/gems/jruby-1.7.2/gems/activerecord-3.2.12/lib/active_record/explain.rb:33:in
`logging_query_plan''
from 
/Users/josephli/.rvm/gems/jruby-1.7.2/gems/activerecord-3.2.12/lib/active_record/relation.rb:159:in
`to_a''
from 
/Users/josephli/.rvm/gems/jruby-1.7.2/gems/activerecord-3.2.12/lib/active_record/relation/finder_methods.rb:159:in
`all''
from org/jruby/RubyBasicObject.java:1659:in `__send__''
from 
/Users/josephli/.rvm/gems/jruby-1.7.2/gems/activerecord-3.2.12/lib/active_record/querying.rb:5:in
`all''
from (irb):1:in `evaluate''
from org/jruby/RubyKernel.java:1066:in `eval''
from org/jruby/RubyKernel.java:1392:in `loop''
from org/jruby/RubyKernel.java:1174:in `catch''
from org/jruby/RubyKernel.java:1174:in `catch''
from 
/Users/josephli/.rvm/gems/jruby-1.7.2/gems/railties-3.2.12/lib/rails/commands/console.rb:47:in
`start''
from 
/Users/josephli/.rvm/gems/jruby-1.7.2/gems/railties-3.2.12/lib/rails/commands/console.rb:8:in
`start''
from 
/Users/josephli/.rvm/gems/jruby-1.7.2/gems/railties-3.2.12/lib/rails/commands.rb:41:in
`(root)''
from org/jruby/RubyKernel.java:1027:in `require''
from script/rails:6:in `(root)''irb(main):002:0> 


Any help would be appreciated,

Joseph








-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/tOrACl1TXQcJ.
For more options, visit https://groups.google.com/groups/opt_out.

Now this is cheating. I finally decided to add the derbyclient.jar from the 
maven repo to my CLASSPATH env var in my bash profile. Which get things 
going for now. However, I am still baffled at what made it all work before 
I did the whole MacPort & RVM reinstall routine as my bash_profile
hasn''t
been touched for quite some time already. Which only means things was 
working without adding anything to the CLASSPATH. 

I said my work around is cheating since the whole Gem + bundle + Gemfile 
should have made the rail app kinda self contained and shouldn''t rely
on
external setting like CLASSPATH? Please correct me if I am wrong. 

Anybody have similar experience? 

Thanks,
Joseph

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/eDk6jWdd_xMJ.
For more options, visit https://groups.google.com/groups/opt_out.

I give up. But found a better workaround and that might just actually be 
what I have done in the first place to get it working. 

Turns out the jdbc-derby gem doesn''t have the derbyclient network
driver
but only the embedded driver. Thus the class not found. I tried many things 
and thinking some combinations of the gems that I added trying to get it 
work corrupted something. But still no dice. I ended up cleaning out the 
jruby again from RVM. And then go  on to manually removing the 
corresponding gem directory (.rvm/gems). 

One thing I encountered amid the removal and reinstall was getting the 
following err when trying to run bundle command:
*     ......ruby_noexec_wrapper*:*7:in* `*require*'': *no such file to 
load.......*
*Solution was to set the default ruby again from rvm with the
"--default"
option.*
*
*

*And finally the workaround is..... just stick the derbyclient driver in 
the ".rvm/rubies/jruby-1.7.2/lib" directory and that loaded
automatically
and I don''t have problem with intellij anymore that way.*


*If anyone knows how to solve this more elegantly, please let me know. My 
gut feeling tells me it might involve a new gem or something, which I
don''t
know how to make yet.*
*
*
*Joseph *
*
*
*
*
*
*

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/Ed_C8aEIG7cJ.
For more options, visit https://groups.google.com/groups/opt_out.

On 02/14/2013 10:13 PM, Joseph Li wrote:
> I give up. But found a better workaround and that might just actually be
what I
> have done in the first place to get it working.
>
> Turns out the jdbc-derby gem doesn''t have the derbyclient network
driver but
> only the embedded driver. Thus the class not found. I tried many things and
> thinking some combinations of the gems that I added trying to get it work
> corrupted something. But still no dice. I ended up cleaning out the jruby
again
> from RVM. And then go  on to manually removing the corresponding gem
directory
> (.rvm/gems).
>
> One thing I encountered amid the removal and reinstall was getting the
following
> err when trying to run bundle command:
> /     ......ruby_noexec_wrapper/:/7:in/ `/require/'': /no such file
to load......./
> /Solution was to set the default ruby again from rvm with the
"--default" option./
That sir, is caused by rubygems-bundler in @global.

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit https://groups.google.com/groups/opt_out.

Thank you Jordon, for the extra info. I have not yet master enough 
knowledge of how rvm works yet. I just know enough commands to monkey it 
around til it works. :> Guess a visit to the rvm / bundler page will be 
needed soon. 

Thanks,
Joseph

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/1lzGxf48c7EJ.
For more options, visit https://groups.google.com/groups/opt_out.