GlassFish Fans in Minnesota

TOTD #85: Getting Started with Django Applications on GlassFish v3

1. Download GlassFish v3 Preview.
2. Install Jython 2.5
1. Download Jython 2.5 from here. 
2. Install as:
   
   

   java -jar ~/Downloads/jython_installer-2.5.0.jar

   
   Choose the default options (pick your directory) as shown below:
   
   
   
   and click on "Next" to start the installation process.
3. As mentioned in Django on Jython wiki, create the following aliases:
   
   

   alias jython25=~/tools/jython2.5.0/bin/jython alias django-admin-jy="jython25 ~/tools/jython2.5.0/bin/django-admin.py"

   
   
4. Invoking the command "jython25" from the installation directory shows the Jython interpreter as:
   
   

   ~/tools/jython/jython2.5rc4 >jython25 Jython 2.5rc4 (Release_2_5rc4:6470, Jun 8 2009, 13:23:16) [Java HotSpot(TM) 64-Bit Server VM (Apple Inc.)] on java1.6.0_13 Type "help", "copyright", "credits" or "license" for more information. >>>

   
   
3. Install Django
1. Download Django 1.0.2 from here.
2. Install Django 1.0.2 as:
   
   

   ~/tools >tar xzvf ~/Downloads/Django-1.0.2-final.tar.gz Django-1.0.2-final/ Django-1.0.2-final/AUTHORS Django-1.0.2-final/django/ . . . Django-1.0.2-final/scripts/rpm-install.sh Django-1.0.2-final/setup.cfg Django-1.0.2-final/setup.py ~/tools/Django-1.0.2-final >jython25 setup.py install running install running build running build_py . . . running install_egg_info Writing /Users/arungupta/tools/jython/jython2.5.0/Lib/site-packages/Django-1.0.2_final-py2.5.egg-info

   
   
4. Install Jython container for GlassFish
1. Start GlassFish v3 Preview Update Center using the following command:
   
   

   ~/tools/glassfish/v3/preview/glassfishv3/bin >./updatetool

   
   to see the screen as:
   
   
   
2. Select "GlassFish v3 Jython Container" and click on "Install", "Accept" the license and complete the installation. Close the Update Center window. This installs Jython Container OSGi module and Grizzly Adapter JARs in the "glassfish/modules" directory.
5. Start and configure GlassFish
1. Start GlassFish as:
   
   

   ~/tools/glassfish/v3/preview/glassfishv3/glassfish >./bin/asadmin start-domain

   
   
2. Configure Jython in GlassFish as:
   
   

   ~/tools/glassfish/v3/preview/glassfishv3/glassfish >./bin/asadmin create-jvm-options -Djython.home=/Users/arungupta/tools/jython2.5.0 created 1 option(s) Command create-jvm-options executed successfully.

   
   Make sure to specify the directory where Jython is installed.
   
6. Deploy the samples bundled with the Django installation as:
   
   

   ~/tools/Django-1.0.2-final/examples >~/tools/glassfish/v3/preview/glassfishv3/glassfish/bin/asadmin deploy . Command deploy executed successfully.

   
   and now they are accessible at "http://localhost:8080/examples/" and shown as:
   
   
   
   Make sure to specify the end "/" otherwise the context root is not resolved correctly and none of the links will work.
   
   Click on "Hello World (HTML)" to see the output as:
   
   
   
   And click on "Displaying request metadata" to see output as:
   
   
   
   The same sample can, of course, run using the built-in development server as:
   
   

   ~/tools/Django-1.0.2-final/examples >jython25 manage.py runserver Validating models... 0 errors found Django version 1.0.2 final, using settings 'examples.settings' Development server is running at http://127.0.0.1:8000/ Quit the server with CONTROL-C.

   
   and then accessible at "http://localhost:8000" as:
   
   

GlassFish swimming to FISL, Brazil

FISL stands for "Forum Internacional Software Livre" in the Portuguese language and means "International Free Software Forum" in the English language. The punch line is "A technologia que liberta" and means "The technology that liberates". This is the biggest event about free software in America and was attended by 7417 participants in 2008.

• To Pick your own framework: Java EE, Ruby-on-Rails, Python/Django, Groovy/Grails, or any other
• Choose your IDE: NetBeans, Eclipse, IntelliJ and others.
• Over properietary Application Servers by providing highly reliable and production quality features like
• Clustering/Load balancing
• Secure, Reliable, and Transactional, and .NET-interoperable Web services stack (Metro)
• Easy-to-use web-based administration console along with a powerful CLI
  
in an open source world.
• Offers dual open-source license (CDDL or GPL v2 w/ CPE)

TOTD #84: Using Apache + mod_proxy_balancer to load balance Ruby-on-Rails running on GlassFish

1. Create a simple Rails scaffold and run this application using GlassFish Gem on 3 separate ports as explained in TOTD #81.
2. Setup and configure HTTPD and mod_proxy_balancer
1. Setup and install Apache HTTPD as explained here. I believe mod_proxy_balancer and other related modules comes pre-bundled with HTTPD, at least that's what I observed with Mac OS X 10.5.7. Make sure that the "mod_proxy_balancer" module is enabled by verifying the following line is uncommented in "/etc/apache2/httpd.conf":
   
   

   LoadModule proxy_balancer_module libexec/apache2/mod_proxy_balancer.so

   
   Please note another similar file exists in "/etc/httpd/httpd.conf" but ignore that one.
2. Setup a mod_proxy_balancer cluster by adding the following fragment in "httpd.conf" as:
   
   

   <Proxy balancer://glassfishgem> BalancerMember http://localhost:3000 BalancerMember http://localhost:3001 BalancerMember http://localhost:3002 </Proxy>

   
   The port numbers must exactly match with those used in the first step.
   
3. Specify the ProxyPass directives to map the cluster to a local path as:
   
   

   ProxyPass / balancer://glassfishgem/ CustomLog /var/log/glassfishgem.log/apache_access_log combined

   
   The "/" at the end of "balancer://glassfishgem" is very important to ensure that all the files are resolved correctly.
4. Optionally, the following directive can be added to view the access log:
   
   

   CustomLog /var/log/glassfishgem.log/apache_access_log combined

   
   Make sure to create the directory specified in "CustomLog" directive.
3. Now the application is accessible at "http://localhost/runlogs". If a new GlassFish instance is started then update the <Proxy> directive and restart your HTTPD as "sudo httpd -k restart". Dynamic update of BalancerMembers can be configured as explained here.

GlassFish at Eclipse Demo Camps Galileo 2009 - Jun 17th

What is an Eclipse Demo Camp ? The Eclipse DemoCamps are an opportunity to showcase all of the cool interesting technology being built by the Eclipse community. They are also an opportunity for you to meet Eclipse enthusiasts in your city.

