Arun Gupta, Miles to go ...

TOTD #113: JavaFX front-end for GlassFish v3 Administration - Using REST interface

GlassFish v3 provides a REST interface to management and monitoring information as discussed in TOTD #96. As mentioned in that blog "the REST interface is a lower level API that enables toolkit developers and IT administrators to write their custom scripts/clients using language of their choice". This blog introduces a tool that uses the REST API to provide management and monitoring of GlassFish v3 and is written using JavaFX.

This tool is only a proof-of-concept that demonstrates that GlassFish v3 REST interface is functionally very rich and can indeed be used to write third-party administration tools. The tool uses a subset of the REST interface and exposes only a limited amount of management and monitoring capabilities otherwise exposed. After all this is a proof-of-concept :-)

A screencast of this tool in action along with a downloadable JNLP version will soon be available. For now, here is a snapshot of the main window of this tool:

The main screen allows you to enter a URL for the GlassFish administration. Then the GlassFish instance can be stopped/restarted from the main window using the buttons on top right. There is an animation at the bottom of the screen where the glassfish is swimming in the ocean and is directly related to the state of server running in the background. If the server is running, the animation works. If the server is not running then the animation stops as well.

The main screen has three main buttons:

• "List Applications" - list all the applications deployed on the running instance
• "Show Monitoring Levels" - show/Update all the monitoring levels
• "Server Stats" - show statistics of the running server

Clicking on "List Applications" shows the list of applications deployed on this particular instance. Here is how a snapshot looks like for an instance running on my localhost at port 4848:

As shown in the screen, it shows a radio-bulleted list of all the applications. Each bullet is also accompanied by an image indicating the type of application - Web or Rails for now. Select the application and click on "Monitor" button to monitor that particular application. The REST API exposes a vast amount of monitoring data but a subset of monitoring data is displayed for Web and Rails application for now. Here is a snapshot of the monitoring data published for a Web application:

As evident by the list of engines, this web application has EJBs bundled as well. It also shows total number of Servlets/JSPs loaded, number of requests made to this web application and some other monitoring data.

Here is a snapshot of the monitoring data published for a Rails application:

It shows number of JRuby runtimes configured for the application, number of requests sent to the application, number of responses with different HTTP access codes and some other data.

The monitoring levels of different containers can be easily updated by clicking on "Show Monitoring Levels" as shown below:

And finally some server statistics are shown by clicking on "Server Stats" as shown below:

It shows when the server was started, host/port information, version and finally how long the server has been running for. The dials are an animation that shows the server up time.

Here are other related JavaFX and GlassFish related blogs published earlier:

• TOTD #23: JavaFX Client invoking a Metro endpoint
• JavaFX 1.0 launched - access services hosted on embedded GlassFish

How are you going to use the REST interface exposed by GlassFish v3 in your environment ?

Are you using JavaFX with GlassFish together in any way ?

Leave a comment on this blog if you do!

Technorati: javafx glassfish v3 rest web jruby rubyonrails rest administration monitoring management

Posted by Arun Gupta in General  |  Comments[0]

TOTD #112: Exposing Oracle database tables as RESTful entities using JAX-RS, GlassFish, and NetBeans

This Tip Of The Day explains how to expose an existing Oracle database table as a RESTful Web service endpoint using NetBeans tooling and deployed on GlassFish.

Lets get started!

1. Configure GlassFish v3 10/7 or a later nightly in a recent NetBeans 6.8 build (latest nightly). As issue# 9885 is fixed, so copy ojdbc6.jar in the "domains/domain1/lib/ext" directory.
2. Create a Web application
   1. Create a new "Web application" and name the project "RestfulOracle":
      
      
      
      click on "Next >".
   2. Choose the newly added server and "Java EE 6 Web" as the Java EE version:
      
      
      
      and click on "Finish".
      
3. Create JPA entities for "HR" schema. The steps outlined below uses NetBeans solely for creating the JPA entities. Alternatively, TOTD #108 explains how to define a JDBC connection pool and JDBC resource using "asadmin" CLI and then use that resource from within NetBeans. Either way, the JDBC resource is stored in the underlying "domain.xml".
   1. Right-click on the project and select "New", "Entity Classes from Database...".
   2. In "Data Source:" select "New Data Source..." as shown below:
      
      
   3. Specify the JNDI name as "jdbc/hr" and choose the pre-configured database connection as shown below:
      
      
      
      TOTD #107 explains how to configure Oracle database in NetBeans.
   4. In the list of "Available Tables:", select "EMPLOYEES" and click on "Add >" to see the following:
      
      
      
      Notice the list of related tables are included as well. Click on "Next >".
   5. Specify the package name as "model".
   6. Click on "Create Persistence Unit...", take the defaults, and click on "Create":
      
      
      
      and click on "Finish". Notice EclipseLink, the reference implementation for JPA 2.0, is used as the persistence provider. This generates POJOs that provide database access using JPA 2.0 APIs. These APIs are included as part of the Java EE 6 platform.
      
4. Create RESTful entities
   1. Right-click on the project and select "RESTful Web Services from Entity Classes...":
      
      
      
   2. Select "Employees (model.Employees)" from "Available Entity Classes:" and click on "Add >" to see the following:
      
      
      
      click on "Next >", take the defaults, and click on "Finish". This generates a bunch of wrapper classes using JAX-RS to expose the JPA Entity classes as RESTful Web services. JAX-RS 1.1 is also included as part of the Java EE 6 platform.
5. Run the Web service
   1. Right-click the project and select "Test RESTful Web Services":
      
      
      
      This deploys the created Web application on the selected GlassFish build and displays the following page in the default browser:
      
      
      
   2. Click on "deparmentss" and then on "Test" button to see the output as:
      
      
      
      Clicking the "Test" button issues a GET request to "http://localhost:8080/RestfulOracle/resources/departmentss". This uses the generated JAX-RS wrapper classes to talk to the database using JPA entity classes and query the first 10 rows from the "DEPARTMENTS" table. The response is then JSON formatted using JAX-RS wrapper classes and is returned to the requesting page which then displays it nicely formatted in the table. It also shows l-level deep department's relationship to other entities. If the "expandLevel" on the above page is set to "0", then the following output is shown:
      
      
      
      The "Raw View" (JSON data) of the original output looks like:
      
      
      
      Notice this is the raw JSON output generated by the JAX-RS wrapper classes. The "Http Monitor" traffic looks like:
      
      
      
      The format of data returned can be changed from "application/json" to "application/xml" as shown below:
      
      
      
      And even a POST request can be generated.

Do you have the need to expose your Oracle database tables as RESTful entities ?

A complete archive of all the TOTDs is available here.

This and other similar applications will be demonstrated at the upcoming Oracle Open World.

Technorati: totd oracle database glassfish v3 netbeans javaee jax-rs jpa rest

Posted by Arun Gupta in General  |  Comments[0]

TOTD #111: Rails Scaffold for a pre-existing table using Oracle and GlassFish

TOTD #110 explained how to create a brand new Rails application using Oracle database and run it using GlassFish v Gem. This Tip Of The Day explains how to create a scaffold for a sample schema that ships with Oracle database. Even though Rails Scaffold are good for, well, scaffolding but they do get you started easily. This blog will use the sample HR schema that comes along with Oracle database.

Lets get started!

1. Copy the reverse_scaffold script in the "script" directory of your application created in TOTD #110. This script generates Model and Forms from a pre-existing database table. More details about this script are here.
2. Edit "config/database.yml" and change the "development" section to:
   
   development:
adapter: oracle_enhanced
host: localhost
database: orcl
username: hr
password: hr
   
   The changes are highlighted in bold, only the username and password values are changed to reflect the default values used with the sample database.
3. Generate the models and forms for "departments" table as:
   

   ~/samples/v3/rails/oracle/bookstore >~/tools/jruby/bin/jruby script/reverse_scaffold departments department
   JRuby limited openssl loaded. gem install jruby-openssl for full support.
   http://wiki.jruby.org/wiki/JRuby_Builtin_OpenSSL
   JRuby limited openssl loaded. gem install jruby-openssl for full support.
   http://wiki.jruby.org/wiki/JRuby_Builtin_OpenSSL
    exists app/models/
    exists app/controllers/
    exists app/helpers/
    create app/views/departments
    exists app/views/layouts/
    exists test/functional/
    exists test/unit/
    create test/unit/helpers/
    exists public/stylesheets/
    create app/views/departments/index.html.erb
    create app/views/departments/show.html.erb
    create app/views/departments/new.html.erb
    create app/views/departments/edit.html.erb
    create app/views/layouts/departments.html.erb
    create public/stylesheets/scaffold.css
    create app/controllers/departments_controller.rb
    create test/functional/departments_controller_test.rb
    create app/helpers/departments_helper.rb
    create test/unit/helpers/departments_helper_test.rb
    route map.resources :departments
    dependency model
    exists app/models/
    exists test/unit/
    exists test/fixtures/
    create app/models/department.rb
    create test/unit/department_test.rb
    create test/fixtures/departments.yml
   

4. Edit "app/models/department.rb" and specify the primary key to "department_id" column by adding:
   

   set_primary_key "department_id"
   

   
   
5. Run the application as:

   ~/samples/v3/rails/oracle/bookstore >~/tools/jruby/bin/jruby -S glassfish -l
   Starting GlassFish server at: 129.145.133.197:3000 in development environment...
   Writing log messages to: /Users/arungupta/samples/v3/rails/oracle/bookstore/log/development.log.
   Press Ctrl+C to stop.
   Oct 6, 2009 2:14:19 PM com.sun.enterprise.v3.services.impl.GrizzlyProxy start
   INFO: Listening on port 3000
   
   . . .
   

   
   The application is now accessible at "http://localhost:3000/departments" and looks like:
   
