TOTD #3: Using JavaDB with JRuby on Rails

In a previous screencast, I showed how to develop a Rails application fetching data from the MySQL database and deploy it in GlassFish. GlassFish comes pre-bundled with JavaDB. Based upon a user request, this TOTD shows to use JavaDB database instead of MySQL.

Here are the steps required to replace MySQL database configuration with JavaDB. You can either mix these steps with the existing screencast or follow these steps altogether after the original app is created using MySQL.

  1. Copy "GLASSFISH_HOME/javadb/lib/derbyclient.jar" to "C:\\Program Files\\NetBeans 6.0M10\\ruby1\\jruby-1.0\\lib" (or the directory location where JRuby for NetBeans 6 is installed). Make sure NetBeans IDE is restarted after the jar file is copied.
  2. In your application, change development database configuration in "database.yml" from:

    development:
      adapter: mysql
      database: glassfishrocks_development
      username: root
      password:
      host: localhost


    to

    development:
      adapter: jdbc
      driver: org.apache.derby.jdbc.ClientDriver
      url: jdbc:derby://localhost:1527/sample
      username: app
      password: app


    The NetBeans IDE comes pre-configured with the database URL, username and password used in this configuration.
  3. Start JavaDB using "asadmin start-database" command.
  4. Invoke db:migrate rake target to create the database required by the application. The development database configuration is used to create the database tables. If you followed the screencast, then a new table "greetings" is created in the database "sample".

  5. Change production database configuration in "database.yml" from:

    production:
      adapter: mysql
      database: glassfishrocks_production
      username: root
      password:
      host: localhost


    to

    production:
      adapter: jdbc
      driver: org.apache.derby.jdbc.ClientDriver
      url: jdbc:derby://localhost:1527/sample
      username: app
      password: app

    This new database configuration is exactly the same as for the development configuration. The production configuration is used by the WAR file.
  6. Insert value into the newly create database as "insert into GREETINGS values (1, 'Hello from JavaDB');".

  7. Create the WAR file using war:standalone:create rake target.
  8. Deploy the WAR file in the "GLASSFISH_HOME/domains/domain/autodeploy" directory.

You can also check out an early version of a tutorial that is being written about installing and configuring Ruby support in the NetBeans IDE. If you would like to get early access to Ruby documentation, learn more here.

Please leave suggestions on the TOTD that you'd like to see. A complete archive is available here.

Technorati: totd jrubyonglassfish jruby rubyonrails javadb glassfish ror ruby

Comments:

Excellent, thanks!

Posted by Glen on August 20, 2007 at 01:20 AM PDT #

Just to elaborate a bit on Step 6, to add the sample row in JavaDB, you can either use NetBeans (Services Tab, add the DerbyClient.jar, then right-click it and choose "Connect Using..." to create the database listing) or the JavaDB "ij" command-line tool located under $GLASSFISH_HOME/javadb/frameworks/NetworkServer.

Posted by Glen on August 26, 2007 at 12:28 PM PDT #

Post a Comment:
Comments are closed for this entry.
About

profile image
Arun Gupta is a technology enthusiast, a passionate runner, author, and a community guy who works for Oracle Corp.


Java EE 7 Samples

Stay Connected

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today