• GlassFish Tools Bundle for Eclipse provide Eclipse 3.4.2 with Java EE support, GlassFish v 2.1 + GlassFish v3 pre-registered/configured, with commercial support
• GlassFish v3 Preview can be added
• Screencast #28 shows how develop/debug a web application using Eclipse and GlassFish
• TOTD #66 shows how to install GlassFish plugin in an existing Eclipse install
• Eclipse Galileo can be used for GlassFish development/deployment, use "http://ajax.dev.java.net/eclipse" as the udpate site.

Cognizant likes Simplicity, Easy management, and Lightweightness of GlassFish

Cognizant is system integrator combining onsite/offshore delivery model to achieve customer satisfaction. They've started using GlassFish within their internal "Cognizant Java Community" and also recommeding it to their clients as opposed to "established App Servers".

OKTECH - Hungarian consulting company using GlassFish for 4 years

OKTECH is a Hungarian consuting company and one of the earliest adopters of GlassFish. They use it for their internal company related information and for external production with US business as well.

University of Utah - Ported 60 applications from Weblogic to GlassFish

The University of Utah ported 60 applications from Weblogic to GlassFish and very happy with it. They like the clustering and failover capability, integrated NetBeans development environment, and are using EJBs, Java Server Faces and a slew of other technologies.

OPIN Systems - Financial Application using JRuby-on-Rails on GlassFish

Fundamo: Call Banking System using Sun "all the way through", including GlassFish

Fundamo provides a mobile financial services platform using a full Sun stack - hardware, operating system, and GlassFish. They found GlassFish has more features and better support than other open source App Servers. And it's not as big as other competitors.

AGFA Healthcare - Using GlassFish for Field Force Automation, Time Registration, SAP Integration

• 100% uptime for past 1.5 years with 8 cluster nodes
• GlassFish's importance in this economy
• Simple and elegant administrative console
• High availability, ease-of-use, and something that works
  

JavaOne 2009 Day 3 in Pictures

Garmin nuvi 200w and Canon SD 770 Winners at JavaOne GlassFish Booth - Jun 3, 2009