6. Similarly, create the model and forms for "employees" table as:
   
   

   ~/samples/v3/rails/oracle/bookstore >~/tools/jruby/bin/jruby script/reverse_scaffold employees employee
   JRuby limited openssl loaded. gem install jruby-openssl for full support.
   http://wiki.jruby.org/wiki/JRuby_Builtin_OpenSSL
   JRuby limited openssl loaded. gem install jruby-openssl for full support.
   http://wiki.jruby.org/wiki/JRuby_Builtin_OpenSSL
    exists app/models/
    exists app/controllers/
    exists app/helpers/
    create app/views/employees
    exists app/views/layouts/
    exists test/functional/
    exists test/unit/
    exists test/unit/helpers/
    exists public/stylesheets/
    create app/views/employees/index.html.erb
    create app/views/employees/show.html.erb
    create app/views/employees/new.html.erb
    create app/views/employees/edit.html.erb
    create app/views/layouts/employees.html.erb
    identical public/stylesheets/scaffold.css
    create app/controllers/employees_controller.rb
    create test/functional/employees_controller_test.rb
    create app/helpers/employees_helper.rb
    create test/unit/helpers/employees_helper_test.rb
    route map.resources :employees
    dependency model
    exists app/models/
    exists test/unit/
    exists test/fixtures/
    create app/models/employee.rb
    create test/unit/employee_test.rb
    create test/fixtures/employees.yml
   

   
   Specify the primary key to "employee_id" by adding the following to "app/models/employee.rb" as:
   

   set_primary_key "employee_id"
   

   
   The scaffolded table is now available at "http://localhost:3000/employees" and looks like:
   
   

So we created a simple Rails CRUD application accessing information from a pre-existing table in the Oracle database server.

Thanks to @mediachk for all the help!

A complete archive of all the TOTDs is available here. The complete list of Rails blog entries are available here.

This and other similar applications will be demonstrated at the upcoming Oracle Open World.

Technorati: totd oracle database glassfish v3 jruby rails oow

Posted by Arun Gupta in General  |  Comments[0]

TOTD #110: JRuby on Rails application using Oracle on GlassFish

GlassFish v3 is the Reference Implementation for Java EE 6. Following the "extensibility" principle of Java EE 6, it also allows Ruby-on-Rails, Groovy and Grails and Python/Django applications to be seamlessly deployed as well, without any additional packaging. This blog has published multiple entries on deploying a Rails application on GlassFish as given below:

• TOTD #105: Monitor Rails application using JavaScript
• TOTD #104: Redmine, Typo, Substruct on GlassFish v3
• TOTD #84: Apache + mod_proxy_balancer to load balance Rails applications on GlassFish
• TOTD #81: nginx to load balance Rails applications on GlassFish Gem
• TOTD #73: Deploying Rails application as WAR on GlassFish v2.1
• TOTD #72: Deploying Rails application on GlassFish v3
• TOTD #70: Deploying Rails application on GlassFish Gem

All the existing applications have used JavaDB, SQLite3, or MySQL as the database so far. In the process of getting ready for the upcoming Oracle Open World 2009, this Tip Of The Day will show how to use an Oracle database with a JRuby-on-Rails application deployed on GlassFish v3.

Lets get started!

1. Install Oracle database as explained in TOTD #106.
2. Configure JRuby/Rails in GlassFish v3 using one of the mechanisms explained in TOTD #104. Alternatively you can also install the GlassFish gem as:
   

   >./bin/jruby -S gem install glassfish
   JRuby limited openssl loaded. gem install jruby-openssl for full support.
   http://wiki.jruby.org/wiki/JRuby_Builtin_OpenSSL
   Successfully installed rack-1.0.0
   Successfully installed glassfish-0.9.5-universal-java
   2 gems installed
   Installing ri documentation for rack-1.0.0...
   Installing ri documentation for glassfish-0.9.5-universal-java...
   Installing RDoc documentation for rack-1.0.0...
   Installing RDoc documentation for glassfish-0.9.5-universal-java...
   

   
   This blog will use GlassFish Gem for running the application described below.
3. Create a new database user and grant rights using SQL*Plus as shown:
   

   Macintosh-187:~ oracle$ sqlplus "/ as sysdba"
   SQL*Plus: Release 10.2.0.4.0 - Production on Thu Oct 1 12:32:33 2009
   
   Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
   
   
   Connected to:
   Oracle Database 10g Release 10.2.0.4.0 - Production
   
   SQL> CREATE USER glassfish IDENTIFIED BY glassfish DEFAULT tablespace users TEMPORARY tablespace temp;
   
   User created.
   
   SQL> GRANT CONNECT TO glassfish IDENTIFIED BY glassfish;
   
   Grant succeeded.
   
   SQL> GRANT UNLIMITED TABLESPACE TO glassfish;
   
   Grant succeeded.
   
   SQL> GRANT CREATE TABLE TO glassfish;
   
   Grant succeeded.
   
   SQL> GRANT CREATE SEQUENCE TO glassfish;
   
   Grant succeeded.
   SQL> exit
   Disconnected from Oracle Database 10g Release 10.2.0.4.0 - Production
   
   

   The user name and password are chosen as "glassfish" for simplicity. This is not a recommended setting for production usage though.