• 1pm at the GlassFish Enteprise Server Booth (#550) in the Pavilion
• 8:30pm at GlassFish BoF

JavaOne 2009 Day 2 in Pictures

GlassFish Survey for a chance to win Canon SD 770, Garmin nuvi 200w, iPod Touch, and a Wii

• A 16 GB iPod Touch
• Garmin nuvi 200w
• Canon SD 770 s
• Wii Game System

• Wednesday, Jun 3rd, 4pm
• Thursday, Jun 4th, 1pm
• Thursday, 8:30pm, "Meet the GlassFish Team" Birds-of-Feather session, Esplanade 301

JavaOne 2009 Day 1 In Pictures

	\

Community One West 2009 - In Pictures

	\

GlassFish Unconference and Thirsty Bear Party - In Pictures

JVB #17: Davis Nguyen on GlassFish at JavaOne 2009

JVB #16: Sivakumar Thyagarajan on GlassFish at JavaOne 2009

JVB #15: Srinivas Bhimisetty on GlassFish at JavaOne 2009

JVB #14: Sreeram Duvur on GlassFish at JavaOne 2009

JVB #10: Sreenivas Munnangi on GlassFish at JavaOne 2009

JVB #13: Jagadesh Munta on GlassFish at JavaOne 2009

JVB #12: Judy Tang on GlassFish at JavaOne 2009

JVB #11: Prashanth Abbagani on GlassFish at JavaOne 2009

JVB #09: Rajiv Mordani on GlassFish at JavaOne 2009

JVB #08: Vivek Pandey on GlassFish at JavaOne 2009

JVB #07: Jacob Kessler on GlassFish at JavaOne 2009

JVB #06: Jiandong Guo on GlassFish at JavaOne 2009

JVB #05: Bhakti Mehta on GlassFish at JavaOne 2009

JVB #04: Kohsuke Kawaguchi on GlassFish at JavaOne 2009

JVB #03: Jim Driscoll on GlassFish at JavaOne 2009

JVB #02: Jitendra Kotamraju on GlassFish at JavaOne 2009

TOTD #82: Eclipse Tools Bundle for GlassFish 1.0 - Now Available!

• Contents: Eclipse 3.4.2 with Java EE support, GlassFish v2.1 + GlassFish v3 Prelude Pre-registered/configured
• Download
• Release Notes
• Commercial Support
• TOTD #66: GlassFish Plugin for Eclipse
• Screencast #28: Develop/Debug a simple web application and use rapid deployment

JVB #01: Roberto Chinnici on GlassFish at JavaOne 2009

TOTD #81: Getting Started with Servlet 3.0 and EJB 3.1 in Java EE 6 using NetBeans 6.7

1. Enable support for v3 Preview in NetBeans
1. Using NetBeans 6.7 latest nightly, enable support for recent GlassFish v3 builds either using the command-line switch or the marker module.
2. Download and unzip GlassFish v3 Preview 47b. The latest promoted builds are always available here.
3. In the "Services" tab, right-click on "Servers" and click on "Add Server". Select "GlassFish v3" as shown below:
   
   
   
   and click on "Next".
4. Specify location of the previously unzipped bundle, click on "Next >", and press "Finish".
2. Create a new Web project by right-click in the "Projects" pane, select "New Project", choose "Java Web" and "Web  Application" as categories and projects.
3. Click on "Next >", choose "Java EE 5" as the Java EE version and click on "Finish". A future version of NetBeans will will provide direct support for Java EE 6.
4. Add a POJO-based EJB
1. Right-click on "Source Packages" and select "New", "Java Class..." as shown below:
   
   
   
   Give the class name as "HelloEJB" and package as "server" as shown below:
   
   
   
   and click on "Finish".
2. Add "@Stateless" class-level annotation and press Shift+Command+I (default shortcut) to fix the imports. This annotation comes from the "javax.ejb" package.
3. Add the following method:
   
   

   public String sayHello(String name) {         return "Hello " + name;     }

   
   to the class. And can you believe it, that's your complete EJB ready to be deployed and that too in a WAR file - the beauty of Java EE 6. The complete class looks like:
   
   
   

   package server; import javax.ejb.Stateless; /**  * @author arungupta  */ @Stateless public class HelloEJB {     public String sayHello(String name) {         return "Hello " + name;     } }

5. Add a Servlet to invoke this EJB
1. Add a new class "HelloServlet" in the "server" package as explained above.
2. Add "@WebServlet" class-level annotation and Shift+Command+I to fix the imports. This annotation comes from the "javax.servlet.annotation" package. And specify a URL pattern as:
   
   

   @WebServlet(urlPatterns="/hello")

3. According to the Servlet3 specification, the contract is inherited from the "javax.servlet.http.HttpServlet" interface. So add:
   
   

   extends HttpServlet

   
   to the class.
4. Inject a local EJB reference using the code:
   
   

   @EJB HelloEJB ejbClient;

5. Override the GET method as:
   
   

   @Override     public void doGet(HttpServletRequest req, HttpServletResponse res) throws IOException {         res.setContentType("text/html");         res.getOutputStream().print("<h1>Hosted at: " + req.getContextPath() + "</h1>");         res.getOutputStream().print("<h2>" + ejbClient.sayHello("Duke") + "</h2>");     }

   
   and again Shift+Command+I to fix the imports. The complete class looks like:
   
   

   package server; import java.io.IOException; import javax.ejb.EJB; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; /**  * @author arungupta  */ @WebServlet(urlPatterns="/hello") public class HelloServlet extends HttpServlet {     @EJB HelloEJB ejbClient;     @Override     public void doGet(HttpServletRequest req, HttpServletResponse res) throws IOException {         res.setContentType("text/html");         res.getOutputStream().print("<h1>Hosted at: " + req.getContextPath() + "</h1>");         res.getOutputStream().print("<h2>" + ejbClient.sayHello("Duke") + "</h2>");     } }

Ruby-on-Rails and Ramaze production deployments on GlassFish

Who ?	Recipe	Why GlassFish ?
	JRuby + Rails + GlassFish v2 + MySQL + Apache Web Server + memcached	The GlassFish processes have been among the most stable of our deployment. and (The) GlassFish team has been extremely helpful along the way with tuning and diagnosing performance issues.
	JRuby + Rails + GlassFish v2 + MySQL + Solaris Zones	GlassFish works and provides useful error messages.
	Recipe: JRuby + Ramaze + GlassFish v2 + MySQL/H2	What's essential for me is that I spend my time doing development, not sysadmin work, so I settle for a working solution.   I've had no trouble for a few months now, and redeploy using simple scripts.

GlassFish Portfolio at JavaOne 2009 - 16 C1 sessions, 23 Technical Sessions, 17 Birds-of-Feather, 7 Hands-on-Labs, and much more

• GlassFish on Twitter, Facebook, and LinkedIn
• JavaOne on Twitter and Facebook, and LinkedIn

• GlassFish ESB Sessions
• GlassFish Mobility Platform at JavaOne 2009

GlassFish and Servlet 3.0 Slides from San Francisco JUG

GlassFish Whitepapers and Webcasts

• GlassFish Management and Monitoring
• Dynamic Languages on GlassFish
• Guide to Migrating to GlassFish
• Overview of GlassFish High Availability

• Optimize GlassFish in a production environment
• Building a High Performance Open Web Platform
• Leveraging Identity with GlassFish and MySQL
• Carrier Grade Converged Services with GlassFish
• Learning GlassFish For Tomcat Users
• Creating a Carrier Grade Service Execution Environment with MySQL Cluster and the Sun GlassFish Communications Server
• GlassFish: The Open Source Alternative to Weblogic
• High Availability with Sun Message Queue
• Application Scalability and Fault Tolerance with GlassFish Load Balancer
• Optimizing Sun GlassFish Enterprise Server for Sun Open Network Systems
• Writing Java Applications Using Jersey to Interoperate with RESTful Web Services

Rails Conf 2009 Day 3 Trip Report

• Improved performance
• Increased modularity 
• Agnosticism (choose any JS framework)
• Public API
• Mountable Apps

• More flexible, Less opinionated
• Templating engines: HAML and ERB are the big ones.
• ORM: ActiveRecord, DataMapper
• Adapaters: RDBMS, File Ssytem, IMAP, YAML, REST APIs, Custom APIs
• Sequel: Prepared statement, Sharding, highly customization SQL
• Use Hibernate with either ActionORM, JRuby
• Ability to talk to Non RDBMS Systems; GAE, CouchDB, Redis, Tokyo Cabinet, etc

Rails Conf 2009 Day 3 - Chris's Keynote

Rails Conf 2009 Day 2 Trip Report

Attended Women in Rails panel discussion. The panel, Sarah Mei, Lori Olson, and Desi McAdam (from L to R), had a very interesting discussion around the genuine problems and possible solutions of involving more women in Rails community.

I presented on Develop with Pleasure, Deploy with Fun: GlassFish and NetBeans for a better Rails experience, slides here. The several concepts in the talk are explained in the following bullets:

• Directory-based deployment in TOTD #71, Capistrano recipes
• GlassFish Gem in TOTD #70, Capistrano recipes
• Merb support in TOTD #53
• Sinatra support in TOTD #80
• Any Rack-based framework
• nginx Deployment in TOTD #81
• Apache deployment
• WAR deployment in TOTD #73
• NetBeans Develop/Deploy/Debug in screencast #26
• JMX-based management
• Project Kenai
• JRuby/GlassFish Success Stories
• Rails Bootcamp in San Francisco on May 19/20

The next talk of the day was JRuby: State of the Art

• Best memory management
• Dynamic optimizations
• Reliable native threads: run threads across multiple cores
• Vast number of libraries
• Interop with Java, Scala, Rhino, Jython, ...
• Ubiquitous

• Fastest production-ready Ruby implementation
• Definitely faster than 1.8.6
• JRuby -> Bytecode -> Native code -> Optimizations

• "invokedynamic": Build fast dynamic invocation in JVM, JRuby support by June, allow Hotspot to do all optimizations across Ruby calls
• Multi-language VM "Da Vinci Machine", Optimized tail calls, continuations, fixnums, value types

• Only production-ready impl with real threads
• Ruby thread is a normal thread that can run on multiple cores

• 1 Controller/Mode/View, send 1000 reqs
• 80% less memory in 10 instance example, 96% for 20 instances

• Gem, WAR-based
• nginx, Apache: mod_proxy

• Call C functions directly from Ruby
• Portable unlike extensions

• Kenai
• Gravitor
• King Pong (JRuby wrapping MonkeyEngine)
• Oslo's Gardermoen Airport to refuel planes
• ThoughtWorks Mingle
• No cross-platform SVN libraryfor Ruby
• Bundling of installation
• Security (ecnrypting source code)
• Memory profile
• Avoiding process proliferation
• mix.oracle.com
• 5 developers, 6 weeks for all development, 2887 LOC
• Trisano: Open source infectious disease reporting system
• Ease of deployment
• Every enterprise on the planet run Java
• Extensive project roadmap

Click To Play

Later in the evening, Brian Helmkamp, Aman Gupta, Luis Navena, Pat Allan, Dan Kubb, and John Nunemaker were awarded Ruby Heroes Award!

And the keynote by Tim Ferris, lets not talk about it ;-) I edited pictures, authored my blog, caught up on email/RSS during the keynote. #railconf on IRC and twitter were way more fun! Check the live ratings. "1" was the lowest rating that could be given anyway!

Sea Change Affinity - Why JRuby/GlassFish ?

• Performance characterisitics (of GlassFish) have been excellent
• Picked GlassFish based upon the recommendations from the people in industry
• Dramatically more throughput on our GlassFish installation, 400 requests/sec instead of 100 requests/sec comapred to Tomcat

Rails Conf 2009 Day 2 - DHH Keynote

• Stop fretting about whether you are upto date with the latest in Rails. Don't need to re-write your application everytime something new comes up.
• Gallery of "normal wounds"
• Rails isn't enterprise ready, James McGovern "some consutant, architect, or bullshit title of a big company". Can't win the world with better arguments, some things take time.
• Multiple frameworks like Grails, Sails, Biscuit, Monorail seem to give the impression Java is easier
• Switch back to PHP after 2 years on Rails y Derik Severs (sp?)
• The failed whale, "the twitter debacle" that Rails doesn't scale.
• Merb - "the most credible alternative to Rails". Even though emotions can run high, the underlying principles are still the same.
• Fundamental principle of Rails are still the same, it's better and faster
• Philosophy of Rails3
• Buck up all the unicorns - it's not going to be a rewrite f everything
• No holy cows - "There is nothing secret in Rails, everything is up for public debate"
• Have tasty burgers: it's all pre-assembled and use it the default way, otherwise pick/choose whatever you like. Allow people to make individual choices and still be together in one community.
• Progress of Rails 3 - Ton of Rails 3 code in the repository, no alpha release
• New Router: Faster route by subdomains, user agents, more Route to other Rack machinery. Mount multiple applications like Sinatra and Django using this router. Much simpler routing API. "Ruby is not about fewer lines of code, it's about expressive lines of code."
• XSS protection: Flipping the convention such that all outputting views will be escaped, so "<%=raw" will not escape it and "<%" will escape it by default. HTML helpers "html_safe" may be used too.
• JavaScript goes unobstrusive and agnostic: Will adopt HTML 5 custom attributes such as "data-remote" and "data-method" attribtues will simplify "link_to_remote", "remote_form", "link_to".
• More agnosticism: Action ORM is a slim wrapper around other ORM tools, Generators (SoC project)
• Great refactoring (bulk of the work): Abstract Controller + Action Dispatch, Active Relation (also GSoC project) underpins Active Record, Cherry picking from Active Support, Speedy callbacks
• Real secret to high productivity
• Most developers treat requirements as stone tablets, don't treat requirements as gospel, instead renegotiate requirements.
• Use Twix instead of a fine Belgian chocolate, it doesn't really matter most of the time.
• Programmers are like puppies who want to fetch the same ball again and again, bark back instead
• Calling people programmer is like a blackbox, we are not those boxes. Instead we should be treated as partners, work with our stakeholders to get the job done.

Rails Conf 2009 - Day 1 Trip Report

• 95% comfortable with Ruby/Rails
• 80% have used JRuby
• 10% use JRuby actively
  

• JRuby is "Less Bitter Java", after all Java is a great platform.
• Concurrency (Native threading)
• Reliability (well-behaved because of Hotspot compiler, no process monitoring, etc)
• Encapsulation (take a Rails application, bundle it as a single deployable artifact that is fully contained)
• Choice (Any Java application server, huge breadth of Java libraries, and can write thin Ruby wrappers around Java libraries)

• --server: Run with server VM, better performance
• --headless: No UI
• --properties: Show tweaks for compiler, JIT compiling,  thread pooling etc
• -J<java-opt>: Pass any Java properties
• -J-Xmx1G: Increase memory to 1G

TOTD #81: How to configure "database.yml" to be used with both JRuby and MRI ?

JRuby, Rails, and GlassFish Bootcamp - San Francisco, May 19/20, 2009

Would you like to power up your Rails applications using JRuby and GlassFish ? And learn that from the engineers who develop the technology. If yes, then we have organized a bootcamp for you!

TOTD #81: How to use nginx to load balance a cluster of GlassFish Gem ?

nginx (pronounced as "engine-ex") is an open-source and high-performance HTTP server. It provides the common features such as reverse proxying with caching, load balancing, modular architecture using filters (gzipping, chunked responses, etc), virtual servers, flexible configuration and much more.

1. Download, build, and install nginx using the simple script (borrowed from dzone):
   
   

   ~/tools > curl -L -O http://sysoev.ru/nginx/nginx-0.6.36.tar.gz ~/tools > tar -xzf nginx-0.6.36.tar.gz ~/tools > curl -L -O http://downloads.sourceforge.net/pcre/pcre-7.7.tar.gz ~/tools > tar -xzf pcre-7.7.tar.gz ~/tools/nginx-0.6.36 > ./configure --prefix=/usr/local/nginx --sbin-path=/usr/sbin --with-debug --with-http_ssl_module --with-pcre=../pcre-7.7 ~/tools/nginx-0.6.36 > make ~/tools/nginx-0.6.36 > sudo make install ~/tools/nginx-0.6.36 > which nginx /usr/sbin/nginx

   
   OK, nginx is now roaring and can be verified by visiting "http://localhost" as shown below:
   
   
   
2. Create a simple Rails scaffold as:
   
   

   ~/samples/jruby >~/tools/jruby/bin/jruby -S rails runner ~/samples/jruby/runner >~/tools/jruby/bin/jruby script/generate scaffold runlog miles:float minutes:integer ~/samples/jruby/runner >sed s/'adapter: sqlite3'/'adapter: jdbcsqlite3'/ <config/database.yml >config/database.yml.new ~/samples/jruby/runner >mv config/database.yml.new config/database.yml ~/samples/jruby/runner >~/tools/jruby/bin/jruby -S rake db:migrate

3. Run this application using GlassFish Gem on 3 separate ports as:
   
   

   ~/samples/jruby/runner >~/tools/jruby/bin/jruby -S glassfish Starting GlassFish server at: 192.168.1.145:3000 in development environment... Writing log messages to: /Users/arungupta/samples/jruby/runner/log/development.log. Press Ctrl+C to stop.

   
   The default port is 3000. Start the seond one by explicitly specifying the port using "-p" option ..
   
   

   ~/samples/jruby/runner >~/tools/jruby/bin/jruby -S glassfish -p 3001 Starting GlassFish server at: 192.168.1.145:3001 in development environment... Writing log messages to: /Users/arungupta/samples/jruby/runner/log/development.log. Press Ctrl+C to stop.

   
   and the last one on 3002 port ...
   
   

   ~/samples/jruby/runner >~/tools/jruby/bin/jruby -S glassfish -p 3002 Starting GlassFish server at: 192.168.1.145:3002 in development environment... Writing log messages to: /Users/arungupta/samples/jruby/runner/log/development.log. Press Ctrl+C to stop.

   
   On Solaris and Linux, you can run GlassFish as a daemon as well.
4. Nginx currently uses a simple round-robin algorithm. Other load balancers such as nginx-upstream-fair (fair proxy) and nginx-ey-balancer (maximum connections) are also available. The built-in algorithm will be used for this blog. Edit "/usr/local/nginx/conf/nginx.conf" to specify an upstream module which provides load balancing:
1. Create a cluster definition by adding an upstream module (configuration details) right before the "server" module:
   
   

   upstream glassfish {         server 127.0.0.1:3000;         server 127.0.0.1:3001;         server 127.0.0.1:3002;     }

   
   The cluster specifies a bunch of GlassFish Gem instances running at the backend. Each server can be weighted differently as explained here. The port numbers must exactly match as those specified at the start up. The modified "nginx.conf" looks like:
   
   
   
   The changes are highlighted on lines #35 through #39.