4. Copy Oracle JDBC drivers (odjc6.jar) in JRUBY_HOME/lib directory.
5. Create a simple Rails application
   1. Make sure the following gems are pre-installed:
      

      rails (2.3.4)
      activerecord-jdbc-adapter (0.9.2)
      glassfish (0.9.5)
      

      
      If not, then install them as:

      jruby -S gem install rails activercord-jdbc-adapter glassfish
      

   2. Create a simple Rails application as:
      

      jruby -S rails bookstore -d oracle
      

      
      
   3. Using the normal "jdbc" adapter will give the following error later:
      
      

      ActionView::TemplateError (book_url failed to generate from {:controller=>"books", :action=>"show", :id=>#<Book id: #<BigDecimal:3feef1eb,'10000.0',1(8)>, title: "Ultramarathon Man", author: "Dean Karnazes", created_at: "2009-10-06 00:03:14", updated_at: "2009-10-06 00:03:14">}, expected: {:controller=>"books", :action=>"show"}, diff: {:id=>#<Book id: #<BigDecimal:459bdb65,'10000.0',1(8)>, title: "Ultramarathon Man", author: "Dean Karnazes", created_at: "2009-10-06 00:03:14", updated_at: "2009-10-06 00:03:14">}) on line #13 of app/views/books/index.html.erb:
      

      
      
      As evident, the "id" column is returned as BigDecimal where as it should be integer. Fortunately the fix is simple, install the "oracle_enhanced_adapter" (docs) as:
      
      

      bookstore >~/tools/jruby/bin/jruby -S gem install activerecord-oracle_enhanced-adapter
      JRuby limited openssl loaded. gem install jruby-openssl for full support.
      http://wiki.jruby.org/wiki/JRuby_Builtin_OpenSSL
      Successfully installed activerecord-oracle_enhanced-adapter-1.2.2
      1 gem installed
      Installing ri documentation for activerecord-oracle_enhanced-adapter-1.2.2...
      Installing RDoc documentation for activerecord-oracle_enhanced-adapter-1.2.2...
      

      
      Using this "enhanced adapter" is highly recommended for connecting with Oracle databases from Rails applications.
   4. Edit "config/database.yml" and change the "development" section to:
      

      development:
       adapter: oracle_enhanced
       host: localhost
       database: orcl
       username: glassfish
       password: glassfish
      

      
      Notice, the username and password values are the same as chosen in the SQL statements above.
   5. Generate a scaffold as:
      
      

      bookstore >~/tools/jruby/bin/jruby script/generate scaffold book title:string author:string
      JRuby limited openssl loaded. gem install jruby-openssl for full support.
      http://wiki.jruby.org/wiki/JRuby_Builtin_OpenSSL
       exists app/models/
       exists app/controllers/
       exists app/helpers/
       create app/views/books
       exists app/views/layouts/
       exists test/functional/
       exists test/unit/
       create test/unit/helpers/
       exists public/stylesheets/
       create app/views/books/index.html.erb
       create app/views/books/show.html.erb
       create app/views/books/new.html.erb
       create app/views/books/edit.html.erb
       create app/views/layouts/books.html.erb
       create public/stylesheets/scaffold.css
       create app/controllers/books_controller.rb
       create test/functional/books_controller_test.rb
       create app/helpers/books_helper.rb
       create test/unit/helpers/books_helper_test.rb
       route map.resources :books
       dependency model
       exists app/models/
       exists test/unit/
       exists test/fixtures/
       create app/models/book.rb
       create test/unit/book_test.rb
       create test/fixtures/books.yml
       create db/migrate
       create db/migrate/20091005233152_create_books.rb
      
      

   6. Prepare your application for JDBC as:
      

      bookstore >~/tools/jruby/bin/jruby script/generate jdbc
      JRuby limited openssl loaded. gem install jruby-openssl for full support.
      http://wiki.jruby.org/wiki/JRuby_Builtin_OpenSSL
       exists config/initializers
       create config/initializers/jdbc.rb
       exists lib/tasks
       create lib/tasks/jdbc.rake
      

      
      
   7. Migrate the database as:
      

      ~/samples/v3/rails/oracle/bookstore >~/tools/jruby/bin/jruby -S rake db:migrate
      (in /Users/arungupta/samples/v3/rails/oracle/bookstore)
      == CreateBooks: migrating ====================================================
      -- create_table(:books)
       -> 0.0740s
       -> 0 rows
      == CreateBooks: migrated (0.0750s) ===========================================
      

      
      
6. Lets run the application as:
   

   ~/samples/v3/rails/oracle/bookstore >~/tools/jruby/bin/jruby -S glassfish -l
   Starting GlassFish server at: 129.145.133.197:3000 in development environment...
   Writing log messages to: /Users/arungupta/samples/v3/rails/oracle/bookstore/log/development.log.
   Press Ctrl+C to stop.
   Oct 6, 2009 9:45:51 AM com.sun.enterprise.v3.services.impl.GrizzlyProxy start
   INFO: Listening on port 3000
   
   . . .
   

   
   
   he application is now accessible at "http://localhost:3000/books" and looks like:
   
   
   
   Click on "New Book" and enter the values as shown:
   
   
   
   Click on "Create" to see the output as:
   
   
   
   Click on "Back" to see the main page as:
   
   
   
   After adding another book, this page looks like:
   
   
   
   And another book ...
   
   
   
   

So we created a brand new JRuby/Rails application and ran it using GlassFish and Oracle backend. A subsequent blog entry will show how to create a similar application using an existing database.

A complete archive of all the TOTDs is available here. The complete list of Rails blog entries are available here.

This and other similar applications will be demonstrated at the upcoming Oracle Open World.

Technorati: totd oracle database glassfish v3 jruby rails oow

Posted by Arun Gupta in General  |  Comments[0]

TOTD #109: How to convert a JSF managed bean to JSR 299 bean (Web Beans) ?

This entry is a follow up to TOTD #95 and shows how to use the recent integrations of JSR 299 in GlassFish v3 to convert a JSF managed bean to a JSR 299 bean (aka Web Beans). The TOTD #95 describes a simple Java EE 6 web application that uses Java Server Faces 2.0 components for displaying the results of a database query conducted by EJB 3.1 and JPA 2.0 classes.

The EJB class, which also acts as the JSF managed bean, looks like:

@javax.ejb.Stateless
@ManagedBean
public class StateList {
  @PersistenceUnit
  EntityManagerFactory emf;

  public List getStates() {
    return    emf.createEntityManager().createNamedQuery(”States.findAll”).getResultList();
  }
}

Three changes are required to convert this class into a JSR 299 compliant bean (Web Bean) as listed below:

1. Add an empty "beans.xml" to the WEB-INF directory.
2. Replace "@ManagedBean" with "@javax.inject.Named annotation". "@javax.inject" annotations are defined by JSR 330.
3. Resource injection does not work with JPA classes, yet, so populate EntityManager explicitly as explained below:
   1. Replace EntityManagerFactory resource injection:
      
      

      @PersistenceUnit
      EntityManagerFactory emf;
      

      
      with:
      

      EntityManager emf = Persistence.createEntityManagerFactory("HelloEclipseLinkPU");
      

   2. Add the required entity classes explicitly to "persistence.xml". If the persistence unit is injected then the container automatically scans the web application root for any entity classes.
      1. Expand "Configuration Files" and edit "persistence.xml".
      2. Uncheck "Include All Entity Classes in ..." check box.
      3. Click on "Add Class...", select "state.States", and click on "OK".
         
         

That's it, re-deploy your application and now you are using the Web Beans integration in GlassFish v3 instead of JSF managed bean. The output is available at "http://localhost:8080/HelloEclipseLink/forwardToJSF.jsp" as shown:



This is the exact same output as shown in TOTD #95.

Now, one-by-one, JPA, EJB, Transactions and other components will start working. Read Roger's blog for another example of Web Beans in GlassFish.

A complete archive of all the tips is available here.

Technorati: totd glassfish v3 mysql javaee6 javaserverfaces webbeans jsr299 netbeans

Posted by Arun Gupta in General  |  Comments[2]

TOTD #108: Java EE 6 web application (JSF 2.0 + JPA 2.0 + EJB 3.1) using Oracle, NetBeans, and GlassFish

TOTD #106 explained how to install Oracle database 10g R2 on Mac OS X. TOTD #107 explained how to connect this Oracle database using NetBeans. This Tip Of The Day will explain how to use the sample HR database (that comes with Oracle database server) to write a simple Java EE 6 application.

This application will use Java Server Faces 2.0 for displaying the results, Enterprise Java Beans 3.1 + Java Persistence API 2.0 for middle tier, and Oracle database server + GlassFish v3 as the backend. The latest promoted build (65 of this writing) will not work because of the issue #9885 so this blog will use build 63 instead.

Several improvements have been made over NetBeans 6.8 M1 build and this blog is using the nightly build of 9/27. The environment used in this blog is:

• NetBeans 9/27 nightly
• GlassFish v3 build 63
• Oracle database server 10.2.0.4.0 R2 on Mac OS X
• Oracle JDBC Driver type 4 (ojdbc6.jar)

Lets get started!

1. Configure GlassFish v3 with JDBC connection
   1. Download and unzip build 63.
   2. Download ojdbc6.jar and copy to "glassfishv3/glassfish/domains/domain1/lib/ext" directory.
   3. Start the Application Server as:
      

      ./bin/asadmin start-domain --verbose &
      

   4. Create a JDBC connection pool as:
      

      ./bin/asadmin create-jdbc-connection-pool --datasourceclassname oracle.jdbc.pool.OracleDataSource --restype javax.sql.DataSource --property "User=hr:Password=hr:URL=jdbc\:oracle\:thin\:@localhost\:1521\:orcl" jdbc/hr
      

      
      and verify the connection pool as:
      

      ./bin/asadmin ping-connection-pool jdbc/hr
      

   5. Create a JDBC resource as:

      ./bin/asadmin create-jdbc-resource --connectionpoolid jdbc/hr jdbc/hr
      

2. Configure GlassFish v3 build 63 in NetBeans
   1. In NetBeans IDE "Services" panel, right-click on "Servers" and click on "Add Server...". Choose "GlassFish v3" and provide a name as shown below:
      
      
      
   2. Click on "Next >" and specify the unzipped GlassFish location as:
      
      
      
      and click on "Finish".
3. Create the Java EE 6 application
   1. In "Projects" pane, right-click and select "New Project...".
   2. Choose "Java Web" and "Web Application" and click on "Next". Choose the project name as "HelloOracle":
      
      
      
      and click on "Next >".
   3. Select the recently added GlassFish v3 server and choose "Java EE 6 Web" profile:
      
      
      
      and click on "Next >". Notice "Java EE 6 Web" profile is chosen as the Java EE version.
   4. Select "JavaServer Faces" on the frameworks page:
      
      
      
      and click on "Finish". Notice the JSF libraries bundled with the App Server are used.
4. Create the Java Persistence Unit
   1. Right-click on the project, select "New", "Entity Classes from Database...":
      
      
      
   2. From the Data Source, select "jdbc/hr" as shown:
      
      
      
      This is the same JDBC resource created earlier. Select "EMPLOYEES" from the Available Table, click on "Add >" to see the output as:
      
      
      
      The related tables are automatically included. Click on "Next >".
   3. Click on "Create Persistence Unit ..." and take all the defaults and click on "Create".
   4. Specify the package name as "model":
      
      
      
      and click on "Finish". This generates a JPA-compliant POJO class that provide access to tables in the underlying Oracle database. The class name corresponding to each table is shown in the wizard.
5. Create Enterprise Java Beans
   1. Right-click on the project and select "New Class...".
   2. Specify the class name as "EmployeesBean" and package as "controller", click on "Finish".
   3. Annotate the class to make it an Enterprise Java Bean and a JSF Managed Bean as:
      

      @javax.ejb.Stateless
      @javax.faces.bean.ManagedBean
      

      
      
      Notice, the EJB is bundled in the WAR file and no special type of modules are required. Java EE 6 provides simplified packaging of EJB which makes it really ease to use.
      
      Also this application is currently using JSF managed bean but will use JSR 299 (aka Web Beans) in a future blog.
   4. Inject the Persistence Unit by adding the following variable:

      @PersistenceUnit
      EntityManagerFactory emf;
      

   5. Add a new method to retrieve the list of all employees as:
      

      public List getEmployees() {
       return em.createNamedQuery("Employees.findAll").getResultList();
      }
      

      
      "Employees.findAll" is a default NamedQuery generated by NetBeans and makes it easy to query the database. Several other queries are generated for each mapped JPA class, such as "Employees.findByEmployeeId" and "Employees.findByFirstName". Custom queries can also be created and specified on the POJO class.
      
      The completed class looks like:
      

      @Stateless
      @ManagedBean
      public class EmployeesBean {
      
       @PersistenceContext
       EntityManager em;
      
       public List getEmployees() {
       return em.createNamedQuery("Employees.findAll").getResultList();
       }
      }
      

6. Use EJB in the generated JSF page
   1. JSF 2 uses Facelets as the templating mechanism and NetBeans generate a simple "index.xhtml" file to start with. Expand "Web Pages" and open "index.xhtml".
   2. Replace the body template with:
      

      <h1>First Java EE 6 app using Oracle database</>
      <h:dataTable var="emp" value="#{employeesBean.employees}" border="1">
       <h:column><h:outputText value="#{emp.lastName}"/>, <h:outputText value="#{emp.firstName}"/></h:column>
       <h:column><h:outputText value="#{emp.email}"/></h:column>
       <h:column><h:outputText value="#{emp.hireDate}"/></h:column>
       </h:dataTable>
      

      
      It uses JSF value expressions to bind the Enterprise Java Bean and dumps the HTML formatted name, email, and hire date of each employee in the database.
7. Run the project: Right-click on the project and select "Run" to see the output at "http://localhost:8080/HelloOracle/" as:
   
   

So we can easily create a Java EE 6 application using NetBeans, Oracle, and GlassFish.

A complete archive of all the TOTDs is available here.

This and other similar applications will be demonstrated at the upcoming Oracle Open World.

Technorati: totd oracle database glassfish v3 javaee javaserverfaces ejb jpa netbeans oow

Posted by Arun Gupta in General  |  Comments[0]

TOTD #107: Connect to Oracle database using NetBeans

TOTD #106 explained how to install Oracle database 10g R2 on Mac OS X. This Tip Of The Day will explain how to connect Oracle database with NetBeans to leverage all the goodness provided by NetBeans for Java EE application development, Rails, and others.

1. Download Oracle JDBC Drivers, specifically ojdbc14.jar. (ojdbc6.jar is recommended to be used with GlassFish v3).
2. Using NetBeans 6.8 M1, in Services tab, right-click on "Databases" and select "New Connection..." as shown:
   
   
   
3. Expand "Name:" and select "New Driver...":
   
   
   
4. Click on "Add..." and choose the recently downloaded JDBC driver JAR file as shown below:
   
   
   
   and click on "OK".
   
5. Enter the database values as shown below:
   
   
   
   The password is "hr" for the sample HR database. Clicking on "Show JDBC URL" also shows the complete JDBC URL. Click on "OK".
   
   You may have to unlock the "hr" user by giving the command:
   

   ALTER USER HR IDENTIFIED BY hr ACCOUNT UNLOCK;
   

   as explained in TOTD #106.
6. Select the "HR" schema as shown below:
   
   
   
   and click on "OK". The complete list of schemas is now shown in the "Databases" node as shown below:
   
   
7. Expand the "HR" node and the complete list of tables is visible now:
   
   
   
   Expanding each table shows you the complete definition as shown:
   
   
8. Right-click on "COUNTRIES" table and select "View Data..."
   
   
   
   and the result is shown as:
   
   
   
   Additionally, you can execute any SQL command by selecting "Execute Command...":
   
   

A complete archive of all the TOTDs is available here.

Subsequent blogs will show how to write a Java EE application to access the Oracle database.

Technorati: totd oracle database netbeans

Posted by Arun Gupta in General  |  Comments[0]

TOTD #106: How to install Oracle Database 10g on Mac OS X (Intel) ?

This Tip Of The Day (TOTD) will explain how to install Oracle Database 10g on Mac OS X.

The official documentation is available here and is very well suited for folks with lots of time and patience. But all I wanted was to install Oracle database server up & running on my localhost so that I can start experimenting with it. All my previous entries have used either JavaDB or MySQL so far, but it's about time ;-)

I started preparing a brief tutorial after following the lengthy documentation but then found this excellent blog entry. And realized the content is looking exactly similar :-) Anyway, below are the instructions I followed and additionally also provide a snapshot of the installer windows.

For the brave of heart, complete installation guide is available in HTML and PDF. Read on for an abbreviated, and yet working version, of the instructions.

1. Download Oracle database 10g R2 (10.2.0.4.0) from here and unzip.
2. Check hardware/software requirements. (10.5.4+ required)
3. Create required groups/users (complete details):
4. 1. Create Oracle inventory group as:
      
      

      # dscl . -create /groups/oinstall
      # dscl . -append /groups/oinstall gid 100
      # dscl . -append /groups/oinstall passwd "*"
      

   2. Create Oracle software owner as:

      # dscl . -create /users/oracle
      # dscl . -append /users/oracle uid uid_number
      # dscl . -append /users/oracle gid oinstall_gid
      # dscl . -append /users/oracle shell /bin/bash
      # dscl . -append /users/oracle home /Users/oracle
      # dscl . -append /users/oracle realname "Oracle software owner"
      

   3. Create the home directory for Oracle user as:

      # mkdir /Users/oracle
      # chown oracle:oinstall /Users/oracle
      

   4. Set the password for Oracle user:

      # passwd oracle
      

5. Configure kernel parameters (complete details) by editing "/etc/sysctl.conf" and adding the contents:

   kern.sysv.semmsl=87381
   kern.sysv.semmns=87381
   kern.sysv.semmni=87381
   kern.sysv.semmnu=87381
   kern.sysv.semume=10
   kernel.shmall=2097152
   kernel.sys.shmmax=2147483648
   kernel.sys.shmmni=4096
   kern.maxfiles=65536
   kern.maxfilesperproc=65536
   net.inet.ip.portrange.first=1024
   net.inet.ip.portrange.last=65000
   kern.corefile=core
   kern.maxproc=2068
   kern.maxprocperuid=2068
   

   and reboot the machine for these parameters to take effect.
6. Configure Oracle user's environment (complete details). In the "oracle" user's home directory, create ".bash_profile" and add the following lines:

   export DISPLAY=:0.0
   export ORACLE_BASE=$HOME
   export ORACLE_SID=orcl
   umask 022
   ulimit -Hn 65536
   ulimit -Sn 65536
   

7. The "Basic Installation" of "Standard Edition" in an "Interactive" mode can be performed using the "Oracle Universal Installer". This installer is invoked using the script "db/Disk01/runInstaller" (complete details). The screen snapshots are shown below:
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   Choose "oracle" as the database password for simplicity.
   
   
   
   
   
   and finally click on "Install" to begin the installation.
   
   
   
   
   
   
   
   
   
   Click on "Password Management..." to unlock the sample database user ...
   
   
   
   
   
   The output of these scripts look like:

   ~ > sudo /Users/oracle/oraInventory/orainstRoot.sh
   Changing permissions of /Users/oracle/oraInventory to 770.
   Changing groupname of /Users/oracle/oraInventory to oinstall.
   The execution of the script is complete

   
   and
   

   ~ > sudo /Users/oracle/product/10.2.0/db_1/root.sh
   Running Oracle 10g root.sh script ...
   
   The following environment variables are set as:
        ORACLE_OWNER= oracle
        ORACLE_HOME= /Users/oracle/oracle/product/10.2.0/db_1
   Enter the full pathname of the local bin directory: [/usr/local/bin]:
       Copying dbhome /usr/local/bin ...
       Copying oraenv to /usr/local/bin ...
       Copying coraenv to /usr/local/bin ...
   Creating /etc/oratab file...
   Entries will be added to the /etc/oratab file as needed by
   Database Configuration Assistant when a database is created
   Finished running generic part of root.sh script.
   Now product-specific root actions will be performed.

   
   
   
   
   Click on "Installed Products..." to see the list of Oracle products installed.
   
   
8. There are some more steps before you can start the Oracle listener process.
1. Edit ".bash_profile" of "oracle" user and add the following settings:

   export ORACLE_HOME=/Users/oracle/oracle/product/10.2.0/db_1
   export PATH=$PATH:$ORACLE_HOME/bin
   export DYLD_LIBRARY_PATH=$ORACLE_HOME/lib

   Not setting DYLD_LIBRARY_PATH gives the following error:

   ~ oracle$ lsnrctl start
   dyld: Library not loaded: /b/227/network/lib/libnnz10.dylib
     Referenced from: /Users/oracle/oracle/product/10.2.0/db_1/bin/lsnrctl
     Reason: image not found
   Trace/BPT trap

   This was not obvious but Googling helped. Make sure to relogin for these changes to take effect.
2. If your Mac is using DHCP (most likely) then you may see the error shown below:

   ~ oracle$ lsnrctl start
   
   LSNRCTL for MacOS X Server: Version 10.2.0.4.0 - Production on 28-SEP-2009 14:48:49
   
   Copyright (c) 1991, 2007, Oracle.  All rights reserved.
   
   Starting /Users/oracle/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
   
   TNSLSNR for MacOS X Server: Version 10.2.0.4.0 - Production
   System parameter file is /Users/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
   Log messages written to /Users/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
   Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
   Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dhcp-usca14-133-197.SFBay.Sun.COM)(PORT=1521)))
   TNS-12545: Connect failed because target host or object does not exist
    TNS-12560: TNS:protocol adapter error
     TNS-00515: Connect failed because target host or object does not exist
      MacOS X Server Error: 49: Can't assign requested address
   
   Listener failed to start. See the error message(s) above...

   
   
   This error occurs because your MacBook may be running on a different IP address if rebooted after the installation and before starting the server. Fortunately, the error message is very intuitive and it's easy to fix the error by editing "$ORACLE_HOME/network/admin/listener.ora" as shown below:

   # listener.ora Network Configuration File: /Users/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
   # Generated by Oracle configuration tools.
   
   SID_LIST_LISTENER =
     (SID_LIST =
       (SID_DESC =
         (SID_NAME = PLSExtProc)
         (ORACLE_HOME = /Users/oracle/oracle/product/10.2.0/db_1)
         (PROGRAM = extproc)
       )
       (SID_DESC =
         (SID_NAME = orcl)
         (ORACLE_HOME = /Users/oracle/oracle/product/10.2.0/db_1)
       )
     )
   
   LISTENER =
     (DESCRIPTION_LIST =
       (DESCRIPTION =
         (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
         (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
       )
     )
   

   
   The changes are highlighted in the bold. Basically, add a new SID referring to "orcl". And for DHCP users the value of HOST key needs to be changed from dynamically assigned IP address to "localhost". Strangely, the Installing on DHCP Computers section of the installation guide says nothing about it :(
3. Additionally, for DHCP users, you need to change "$ORACLE_HOME/network/admin/tnsnames.ora" as:

   # tnsnames.ora Network Configuration File: /Users/oracle/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
   # Generated by Oracle configuration tools.
   
   ORCL =
     (DESCRIPTION =
       (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
       (CONNECT_DATA =
         (SERVER = DEDICATED)
         (SERVICE_NAME = orcl)
       )
     )

   The changes are highlighted in bold. And here as well change the value of HOST key to "localhost".
9. And finally, start the database using SQL*Plus as:

   ~ oracle$ sqlplus "/ as sysdba"
   
   SQL*Plus: Release 10.2.0.4.0 - Production on Mon Sep 28 17:44:40 2009
   
   Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
   Connected to an idle instance.
   
   SQL> startup nomount
   ORACLE instance started.
   
   Total System Global Area  612368384 bytes
   Fixed Size                  2085872 bytes
   Variable Size             167775248 bytes
   Database Buffers          436207616 bytes
   Redo Buffers                6299648 bytes
   SQL> alter database mount;
   
   Database altered.
   SQL> alter database open;
   Database altered.
   
   SQL> ALTER USER HR IDENTIFIED BY hr ACCOUNT UNLOCK;
   User altered.
   
   SQL> exit
   Disconnected from Oracle Database 10g Release 10.2.0.4.0 - Production

   The last step of unlocking the account should not be required because we explicitly unlocked the account during installation but that apparently didn't work. And I hit ORA-01033, ORA-01034, ORA-12514, ORA-12541, ORA-12547, and ORA-27101 trying different combinations to get the app working.
   
   Anyway now re-connect to the HR sample database as:

   
   ~ oracle$ sqlplus hr/hr@orcl
   
   SQL*Plus: Release 10.2.0.4.0 - Production on Mon Sep 28 17:46:19 2009
   
   Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
   
   Connected to:
   Oracle Database 10g Release 10.2.0.4.0 - Production
   
   SQL> select table_name from user_tables;
   TABLE_NAME
   ------------------------------
   REGIONS
   LOCATIONS
   DEPARTMENTS
   JOBS
   COUNTRIES
   EMPLOYEES
   JOB_HISTORY
   
   7 rows selected.
   
   SQL> desc regions;
    Name                                      Null?    Type
    ----------------------------------------- -------- ----------------------------
    REGION_ID                                 NOT NULL NUMBER
    REGION_NAME                                        VARCHAR2(25)
   
   SQL> select * from regions;
    REGION_ID REGION_NAME
   ---------- -------------------------
            1 Europe
            2 Americas
            3 Asia
            4 Middle East and Africa
   

   
   Note: If the database is not shutdown properly then it can be forced to do so using the command "shutdown abort" using SQL*Plus.

A complete archive of all the tips is available here.

Posted by Arun Gupta in General  |  Comments[0]

TOTD #105: GlassFish v3 Monitoring – How to monitor a Rails app using asadmin, JavaScript, jConsole, REST ?

Monitoring infrastructure in GlassFish v3 is getting an extreme makeover. Prashanth defines it very nicely in his detailed introduction:

We provide a way to dynamically and non-intrusively generate monitoring events from any of the GlassFish runtime classes, the ability to listen to these events, collect the statistics and expose these statistics through various standard clients.

The "dynamic" nature indicates that monitoring can be turned ON or OFF in a GlassFish instance running in production environment. It also means the granularity to which the monitoring information can be generated. This information can be generated for not only a traditional Java EE applications, but Rails, Django and other type of applications that can be easily deployed on GlassFish v3. And that is extensible for other pluggable containers too. The data can be accessed using multiple mechanisms providing the administrator a wide variety of choice for tools, e.g. DTrace, JMX, REST, asadmin CLI, and Admin Console and thus another point in favor of "dynamic".

The "non-intrusive" behavior means that monitoring can be used in production environment with minimal overhead. It also means that there is no overhead when monitoring is not enabled. Anyway, monitoring needs to be explicitly enabled as explained below.

As mentioned above, there are multiple ways to access the monitoring data. The different ways to access the monitoring data are:

1. DTrace scripts (only on Solaris)
2. asadmin CLI
3. Admin Console
4. JMX/jConsole
5. REST
6. Custom client using a 3rd party scripting language (available as value-add feature to paid customers only)

This Tip Of The Day will describe how to access the monitoring data using asadmin CLI and a JavaScript client. Note that the JavaScript client feature is available as a value-add to the community version of GlassFish and available only to the paid customers.

This tip will use a pre-deployed Rails application as (Redmine as described in TOTD #104) on a nightly GlassFish v3 build (CI, nightly, or promoted) and explains how to monitor this application.

Using the terminology defined in Monitoring in GlassFish v3 blog, the JRuby subsystem in GlassFish has multiple probe providers and each provider has multiple probes. The JRuby subsystem also provides multiple stats providers with probe listeners. All of these elements are linked using the monitoring infrastructure in GlassFish.

Lets monitor our Rails application

Monitoring using asadmin CLI

By default the monitoring is turned OFF for all the components. Lets enable monitoring for the JRuby container as:

asadmin enable-monitoring --level jruby-container=HIGH

The other possible values are "LOW" and "OFF". All the probes publishing monitoring data can be listed as:

~/tools/glassfish/v3/9-18/glassfishv3 >./bin/asadmin list --monitor=true "*"
server
server.containers
server.containers.jruby
server.containers.jruby.applications
server.containers.jruby.http
server.containers.jruby.http.redmine-0.8.5
server.containers.jruby.runtime-pool
server.containers.jruby.runtime-pool.redmine-0.8.5

Command list executed successfully.

A snapshot of the monitoring data can be obtained as:

~/tools/glassfish/v3/9-18/glassfishv3 >./bin/asadmin get --monitor=true "*jruby*"
server.containers.jruby.applications.activerubyapplications.redmine-0.8.5-appName = redmine-0.8.5
server.containers.jruby.applications.activerubyapplications.redmine-0.8.5-description =
 server.containers.jruby.applications.activerubyapplications.redmine-0.8.5-environment = development
server.containers.jruby.applications.activerubyapplications.redmine-0.8.5-jrubyVersion = 1.3.0
server.containers.jruby.applications.activerubyapplications.redmine-0.8.5-lastsampletime = 1253322280437
server.containers.jruby.applications.activerubyapplications.redmine-0.8.5-name = redmine-0.8.5
server.containers.jruby.applications.activerubyapplications.redmine-0.8.5-rubyFramework = rails
server.containers.jruby.applications.activerubyapplications.redmine-0.8.5-starttime = 1253322280437
server.containers.jruby.applications.activerubyapplications.redmine-0.8.5-unit =
server.containers.jruby.applications.activerubyappscount-count = 1
server.containers.jruby.applications.activerubyappscount-description = Number of currently loaded Ruby applications
server.containers.jruby.applications.activerubyappscount-lastsampletime = 1253322279921
server.containers.jruby.applications.activerubyappscount-name = ActiveRubyApplications
server.containers.jruby.applications.activerubyappscount-starttime = 1253322279922
server.containers.jruby.applications.activerubyappscount-unit = count
server.containers.jruby.http.redmine-0.8.5.address = null
server.containers.jruby.http.redmine-0.8.5.averageprocessingtime = 0
server.containers.jruby.http.redmine-0.8.5.count200-count = 0
server.containers.jruby.http.redmine-0.8.5.count200-description = Number of responses with a status code equal to 200
server.containers.jruby.http.redmine-0.8.5.count200-lastsampletime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count200-name = Count200
server.containers.jruby.http.redmine-0.8.5.count200-starttime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count200-unit = count
server.containers.jruby.http.redmine-0.8.5.count2xx-count = 0
server.containers.jruby.http.redmine-0.8.5.count2xx-description = Number of responses with a status code in the 2xx range
server.containers.jruby.http.redmine-0.8.5.count2xx-lastsampletime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count2xx-name = Count2xx
server.containers.jruby.http.redmine-0.8.5.count2xx-starttime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count2xx-unit = count
server.containers.jruby.http.redmine-0.8.5.count302-count = 0
server.containers.jruby.http.redmine-0.8.5.count302-description = Number of responses with a status code equal to 302
server.containers.jruby.http.redmine-0.8.5.count302-lastsampletime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count302-name = Count302
server.containers.jruby.http.redmine-0.8.5.count302-starttime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count302-unit = count
server.containers.jruby.http.redmine-0.8.5.count304-count = 0
server.containers.jruby.http.redmine-0.8.5.count304-description = Number of responses with a status code equal to 304
server.containers.jruby.http.redmine-0.8.5.count304-lastsampletime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count304-name = Count304
server.containers.jruby.http.redmine-0.8.5.count304-starttime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count304-unit = count
server.containers.jruby.http.redmine-0.8.5.count3xx-count = 0
server.containers.jruby.http.redmine-0.8.5.count3xx-description = Number of responses with a status code in the 3xx range
server.containers.jruby.http.redmine-0.8.5.count3xx-lastsampletime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count3xx-name = Count3xx
server.containers.jruby.http.redmine-0.8.5.count3xx-starttime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count3xx-unit = count
server.containers.jruby.http.redmine-0.8.5.count400-count = 0
server.containers.jruby.http.redmine-0.8.5.count400-description = Number of responses with a status code equal to 400
server.containers.jruby.http.redmine-0.8.5.count400-lastsampletime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count400-name = Count400
server.containers.jruby.http.redmine-0.8.5.count400-starttime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count400-unit = count
server.containers.jruby.http.redmine-0.8.5.count401-count = 0
server.containers.jruby.http.redmine-0.8.5.count401-description = Number of responses with a status code equal to 401
server.containers.jruby.http.redmine-0.8.5.count401-lastsampletime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count401-name = Count401
server.containers.jruby.http.redmine-0.8.5.count401-starttime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count401-unit = count
server.containers.jruby.http.redmine-0.8.5.count403-count = 0
server.containers.jruby.http.redmine-0.8.5.count403-description = Number of responses with a status code equal to 403
server.containers.jruby.http.redmine-0.8.5.count403-lastsampletime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count403-name = Count403
server.containers.jruby.http.redmine-0.8.5.count403-starttime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count403-unit = count
server.containers.jruby.http.redmine-0.8.5.count404-count = 0
server.containers.jruby.http.redmine-0.8.5.count404-description = Number of responses with a status code equal to 404
server.containers.jruby.http.redmine-0.8.5.count404-lastsampletime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count404-name = Count404
server.containers.jruby.http.redmine-0.8.5.count404-starttime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count404-unit = count
server.containers.jruby.http.redmine-0.8.5.count4xx-count = 0
server.containers.jruby.http.redmine-0.8.5.count4xx-description = Number of responses with a status code in the 4xx range
server.containers.jruby.http.redmine-0.8.5.count4xx-lastsampletime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count4xx-name = Count4xx
server.containers.jruby.http.redmine-0.8.5.count4xx-starttime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count4xx-unit = count
server.containers.jruby.http.redmine-0.8.5.count503-count = 0
server.containers.jruby.http.redmine-0.8.5.count503-description = Number of responses with a status code equal to 503
server.containers.jruby.http.redmine-0.8.5.count503-lastsampletime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count503-name = Count503
server.containers.jruby.http.redmine-0.8.5.count503-starttime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count503-unit = count
server.containers.jruby.http.redmine-0.8.5.count5xx-count = 0
server.containers.jruby.http.redmine-0.8.5.count5xx-description = Number of responses with a status code in the 5xx range
server.containers.jruby.http.redmine-0.8.5.count5xx-lastsampletime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count5xx-name = Count5xx
server.containers.jruby.http.redmine-0.8.5.count5xx-starttime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.count5xx-unit = count
server.containers.jruby.http.redmine-0.8.5.countother-count = 0
server.containers.jruby.http.redmine-0.8.5.countother-description = Number of responses with other status codes
server.containers.jruby.http.redmine-0.8.5.countother-lastsampletime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.countother-name = CountOther
server.containers.jruby.http.redmine-0.8.5.countother-starttime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.countother-unit = count
server.containers.jruby.http.redmine-0.8.5.errorcount-count = 0
server.containers.jruby.http.redmine-0.8.5.errorcount-description = Number of responses with a status code greater than 400
server.containers.jruby.http.redmine-0.8.5.errorcount-lastsampletime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.errorcount-name = ErrorCount
server.containers.jruby.http.redmine-0.8.5.errorcount-starttime = 1253322280245
server.containers.jruby.http.redmine-0.8.5.errorcount-unit = count
server.containers.jruby.http.redmine-0.8.5.requestcount-count = 0
server.containers.jruby.http.redmine-0.8.5.requestcount-description = Number of HTTP requests received
server.containers.jruby.http.redmine-0.8.5.requestcount-lastsampletime = 1253322280243
server.containers.jruby.http.redmine-0.8.5.requestcount-name = RequestCounter
server.containers.jruby.http.redmine-0.8.5.requestcount-starttime = 1253322280243
server.containers.jruby.http.redmine-0.8.5.requestcount-unit = count
server.containers.jruby.http.redmine-0.8.5.requestpersecond = null
server.containers.jruby.runtime-pool.redmine-0.8.5.activeruntimes-count = 1
server.containers.jruby.runtime-pool.redmine-0.8.5.activeruntimes-description = Currently active runtimes
server.containers.jruby.runtime-pool.redmine-0.8.5.activeruntimes-lastsampletime = 1253322280241
server.containers.jruby.runtime-pool.redmine-0.8.5.activeruntimes-name = activeRuntimes
server.containers.jruby.runtime-pool.redmine-0.8.5.activeruntimes-starttime = 1253322280241
server.containers.jruby.runtime-pool.redmine-0.8.5.activeruntimes-unit = count
server.containers.jruby.runtime-pool.redmine-0.8.5.applicationname = redmine-0.8.5
server.containers.jruby.runtime-pool.redmine-0.8.5.contextpath = /redmine-0.8.5
server.containers.jruby.runtime-pool.redmine-0.8.5.hardmaximum-count = 1
server.containers.jruby.runtime-pool.redmine-0.8.5.hardmaximum-description = Maximum active runtimes
server.containers.jruby.runtime-pool.redmine-0.8.5.hardmaximum-lastsampletime = 1253322280241
server.containers.jruby.runtime-pool.redmine-0.8.5.hardmaximum-name = hardMaximum
server.containers.jruby.runtime-pool.redmine-0.8.5.hardmaximum-starttime = 1253322280241
server.containers.jruby.runtime-pool.redmine-0.8.5.hardmaximum-unit = count
server.containers.jruby.runtime-pool.redmine-0.8.5.hardmminimum-count = 1
server.containers.jruby.runtime-pool.redmine-0.8.5.hardmminimum-description = Minimum active runtimes
server.containers.jruby.runtime-pool.redmine-0.8.5.hardmminimum-lastsampletime = 1253322280241
server.containers.jruby.runtime-pool.redmine-0.8.5.hardmminimum-name = hardMinimum
server.containers.jruby.runtime-pool.redmine-0.8.5.hardmminimum-starttime = 1253322280241
server.containers.jruby.runtime-pool.redmine-0.8.5.hardmminimum-unit = count

Command get executed successfully.

The command asadmin get --monitor=true "*jruby*" dumps a snapshot of the monitoring data such as the number of Ruby currently applications loaded, application name, JRuby version, environment (development / test / production), currently active runtimes, min/max runtimes, number of HTTP requests / responses with a certain HTTP code and much more information. It basically dumps all the JRuby monitoring information captured so far.

An alternate regular expression may be specified such as:

asadmin get --monitor=true "*jruby*runtime-pool*"

Monitoring using JavaScript client

Third-party scripting client are a value-add to the community versions. Just like Enterprise Manager, the value-add will be available as a patch to the users who purchase commercial support. Lets see what can be done with it though.

First of all you can type the command "list-probes" to see a list of all the probes that are available. A typical output will look like:

~/tools/glassfish/v3/9-18/glassfishv3 >./bin/asadmin list-probes
glassfish:kernel:connections-keep-alive:decrementCountConnectionsEvent decrementCountConnectionsEvent(java.lang.String)
glassfish:web:web-module:webModuleStoppedEvent webModuleStoppedEvent(java.lang.String, java.lang.String)
glassfish:jca:connection-pool:connectionValidationFailedEvent connectionValidationFailedEvent(java.lang.String, int)
glassfish:jca:work-management:workWaitedFor workWaitedFor(java.lang.String, long)
glassfish:jdbc:connection-pool:connectionTimedOutEvent connectionTimedOutEvent(java.lang.String)
glassfish:security:ejbpolicy:ejbPCCreationEvent ejbPCCreationEvent(java.lang.String)
glassfish:kernel:thread-pool:threadReturnedToPoolEvent threadReturnedToPoolEvent(java.lang.String, java.lang.String)
glassfish:web:session:sessionPersistedEndEvent sessionPersistedEndEvent(java.lang.String, java.lang.String, java.lang.String)
glassfish:web:http-service:requestStartEvent requestStartEvent(java.lang.String, java.lang.String, java.lang.String, int, java.lang.String, java.lang.String)
glassfish:jdbc:connection-pool:connectionsFreedEvent connectionsFreedEvent(java.lang.String, int)
glassfish:jdbc:connection-pool:toString toString(java.lang.String, java.lang.StringBuffer)
glassfish:jca:connection-pool:decrementFreeConnectionsSizeEvent decrementFreeConnectionsSizeEvent(java.lang.String, int)
glassfish:kernel:connections-keep-alive:incrementCountFlushesEvent incrementCountFlushesEvent(java.lang.String)
glassfish:webservices:109:deploy deploy(com.sun.enterprise.deployment.Application, com.sun.enterprise.deployment.WebServiceEndpoint)
glassfish:jca:connection-pool:connectionAcquiredEvent connectionAcquiredEvent(java.lang.String)
glassfish:web:http-service:requestEndEvent requestEndEvent(java.lang.String, java.lang.String, java.lang.String, int, java.lang.String, java.lang.String, int)
glassfish:kernel:connections-keep-alive:incrementCountRefusalsEvent incrementCountRefusalsEvent(java.lang.String)
glassfish:kernel:connections:connectionConnectedEvent connectionConnectedEvent(java.lang.String, int)
glassfish:kernel:file-cache:addHeapSizeEvent addHeapSizeEvent(java.lang.String, long)
glassfish:jruby:runtime-pool:runtimePoolUpdateEvent runtimePoolUpdateEvent(java.lang.String, int, int, int, int, int)
glassfish:security:web:securityManagerCreationEvent securityManagerCreationEvent(java.lang.String)
glassfish:security:web:securityManagerDestructionEvent securityManagerDestructionEvent(java.lang.String)
glassfish:webservices:ri:undeploy undeploy(com.sun.xml.ws.transport.http.servlet.ServletAdapter)
glassfish:web:session:sessionPersistedStartEvent sessionPersistedStartEvent(java.lang.String, java.lang.String, java.lang.String)
glassfish:ejb:pool:objectAddedEvent ejbObjectAddedEvent()
glassfish:ejb:bean:methodStartEvent ejbMethodStartEvent(java.lang.String, java.lang.String, java.lang.String, java.lang.reflect.Method)
glassfish:jdbc:connection-pool:connectionRequestServedEvent connectionRequestServedEvent(java.lang.String, long)

All the JRuby probes can be easily listed as:

~/tools/glassfish/v3/9-18/glassfishv3 >./bin/asadmin list-probes | grep jruby
glassfish:jruby:runtime-pool:runtimePoolUpdateEvent runtimePoolUpdateEvent(java.lang.String, int, int, int, int, int)
glassfish:jruby:http:requestStartEvent requestStartEvent(java.lang.String, java.lang.String, int)
glassfish:jruby:jruby-container:jrubyModuleStartedEvent jrubyModuleStartedEvent(java.lang.String, java.lang.String, java.lang.String, java.lang.String)
glassfish:jruby:jruby-container:jrubyModuleStoppedEvent jrubyModuleStoppedEvent(java.lang.String, java.lang.String, java.lang.String)
glassfish:jruby:http:requestEndEvent requestEndEvent(java.lang.String, int)
glassfish:jruby:runtime-pool:runtimePoolStartEvent runtimePoolStartEvent(java.lang.String, int, int, int, int, int, int, int)

More detailed information about each probe can be easily found by giving the command:

~/tools/glassfish/v3/9-18/glassfishv3 >./bin/asadmin list-probes --manpage=true glassfish:jruby:runtime-pool:runtimePoolUpdateEvent

This will show the detailed information ("man" pages) about the specific probe. A JavaScript client to monitor the deployed Rails application and gather the relevant statistics can be written using these pages as shown below:

moduleStarted = function(appName, appType, env, jruby) {
    client.print( '\n log> Deployed a \'' + appType + '\' app named \'' + appName + '\' in \'' + env + '\' environment with JRuby \'' + jruby + '\'.');
}

moduleStopped = function(appName, appType, env) {
    client.print( '\n log> Undeployed a \'' + appType + '\' app named \'' + appName + '\' in \'' + env + '\' environment.');
}

requestStarted = function(contextPath, serverName, port) {
    client.print( '\n log> Request started at \'' + contextPath + '\' hosted on \'' + serverName + ':' + port + '\'');
}

requestEnded = function(contextPath, statusCode) {
    client.print( '\n log> Request stopped at \'' + contextPath + '\' with status code \'' + statusCode + '\'');
}

runtimePoolStart = function(appName, activeRuntimes, queueSize) {
   client.print( '\n log> JRuby runtime pool started for the app \'' + appName + '\': active runtime - ' + activeRuntimes + ', queue size - ' + queueSize);
}

runtimePoolUpdate = function(appName, activeRuntimes, queueSize) {
   client.print( '\n log> JRuby runtime pool updated for the app \'' + appName + '\': active runtime - ' + activeRuntimes + ', queue size - ' + queueSize);
}

moduleStartedParams = java.lang.reflect.Array.newInstance(java.lang.String, 4);
moduleStartedParams[0]="appName";
moduleStartedParams[1]="applicationType";
moduleStartedParams[2]="environment";
moduleStartedParams[3]="jrubyVersion";
scriptContainer.registerListener('glassfish:jruby:jruby-container:jrubyModuleStartedEvent', moduleStartedParams, 'moduleStarted');

moduleStoppedParams = java.lang.reflect.Array.newInstance(java.lang.String, 3);
moduleStoppedParams[0]="appName";
moduleStoppedParams[1]="applicationType";
moduleStoppedParams[2]="environment";
scriptContainer.registerListener('glassfish:jruby:jruby-container:jrubyModuleStoppedEvent', moduleStoppedParams, 'moduleStopped');

requestStartParams = java.lang.reflect.Array.newInstance(java.lang.String, 3);
requestStartParams[0]="contextPath";
requestStartParams[1]="serverName";
requestStartParams[2]="port";
scriptContainer.registerListener('glassfish:jruby:http:requestStartEvent', requestStartParams, 'requestStarted');

requestEndParams = java.lang.reflect.Array.newInstance(java.lang.String, 2);
requestEndParams[0]="contextPath";
requestEndParams[1]="statusCode";
scriptContainer.registerListener('glassfish:jruby:http:requestEndEvent', requestEndParams, 'requestEnded');

runtimePoolParams = java.lang.reflect.Array.newInstance(java.lang.String, 3);
runtimePoolParams[0]="appName";
runtimePoolParams[1]="activeRuntimes";
runtimePoolParams[2]="queueSize";
scriptContainer.registerListener('glassfish:jruby:runtime-pool:runtimePoolStartEvent', runtimePoolParams, 'runtimePoolStart');
scriptContainer.registerListener('glassfish:jruby:runtime-pool:runtimePoolUpdateEvent', runtimePoolParams, 'runtimePoolUpdate');

This script register listeners for different probe events, pass a set of parameters that need to be captured, and print the information in a callback method specified during registration. The number of listeners and parameters / listener may be altered to meet your data capturing needs.

This script is stored in a file "monitor-rails.js" and used as described below. As a Rails application is deployed, requests invoked, and undeployed, the following messages are printed on the console:

~/tools/glassfish/v3/9-18/glassfishv3 >./bin/asadmin run-script monitor-rails.js


 log> Deployed a 'rails' app named 'redmine-0.8.5' in 'development' environment with JRuby '1.3.0'.
 log> JRuby runtime pool started for the app 'redmine-0.8.5': active runtime - 1, queue size - 0
 log> Request started at '/redmine-0.8.5' hosted on 'localhost:8080'
 log> Request stopped at '/redmine-0.8.5' with status code '200'
 log> Request started at '/redmine-0.8.5' hosted on 'localhost:8080'
 log> Request stopped at '/redmine-0.8.5' with status code '200'
 log> Undeployed a 'rails' app named 'redmine-0.8.5' in 'development' environment.

Note "run-script" is the command that comes as part of the value-add. As described earlier, a snapshot of the monitoring information can be easily captured using asadmin as:

~/tools/glassfish/v3/9-18/glassfishv3 >./bin/asadmin get --monitor=true "*jruby*request*"
server.containers.jruby.http.redmine-0.8.5.requestcount-count = 2
server.containers.jruby.http.redmine-0.8.5.requestcount-description = Number of HTTP requests received
server.containers.jruby.http.redmine-0.8.5.requestcount-lastsampletime = 1253638362651
server.containers.jruby.http.redmine-0.8.5.requestcount-name = RequestCounter
server.containers.jruby.http.redmine-0.8.5.requestcount-starttime = 1253638362651
server.containers.jruby.http.redmine-0.8.5.requestcount-unit = count
server.containers.jruby.http.redmine-0.8.5.requestpersecond = 1

Command get executed successfully.

As you can see, the total number of requests is shown as "2".

Just for fun, I ran Apache ab with 20 requests and 4 concurrency ("-n 20 -c 4") on "http://localhost:8080/redmine-0.8.5" and saw the following results:

The server was restarted between each run. These numbers were generated on my development machine so they are most likely skewed. But as a development benchmark the numbers do indicate that GlassFish v3 monitoring is truly non-intrusive. The total time taken for requests, requests/second, and time/request is pretty much identical.

Future blogs will cover how to access this data using web-based DTrace scripts, web-based Admin Console, jConsole, and REST interface.

A complete archive of all the tips is available here.

Technorati: totd glassfish v3 monitoring asadmin javascript jruby rails redmine

Posted by Arun Gupta in General  |  Comments[0]

TOTD #104: Popular Ruby-on-Rails applications on GlassFish v3 – Redmine, Typo, Substruct

GlassFish v3 is opening up new frontiers by allowing to easily deploy Rails, Grails and Django applications, in addition to Java EE, without any additional packaging. You can even write a custom container to support new types of applications. Numerous entries on this blog have talked about how to deploy Rails applications on GlassFish v3. This Tip Of The Day (TOTD) will recap them and, once again, demonstrate how to easily get started with deploying some popular open source Rails applications on GlassFish v3.

Lets prepare a GlassFish v3 build for deploying Rails applications. This blog is going to use 9/16 nightly but you should pick the latest nightly or promoted.

1. Unzip the downloaded bundle as:

   ~/tools/glassfish/v3/9-16 >unzip ~/Downloads/glassfish-v3-b64-09_16_2009.zip

2. Configure JRuby/Rails in GlassFish v3 - JRuby/rails can be configured three different ways - use a previously installed JRuby/Rails directory, install JRuby/Rails module using the graphical Update Center or the "pkg" binary. This Update Center module comes packaged with JRuby 1.3.1, Rails 2.3.2 and some other useful gems. Pick the option you are most comfortable with and use it for your GlassFish installation.
   1. Configure previously installed JRuby/Rails directory as:

      ~/tools/glassfish/v3/9-16/glassfishv3/bin/asadmin create-jvm-options -Djruby.home=/Users/arungupta/tools/jruby
      Authentication failed with password from login store: /Users/arungupta/.asadminpass
      
      Enter admin password >
      created 1 option(s)
      Command create-jvm-options executed successfully.

      
      That's it!
   2. Install JRuby/Rails module using graphical Update Tool
      1. The graphical Update Tool tool can be invoked as:
         

         ~/tools/glassfish/v3/9-16/glassfishv3 >./bin/updatetool
         
         The software needed for this command (updatetool) is not installed.
         
         If you choose to install Update Tool, your system will be automatically
         configured to periodically check for software updates. If you would like
         to configure the tool to not check for updates, you can override the
         default behavior via the tool's Preferences facility.
         
         When this tool interacts with package repositories, some system information
         such as your system's IP address and operating system type and version
         is sent to the repository server. For more information please see:
         
         http://wiki.updatecenter.java.net/Wiki.jsp?page=UsageMetricsUC2
         
         Once installation is complete you may re-run this command.
         
         Would you like to install Update Tool now (y/n): y
         
         Proxy: Using system proxy settings.
         Install image: /Users/arungupta/tools/glassfish/v3/9-16/glassfishv3
         Installing pkg packages.
         Installing updatetool packages.
         Registering notifier: Already registered.
         Initialization complete.
         
         Software successfully installed. You may now re-run this command (updatetool).

      2. The first invocation of the command installs the Update Tool and the second invocation shows the following screen after "JRuby on GlassFish" module is selected:
         
         
         Click on green button in the top left to install the module and it picks up the dependencies as well as shown below:
         
         
         Click on "Install" to start the installation and click on "Accept" to accept the license.
      3. Close the Update Tool window once the installation is completed. The module creates "glassfish/jruby" directory.
   3. Install JRuby/Rails module using "pkg" binary
      1. Install the JRuby/Rails bits using the "pkg" binary. Invoke the command as:

         ~/tools/glassfish/v3/9-16/glassfishv3 >./bin/pkg
         
         The software needed for this command (pkg) is not installed.
         
         When this tool interacts with package repositories, some system information
         such as your system's IP address and operating system type and version
         is sent to the repository server. For more information please see:
         
         http://wiki.updatecenter.java.net/Wiki.jsp?page=UsageMetricsUC2
         
         Once installation is complete you may re-run this command.
         
         Would you like to install this software now (y/n): y
         
         Proxy: Using system proxy settings.
         Install image: /Users/arungupta/tools/glassfish/v3/9-16/glassfishv3
         Installing pkg packages.
         Initialization complete.
         
         Software successfully installed. You may now re-run this command (pkg).

      2. The command "pkg list -a" shows all the modules available for installation and the output looks like:
         
         

         ~/tools/glassfish/v3/9-16/glassfishv3 >./bin/pkg list -a
         NAME (PUBLISHER)                              VERSION         STATE      UFIX
         ant (contrib.glassfish.org)                   1.7.1-0.6       known      ----
         felix                                         2.0.0-0         installed  ----
         glassfish-appclient                           3.0-65          installed  ----
         glassfish-cmp                                 3.0-65          installed  ----
         
         . . .
         
         jersey-docs-and-examples                      1.1.2-1.0       known      ----
         jmaki (contrib.glassfish.org)                 1.8.1-2.0       known      ----
         jruby                                         1.3.1-1.1       known      ----
         jruby (contrib.glassfish.org)                 1.2.0-1.1       known      u---
         jruby-gems (contrib.glassfish.org)            2.3.2-1.1       known      ----
         jython-container (contrib.glassfish.org)      0.5.3-1.0       known      ----
         jython-runtime (contrib.glassfish.org)        2.5.0-1.0       known      ----
         metro                                         2.0-19          installed  ----
         
         . . .
         
         updatetool                                    2.3.0-36.2403   known      ----
         updatetool (contrib.glassfish.org)            2.2.2-30.2311   known      u---
         wxpython2.8-minimal                           2.8.10.1-36.2403 known      ----
         wxpython2.8-minimal (contrib.glassfish.org)   2.8.8-30.2311   known      u---

      3. Start the installation of "jruby" module as:
         
         

         ~/tools/glassfish/v3/9-17/glassfishv3 >./bin/pkg install jruby
         DOWNLOAD                                  PKGS       FILES    XFER (MB)
         Completed                                  2/2 14810/14810    37.0/37.0
         
         PHASE                                        ACTIONS
         Install Phase                            17273/17273

3. Redmine on GlassFish - Redmine is an open source project management web application. The simplified steps to deploy Redmine on GlassFish v3 are given below (also on GlassFish Gem and on GlassFish v3 TP2):
   1. Download and unzip Redmine 0.8.5 (latest stable release).
   2. Change the database adapter from "mysql" to "jdbcmysql" as:
      
      

      sed s/'adapter: mysql'/'adapter: jdbcmysql'/ <config/database.yml.new >config/database.yml

   3. Create the database manually as "sudo mysqladmin create redmine_development". "db:create" fails because of JRUBY-3502.
   4. Migrate the database as "db:migrate".
   5. Deploy the application as:

      ~/samples/jruby/redmine >~/tools/glassfish/v3/9-16/glassfishv3/bin/asadmin deploy redmine-0.8.5
       Authentication failed with password from login store: /Users/arungupta/.asadminpass
      
      Enter admin password>
      Command deploy executed successfully.

   6. Here are some snapshots from the deployed application:
      
      
      
      
      
      
4. Typo on GlassFish - Typo is the oldest Ruby on Rails blogware. The simplified steps to deploy Typo on GlassFish v3 are given below (also on GlassFish Prelude):
   1. Download and unzip Typo 5.3 (latest stable release).
   2. Change the database adapter from "mysql" to "jdbcmysql" as:
      
      

      sed s/'adapter: mysql'/'adapter: jdbcmysql'/ <config/database.yml.example >config/database.yml

   3. Create the database manually as "sudo mysqladmin create typo_dev". "db:create" fails because of JRUBY-3502.
   4. Typo runs using Rails 2.2.2 so lets install Rails 2.2.2 so lets install Rails 2.2.2 as:

      ~/samples/jruby/typo/typo-5.3 >~/tools/glassfish/v3/9-16/glassfishv3/glassfish/jruby/bin/jruby -S gem install rails -v 2.2.2
      JRuby limited openssl loaded. gem install jruby-openssl for full support.
      http://wiki.jruby.org/wiki/JRuby_Builtin_OpenSSL
      Successfully installed activesupport-2.2.2
      Successfully installed activerecord-2.2.2
      Successfully installed actionpack-2.2.2
      Successfully installed actionmailer-2.2.2
      Successfully installed activeresource-2.2.2
      Successfully installed rails-2.2.2
      6 gems installed
      Installing ri documentation for activesupport-2.2.2...
      Installing ri documentation for activerecord-2.2.2...
      Installing ri documentation for actionpack-2.2.2...
      Installing ri documentation for actionmailer-2.2.2...
      Installing ri documentation for activeresource-2.2.2...
      Installing ri documentation for rails-2.2.2...
      Installing RDoc documentation for activesupport-2.2.2...
      Installing RDoc documentation for activerecord-2.2.2...
      Installing RDoc documentation for actionpack-2.2.2...
      Installing RDoc documentation for actionmailer-2.2.2...
      Installing RDoc documentation for activeresource-2.2.2...
      Installing RDoc documentation for rails-2.2.2...

   5. Migrate the database as "db:migrate".
   6. Deploy the application as:
      

      ~/samples/jruby/typo >~/tools/glassfish/v3/9-16/glassfishv3/bin/asadmin deploy typo-5.3
      Authentication failed with password from login store: /Users/arungupta/.asadminpass
      
      Enter admin password>
      Command deploy executed successfully.

   7. Here are are some snapshots from the deployed application:
      
      
      
      
      
      
5. Substruct on GlassFish - Substruct is an open source E-Commerce project in Ruby-on-Rails. The simplified steps to deploy Substruct on GlassFish v3 are given below (also on GlassFish v3 Gem):
1. Download and unzip substruct 1.0 a6 (latest stable release).
2. Install the required gems as:

   ~/samples/jruby/substruct >~/tools/glassfish/v3/9-16/glassfishv3/glassfish/jruby/bin/jruby -S gem install RedCloth fastercsv mime-types mini_magick ezcrypto jruby-openssl --no-ri --no-rdoc

3. Change the database adapter from "mysql" to "jdbcmysql" as:
   
   

   ~/samples/jruby/substruct/substruct_rel_1-0-a6>sed s/'adapter: mysql'/'adapter: jdbcmysql'/ <config/database.yml
   >config/database.yml.new
   ~/samples/jruby/substruct/substruct_rel_1-0-a6>mv config/database.yml.new config/database.yml
   

4. Create the database manually as "sudo mysqladmin create substruct_development". "db:create" fails because of JRUBY-3502.
5. Initialize the database as:
   

   ~/samples/jruby/substruct/substruct_rel_1-0-a6 >~/tools/glassfish/v3/9-16/glassfishv3/glassfish/jruby/bin/jruby -S rake substruct:db:bootstrap

6. Deploy the application as:
   

   ~/samples/jruby/substruct >~/tools/glassfish/v3/9-16/glassfishv3/bin/asadmin deploy substruct_rel_1-0-a6
   Authentication failed with password from login store: /Users/arungupta/.asadminpass
   Enter admin password>
   
   Command deploy executed successfully.

7. Here is a snapshot of the deployed application:
   
   

So we deployed Redmine, Typo, and Substruct using JRuby/Rails on GlassFish without any additional packaging. There are several Rails applications deployed in production on GlassFish.

What Rails applications are you deploying on GlassFish ?

Technorati: glassfish v3 rails jruby redmine typo mephisto substruct

Posted by Arun Gupta in web2.0  |  Comments[0]

| | | | | |
|