2. Configure load balancing by specifying this cluster using "proxy_pass" directive as shown below:
   
   

   proxy_pass http://glassfish;

   
   in the "location" module. The updated "nginx.conf" looks like:
   
   
   
   The change is highlighted on line #52.
   
5. Restart nginx by using the following commands:
   
   

   sudo kill -15 `cat /usr/local/nginx/logs/nginx.pid` sudo nginx

• nginx Website
• nginx Forum (very useful)
• nginx Wiki
• IRC #nginx

TOTD #80: Sinatra CRUD application using Haml templates with JRuby and GlassFish Gem

Haml is based on one primary principle - Markup should be beautiful because beauty makes you faster. Get started by installing the Haml gem as: /tools/jruby-1.2.0 >./bin/jruby -S gem install haml --no-ri --no-rdoc JRuby limited openssl loaded. gem install jruby-openssl for full support. http://wiki.jruby.org/wiki/JRuby_Builtin_OpenSSL Successfully installed haml-2.0.9 1 gem installed And follow the tutorial, documentation, and reference page for more details.

1. Create the database as:
   
   

   ~/tools/jruby/samples/sinatra-sample >mysql --user root Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 664 Server version: 5.1.30 MySQL Community Server (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create database hello_development; Query OK, 1 row affected (0.00 sec) mysql> use hello_development; Database changed mysql> CREATE TABLE `runners` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `distance` float, `minutes` int(11), `created_at` datetime, `updated_at` datetime);              Query OK, 0 rows affected (0.06 sec)

   
   
2. Update "hello.rb" from TOTD #79 such that it looks like:
   
   

   require 'rubygems' require 'sinatra' require 'activerecord' ## Setup ActiveRecord::Base.establish_connection(   :adapter  => "jdbcmysql",   :host     => "localhost",   :username => "root",   :password => "",   :database => "hello_development" ) ## Models class Runner < ActiveRecord::Base end ## Controller Actions get '/hi' do   "Hello World!" end get '/' do   @runner = Runner.find(:all)   haml :index end get '/new' do   haml :new end get '/:id' do   @runner = Runner.find(params[:id])   if (@runner)     haml :show   else     redirect '/'   end end post '/' do   @runner = Runner.new(:distance => params[:distance], :minutes => params[:minutes])   if @runner.save     redirect "/#{@runner.id}"   else     redirect '/'   end end

   
   Firstly, it pulls in the ActiveRecord dependency. Then "ActiveRecord::Base.establish_connection" is used to establish a connection with the previously created database. "Runner" is tagged as a model class by inheriting from "ActiveRecord::Base" and uses the default table name ("runners" in this case). Add four new methods:
1. Three GET methods to show all the runners, a form to enter new data, and show a particular log entry. Each method requires a HAML template (will be created in next step) to render the information.
2. One POST method to save the newly created log entry in the database.
3. Create a new directory "views" and create the following files in that directory. Each file serves as a view and rendered from an action in "hello.rb".
1. "index.haml": Show all the runners
   
   

   %h1 Listing all runners ... %table   %tr     %th Distance     %th Minutes   - @runner.each do |r|     %tr       %td= r.distance       %td= r.minutes %br %a{:href=>"/new"}   New Runner

   
   
2. "new.haml": Enter a new entry
   
   

   %h1 Adding a new runner log ... %form{:method=>"post", :action=>"/"}   Distance:   %input{:type=>"text", :name=>"distance"}   %br   Minutes:   %input{:type=>"text", :name=>"minutes"}   %br   %input{:type=>"submit", :value=>"Submit"}   %br

   
   
3. "show.haml": Show a particular log entry
   
   

   %h1 Showing a runner log ... Distance: = @runner.distance %br Minutes: = @runner.minutes %br %br %a{:href=>"/"}= "Show All!"

   
   The complete directory structure looks like:
   
   

   . ./hello.rb ./views ./views/index.haml ./views/new.haml ./views/show.haml

TOTD #79: Getting Started with Sinatra applications on JRuby and GlassFish Gem

Sinatra is a DSL for quickly creating web-applications in Ruby with minimal effort. Like Rails and Merb, Sinatra is not an MVC framework and basically follows a flat-file structure instead. The framework define conventions such as location of static files and views, bootstrap, dev/production/test environment variables, filters, helpers, TDD, and much more.  Read Getting Started for complete details. Even though Sinatra is not a MVC framework but sinatra-gen may be used to generate new Sinatra projects. GlassFish Gem can easily run Rails, Merb, Sinatra, and any other Ruby framework applications based upon Rack. TOTD #70 shows how to run Rails applications and TOTD #53 shows to run Merb applications. This TOTD will explain how to run a trivial Sinatra application. A later blog will describe how to plug a generic Rack-based framework.

1. Install Sinatra gem as:
   
   

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

   
   
2. Create a directory "sinatra-sample", create a file "hello.rb" in that directory with the contents shown below:
   
   

   require 'rubygems' require 'sinatra' get '/hi' do   "Hello World!" end

   
   
3. Run your sample using GlassFish gem as:
   
   

   ~/tools/jruby/samples/sinatra-sample >../../bin/jruby -S glassfish Log file /Users/arungupta/tools/jruby-1.2.0/samples/sinatra-sample/log/development.log does not exist. Creating a new one... Starting GlassFish server at: 192.168.1.145:3000 in development environment... Writing log messages to: /Users/arungupta/tools/jruby-1.2.0/samples/sinatra-sample/log/development.log. Press Ctrl+C to stop.

   
   And then the output is available at "http://localhost:3000/hi" and looks like:
   
   
   

• Project Website
• IRC #sinatra
• Twitter
• Mailing List

GlassFish, NetBeans, and Project Kenai at Rails Conf 2009

GlassFish Gem is already used in production GlassFish Gem can be used to run Rails, Merb, Sinatra, and any other Rack-based framework Capistrano recipes are available for starting/stopping/bouncing the server With GlassFish, standard Java monitoring techniques like JMX can be used for monitoring Rails apps NetBeans provide a complete development environment for Rails applications

Develop with pleasure, Deploy with Fun: GlassFish and NetBeans for a better Rails experience Tuesday, May 5th, 2009, 1:50pm Pavilion 1

And you'll get to meet Project Kenai team, they form the foundation for Sun's connected developer experience. Read about their participation here and meet them to learn about NetBeans and Kenai integration.

GlassFish asadmin CLI-driven Cluster Setup

• Installs GlassFish
• Creates a new domain using cluster profile
• Create 2 instances in the cluster
• Deploys a sample application to verify the cluster setup

Offshore monitoring of windfarms using GlassFish - MySQL Users Conference 2009 Day 3

LOTD #21: Production Deployment Tips for running Rails on GlassFish v2 using Windows

Technorati: lotd glassfish jruby rubyonrails windows

MySQL Users Conference 2009 Day 3 - Cloud Shootout

Posted by arungupta on April 22, 2009 at 11:53 AM | Permalink | Comments (0)


I arrived at the MySQL Users Conference just in time for the The Great Open Cloud Shootout.


Kaj Arno was asking questions to the invited panelists shown in the picture above. Here is a partial discussion:

What is cloud ?

Thorsten	Fully automatbale computing infrastructure, changes the way production scale deployments operate, saves time/cost, increases reliability
Chander	Elasiticity is an important aspect, Can "shoot for the moon without shooting foot", accessing a pool of resources which is infinite from an individual/organization perspective
Monty	Much like electricity/network bandwidth, applying that same model to computing resources
Jeremy	Virtualization is an important piece
Lew	Not new technology, rather a new way of delivery. As a developer, provision the application through the code.

Who is it for ?

Monty	It's for you
Thorsten	Amazon launched, mostly for geeks. 2007 -> Amazon skeptical and RightScale gets VC funding, 2008 -> some common usage, 2009 -> Top-down from CIOs. Basically everybody, cross-organiation, vertical
Mike	Horizontal technology opportunity, starting to see mainstream applications including ISVs/primary line of business, interest/adoption is growing
Chander	Definitely growing for ISVs, makes backup sexy, "Even though running a backup company, expected to be entertaining"
Jeremy	Power outlets are shaped differently, technology has not matured enough. Next few years standardization will happen.
Monty	People will never notice it exists, but able to access the information
Prashant	Putting/Sharing the data on cloud

Why use the cloud ?

Monty	All of a sudden facebook traffic, leverage a collective of people who are already investing in an effort
Lew	Cloud computing based on virtualization
Mike	More & more enterprises moving in the cloud, gain durability & resilience which was not an option because of a single data center
Jeremy	Legacy apps are easiest to move into cloud, they are better understood and can scale easily
Prashant	Cloud is the right approach/dream, not there yet. Traditional apps can be moved into cloud.
Thorsten	Flexibility in development and tests, DBA clone another slave server with exactly the same setup to test out schema changes
Monty	Spin up EC2 instances, run the tests and shut them down ... everything in approx $1. Give it back to the cloud and make it more efficient for the world in general.
Lew	We are making it so affordable, cost can be 10% of what it was before.

Cloud adoption barrier

Chander	Performance, a customer requested a refund where they were trying to shove a 1TB in an hour. US is 6Mbps, needs to significantly increase before it can be utilized.
Thorsten	Compute needs to move where the data is.
Chander	Most businesses will find bandwidth/redundancy limited. Customer always need to customer where not to use cloud and set expectations accordingly

What apps will never move to cloud ?

Lew	Financially sensitive applications, owning your own data center
Chander	Trust and privacy, it's more about education though. Encryption is going tobe a key.
Jeremy	Competitiion, unless other companies battle it out and making it easy to to migrate from one service to other, it'll be difficult. Avoid vendor lockin.

Are there cloud standards ?

Mike	Based on open industry standards,  no deep rooted concern in the user community
Thorsten	Way to operate across different clouds, API is not the most important level. What is a server ? Can I hibernate it, mount it, how much storage volume is allowed, cross-data center boundary are a better abstraction.
Lew	Very early to lock the standards, everybody is currently in a stage of experiementation
Monty	Potential downside to premature standardization, too early to jump to standards
Chander	Open standards are a definite key to success. S3 fostered innovation.
Thorsten	S3 is a good standard but not an open API. It will be doubly nice if it's "free" or "open" or whatever the word is.
Mike	Standards dont really matter if the performance cannot be met. When innovating at a rapid rate, it' difficult to make everybody agree upon standards.
Lew	At least publish the API where everybody can use them.
Chander	Showing backup to Sun cloud, Sun has S3 compatible APIs, also compatible to WebDAV.

Cloud Business Opportunities

Monty	You can
Mike	Very unique and compelling business opportunity. Amazon Dev Pay: Buy infrastructure on demand, setup your software on AMI, set your own price and then customers can use it, "Software as a Innuity"
Chander	Traditional backup vendors will be worried.
Prashant	Database on the cloud
Lew	Seeing an explosion in the amount of data/compute required, accordingly analytics. Tremendous amount of opportunity when Cassandra & Drizzle are cloud-enabled.
Mike	More ISVs in the cloud.
Jeremy	How to do performance tuning and optimizations in cloud, do that for major cloud infrastructure.
Monty	Freedom to work from anywhere, don't need to be physically at the datacenter, enables multinational consulting
Chander	When more clouds become available, it'll be explosion which will happen later this year.

How is cloud measured ?

Jeremy	CPU time in terms of use, storage centric clouds pay for integrity
Lew	Creating Data centers with loading docks.
Monty	Paying for CPU cycle, like mainframe model.
Thorsten	Cloud is like mainframe but very elastic.
Chander	Billing is not a challenge, storage clouds are better because of pricing, compute is challenging

Databases & Clouds

Thorsten	Flexibility of moving to the next volume, master, slave makes is very refreshing
Monty	Start out thinking M x N problems, never think about one database instance in cloud, there will be X > 1

And the shootout had to be shutdown because the timing estimates were slightly misjudged

But all in all, an interesting discussion!

Come meet us at the GlassFish booth in the Exhibit Floor. Or you can stop by at room #205 for the Whisper Suite for a more personal and 1-1 conversation.

Technorati: conf mysqlconf mysql santaclara glassfish cloud

MySQL Users Conference 2009 Day 2

Posted by arungupta on April 21, 2009 at 09:53 PM | Permalink | Comments (0)


I presented on Creating Quick and Powerful Web Applications with MySQL, GlassFish, and NetBeans. The key messages conveyed during the preso are:

• GlassFish is an open source community and delivers production-quality Java EE compliant Application Server.
• GlassFish v2 is the Java EE 5 Reference Implementation and GlassFish v3 for Java EE 6. Read complete difference here.
• Java Persistence API makes it really easy to create database-backed Web applications. It even creates MySQL-specific queries, when possible.
• The web-based administration console and CLI are powerful GlassFish management tools that meets the need of any IT administrator.
• NetBeans provides comprehensive and seamlessly integrated tooling for GlassFish. The goal is to make the Eclipse tooling at par with NetBeans.

The slides are available here.

And then notes from some of the sessions I attended:

State of the Dolphin

• 12+ million users, 70k downloads/day, 1100 MySQL Partners
• Multiple platforms: LAMP, Windows, Mac, OpenSolaris, Solaris, RedHat, Suse, Ubuntu
• Multiple Languages: php, Perl, Python, Ruby, Java, C, C++, C#
• MySQL 5.1: 3 million downloads in 100 days
• MySQL 5.4 announced: InnoDB Scalalbility, Sub-query optimizations, 59% faster than 5.1, 40% improvement in read/write test, 71% throughput increase
• InnoDB: Fast index creation (add/drop indexes w/o copying the data), Data compression (shrink tables, to significantly reduce storage and i/o)
• Embedded InnoDB (announced today): Proven high-performance and reliability and functionality of InnoDB, low-level but powerful non-SQL API for app programmers, operational characteristics needed for stand-alone apps where there is no DBA
• Dr DBA was awarded "Acquirer of the Year: Oracle" :-)
• MySQL Cluster 7.0: 99.999% availability, 4.3x higher throughput, 140k+ TPM and 4x less power and consumption than 6.3
• MySQL Query Analyzer: Continuous query monitoring, find and fix problem SQL code, historical and real-time analysis, drill down into execution statistics
  

InnoDB: Innovative Technologies for Performance and Data Protection

• Dr Heikki Tuuri, was professor at Helsinki, founded Innobase, got acquired by Oracle
• Performance and Data Integrity are basic features
• Architected and written by one person
• Full transaction support, Unlimited row-level locking, multi-version read-consistency, automatic deadlock detection
• Innovative: adaptive hash indexes, insert buffer (performance benefits), doublewrite buffer, InnoDB plugin
• Oracle/Innobase + Sun/MySQL
  

Rethinking MySQL, Enter Drizzle

• Goals
• Pluggable/Infrastructure Aware
• Community Developed
• Multicore/Concurrency (load up 10,000 connections in db)
• Focus on Web applications/enable others
• Modernize codebase for manageability (currently C/C++, can we reuse STL and other libraries)
• Philosophies
• Have open and well-documented interfaces
• Have transparent goals and processes, that are communicated publicly
• Have fun and encourage collaboration
• Remove barriers to contribution and participation for everyone
• Enable contributors to build a business around Drizzle
• Drizzle announced at OSCON last year
• Translated into 30+ languages since then
• 7% of developers are from Sun
• 100+ contributors (>500 on the mailing list), even Postgres and Firebird developers \
• Cirrus available now, Aloha next
• Drizzle Developer Day 2009 scheduled this Friday
• No patches are contributed back to MySQL Enterprise
• Will be ready for production deployment Jun 2010
• References
• launchpad.net/drizzle
• IRC #drizzle
• Email

High Performance Rails and MySQL

• David Berube: Apress books on "Author Practical Ruby Gems", "Practical Rails Plugins", "Practical Reporting with Ruby on Rails"
• Finding performance issues in Rails
• Rails development log
• eabe_db_tools: Ajax popup- displays query count, query each time for a each query on a page. Will be available on github next week.
• mysql_slow_log
• Is it a database problem: Firebug, YSlow, Ping, tracert, etc.
• Let the database do the heavy lifting instead of Ruby: for example, don't sort in Ruby
• Deep eager loading: don't load that is not required
• Use built-int Rails grouping and aggregate functions
• Caching: simple ootb caching, Cache Fu, MySQL triggers for DB function caching, Rails triggers for other caching

Did you know 1.3 billion emails were sent as part of Obama's election campaign - and all powered by MySQL ? Hear the details from Blue State Digital engineers who created the solution and maintained it:


And you can always read the complete case study.

Some pictures from earlier today ...


And then the evolving picture album is available at:



Come meet us at the GlassFish booth in the Exhibit Floor. Or you can stop by at room #205 for the Whisper Suite for a more personal and 1-1 conversation.

Technorati: conf mysqlconf mysql santaclara glassfish netbeans

MySQL Users Conference 2009 Day 1 in Photos

Posted by arungupta on April 20, 2009 at 09:17 PM | Permalink | Comments (1)


MySQL Users Conference started earlier this morning with tutorials. I attended MySQL Cluster Tutorial and part of Scale-Up, Scale-Out, and High Availability: Solutions and Combinations. Both of them were very involving with practical real-life advice.

Here are tweets from the morning of MySQL Cluster Tutorial:







And now the tweets from "Scale-Up, Scale-Out, and High Availability: Solutions and Combinations" session:



Here are some pictures captured during the day:


And tomorrow I present on Creating Quick and Powerful Web Applications with MySQL, GlassFish, and NetBeans.

And then the evolving picture album is available at:



Come meet us at the GlassFish booth in the Exhibit Floor.

Technorati: conf mysqlconf santaclara glassfish netbeans

GlassFish and NetBeans at MySQL Users Conference 2009

Posted by arungupta on April 17, 2009 at 06:13 AM | Permalink | Comments (4)



What is open source, production-quality, supported by a large vibrant community, and comes with full enterprise support ? - GlassFish and MySQL.

Did you know that GlassFish ...

• is the only open-source Java EE 5 compliant Application Server
• can be used to deploy Rails, Grails, and Django applications
• has 13x better price/performance than Dell/HP, and therefore a much lower TCO
• has an easy-to-use and intuitive web-based administration console
• has enterprise features like clustering/high availability, .NET-interoperable Web services, ...

Are you attending MySQL Users Conference 2009 and interested to learn how GlassFish and MySQL together provides an ideal deployment platform for all your web applications ?

There are several other advantages which I'll be speaking on Creating Quick and Powerful Web Applications with MySQL, GlassFish, and NetBeans and the coordinates are:

When:	April 21, 2009 (Tuesday), 3:05 pm
Where:	Ballroom A

You can also find us on the Exhibitor Floor!

Technorati: conf glassfish netbeans mysql mysqlconf santaclara

LOTD #20: How to create a JPA application using GlassFish Tools Bundle for Eclipse ?

Posted by arungupta on April 09, 2009 at 11:27 AM | Permalink | Comments (0)


Here is a great screencast (from the community) that shows how to create a JPA application using EclipseLink and deploy on GlassFish v2.1 - all using GlassFish Tools Bundle for Eclipse.

Click on the image below for the video:



Thanks!

I'll work on a MySQL version of it :)

All previous links in this series are archived at LOTD.

Technorati: lotd glassfish eclipse jpa javadb screencast

TOTD #78: GlassFish, EclipseLink, and MySQL efficient pagination using LIMIT

Posted by arungupta on April 08, 2009 at 05:52 AM | Permalink | Comments (2)

EclipseLink JPA replaces TopLink Essentials as the JPA implementation in GlassFish v3. One of the benefits of using EclipseLink is that it provides efficient pagination support for the MySQL database by generating native SQL statements such as "SELECT ... FROM <table> LIMIT <offset>, <rowcount>".

The MySQL LIMIT clause definition says:

The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement. LIMIT takes one or two numeric arguments, which must both be non-negative integer constants (except when using prepared statements).

With two arguments, the first argument specifies the offset of the first row to return, and the second specifies the maximum number of rows to return. The offset of the initial row is 0 (not 1):

SELECT * FROM tbl LIMIT 5,10;  # Retrieve rows 6-15

So instead of fetching all rows from the database and then filtering from row 6-15, only rows 6 through 15 are fetched.

This TOTD (Tip Of The Day) explains how to create a JPA Persistence Unit for sakila (MySQL sample database) using NetBeans, use EclipseLink as the Persistence Provider, and then write a JPA query to leverage the pagination support - all on GlassFish v3.

1. Create a Persistence Unit for "sakila" as explained in this blog using bullets #1 - 3. The differences are explained below:
1. In 2.1, choose "GlassFish v3 Prelude" as the server. Even though "GlassFish v3 Prelude" is chosen as the server but it will be replaced with a recent promoted build because pagination feature is not implemented in the Prelude. Alternatively you can use NetBeans 6.7 M3 and GlassFish v3 as explained here.
2. In 3.3, EclipseLink is shown as the default Persistence Provider as shown below:
   
   
3. In 3.5, there is no need to specify the properties for "user" and "password as the JDBC resource is stored in the server configuration. Instead specify the following property:
   
   

   <properties>     <property name="eclipselink.logging.level" value="FINE"/> </properties>

   
   This will log any SQL statement sent by JPA to the underlying persistence provider (EclipseLink in this case).
2. If GlassFish v3 was configured using NetBeans 6.7 M3, then the JDBC Connection Pool and JDBC resource were created in the server directly. If not, then download and unzip the latest GlassFish v3 latest promoted build (b43 as of this writing). Create the JDBC Connection Pool as:
   
   

   ./asadmin create-jdbc-connection-pool --datasourceclassname com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource --property user=duke:password=glassfish:ServerName=localhost:portNumber=3306:databaseName=sakila jdbc-mysql-pool

   
   and the JDBC resource:
   
   

   ./asadmin create-jdbc-resource --connectionpoolid jdbc-mysql-pool jndi/sakila

   
   GlassFish v3 b43 bundles "Eclipse Persistence Services - 2.0.0.r3652-M1". A later blog will explain how to replace the bundled EclipseLink version with a newer/different EclipseLink version.
3. Create a new Servlet "QueryServlet". Inject the javax.persistence.EntityManagerFactory resource:
   
   

   @PersistenceUnit     EntityManagerFactory emf;

   
   and change the "processRequest" operation to:
   
   

   EntityManager em = emf.createEntityManager();         response.setContentType("text/html;charset=UTF-8");         PrintWriter out = response.getWriter();         try {             int startRow = Integer.valueOf(request.getParameter("start_row"));             int howMany = Integer.valueOf(request.getParameter("how_many"));             Query q = em.createNamedQuery("Film.findAll");             q.setFirstResult(startRow);             q.setMaxResults(startRow + howMany);             for (Object film : q.getResultList()) {                 out.print(((Film)film).toString() + "<br/>");             }         } finally {             out.close();         }

   
   This Servlet reads two parameters from the request and sets parameters on the JPA Query to enable pagination.
4. Deploy the application on GlassFish v3.
1. Using NetBeans 6.7 M3, select "Deploy" from the context-sensitive menu.
2. Using NetBeans 6.5.1, select "Clean and Build" and then manually deploy the WAR file using "asadmin deploy dist/Pagination.war".

If the project name was "Pagination", then the Servlet is accessible at "http://localhost:8080/Pagination/QueryServlet?start_row=1&how_many=10" and shows ten rows starting at index "1". The output looks like:



The log file in "domains/domain1/logs/server.log" show the following SQL query generated by EclipseLink:

[#|2009-04-07T14:01:12.815-0700|FINE|glassfish|org.eclipse.persistence.session.file: /Users/arungupta/tools/glassfish/v3/b43/glassfishv3/glassfish/domains/domain1/applications/Pagination/WEB-INF/classes/-PaginationPU.sql| _ThreadID=15;_ThreadName=Thread-1;ClassName=null;MethodName=null;|SELECT film_id AS film_id1, special_features AS special_features2, last_update AS last_update3, rental_duration AS rental_duration4, release_year AS release_year5, title AS title6, description AS description7, replacement_cost AS replacement_cost8, length AS length9, rating AS rating10, rental_rate AS rental_rate11, language_id AS language_id12, original_language_id AS original_language_id13 FROM film LIMIT ?, ?         bind => [1, 11]|#]

As you can see, the query uses the LIMIT clause which optimizes the data returned from the table.

If a different database, for example Derby, is used then the generated SQL query looks like as:

[#|2009-04-07T17:00:34.210-0700|FINE|glassfish|org.eclipse.persistence.session.file: /Users/arungupta/tools/glassfish/v3/b43/glassfishv3/glassfish/domains/domain1/applications/Pagination/WEB-INF/classes/-PaginationPU.sql| _ThreadID=15;_ThreadName=Thread-1;ClassName=null;MethodName=null;|SELECT film_id, special_features, last_update, rental_duration, release_year, title, description, replacement_cost, length, rating, rental_rate, language_id, original_language_id FROM film|#]

In this case, the entire table is fetched and the rows are filtered based upon the critieria specified on the client side.

If the number of rows is huge (a typical case for enterprise) then MySQL provides efficient fetching of records. And GlassFish v3, with EclipseLink JPA integrated, makes it much seamless for you.

Thanks to Mr GlassFish Persistence (aka Mitesh :) for helping me understand the inner workings.

Discuss this more at Creating Quick and Powerful Web Applications with MySQL, GlassFish, and NetBeans technical session in the upcoming MySQL Users Conference!

Please leave suggestions on other TOTD (Tip Of The Day) that you'd like to see. A complete archive of all the tips is available here.

Technorati: totd glassfish v3 eclipselink jpa mysql

LOTD #19: Securing GlassFish Installation

Posted by arungupta on April 07, 2009 at 10:16 AM | Permalink | Comments (0)


Found great (old) blogs (part 1, part 2) by Masoud Kalali that discusses the different ways to secure a GlassFish installation.

Changing master password and admin console passwords (both web-based and CLI) are two fairly trivial operations:

/tmp/glassfish >./bin/asadmin change-master-password Please enter the new master password>changeit2 Please enter the new master password again>changeit2 Master password changed for domain domain1

and

/tmp/glassfish >./bin/asadmin change-admin-password Please enter the old admin password>adminadmin Please enter the new admin password>adminadmin2 Please enter the new admin password again>adminadmin2 Updated .asadminpass file with new password. Command change-admin-password executed successfully.

And then the blog discusses how to secure administration listener using client-cert authentication or mutual authentication, reduce the visibility of listeners (as appropriate), and other similar techniques. Read Part 1 and Part 2.

The GlassFish Administration Guide provide more details on how to manage your GlassFish installation!

Technorati: glassfish administration security

GlassFish at San Francisco Java Users Group - May 12th, 2009

Posted by arungupta on April 07, 2009 at 10:15 AM | Permalink | Comments (0)


Are you living in the San Francisco Bay Area and like to hear all the craze around GlassFish ?

Jan Luehe (from the GlassFish Webtier team) and Roberto Chinnici (Java EE 6 specification lead) will be speaking on May 12th at the San Francisco JUG meetup. So get ready to drink from the firehose :)

There will be pizza, refreshments, book giveaways and other interesting goodies!

Click on the map below for directions:



Complete details about the event here, make sure to RSVP!

Technorati: conf glassfish jug sanfrancisco meetup