Miles to go ...

FISL 2009 Wrapup - 3 talks, 1 talk show, 14 blogs, 10 videos, 275 pics, 2 GlassFish production stories

FISL 2009 wrapped up over the weekend. Even though the conference officially ended on Saturday but the connections made there will certainly allow us to continue all the great momentum. The conference celebrates open source and it was certainly great to see Federal Government and Banks with their booths in the exhibitor halls. The visit by Brazilian President Lula certainly highlights the importance of this conference to the local community. There were booths from Debian, Firefox, Ubuntu and other major open source softwares. Some commercial vendors had a booth as well and of course Sun Microsystems had a big presence with GlassFish, Open Solaris, NetBeans, MySQL and other offerings.

I delivered 3 talks and participated in 1 talk show:

• Java EE 6 (slides) & Enterprise Features of GlassFish (slides)
• Creating powerful web applications using GlassFish, MySQL and NetBeans/Eclipse slides
• Continuous Integration using Hudson (slides)
• Simon Phipps Talk Show

• GlassFish Swimming to FISL, Brazil
• Javali 2009 Trip Report
• FISL 2009 Day 1 Report
• Porto Alegre - I shoot you, you shoot me
• Running inside Parque Moinhos de Vento, Porto Alegre
• Porto Alegre - I shoot you, you shoot me
• FISL Day 2 in Pictures & Videos
• supercrud.com in Brazil picked GlassFish over JBoss - Find out why!
• Porto Alegre - I shoot you, you shoot me
• Digital TV-based Banking using GlassFish, NetBeans and MySQL - Ginga community in Brazil
• FISL 2009 Day 3 in Pictures & Videos
• Porto Alegre - I shoot you, you shoot me
• FISL 2009 Day 4 in Pictures
• Porto Alegre - I shoot you, you shoot me

Posted by Arun Gupta in General  |  Comments[0]

Digital TV-based Banking using GlassFish, NetBeans and MySQL - Ginga community in Brazil

Learn how GlassFish and NetBeans helped Ginga community to build a TV Banking application in Brazil. See a live demo of the product, it's really exciting!

Why GlassFish ? - They love how NetBeans tooling completely hides the complexity of what's happening underneath and the ease-of-use with GlassFish.


Thanks Hugo Lavalle for the interview and good luck with your product!

Technorati: conf fisl brazil glassfish story netbeans mysql ginga digitaltv banking

Posted by Arun Gupta in General  |  Comments[4]

FISL 2009 Day 1 Report

I presented on "Creating powerful web applications using GlassFish, MySQL and NetBeans/Eclipse" as the first talk of FISL 10 yesterday. The room was only partial full being the first talk of FISL but got packed towards the middle so that was exciting. The slides are available here.

The key message is that NetBeans and Eclipse provide a seamless development/deployment environment for GlassFish.

The several demos shown in the talk are explained at:

• CRUD operations using NetBeans, JPA and MySQL
• Publish MySQL Table as a RESTful Web service
• Develop, Deploy and Debug Rails Application on GlassFish using NetBeans
• GlassFish Tools Bundle for Eclipse
• End-to-end problem solving using GlassFish v3 + MySQL DTrace probes
• GlassFish Price/Performance Advantage

Posted by Arun Gupta in General  |  Comments[7]

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)

Posted by Arun Gupta in General  |  Comments[10]

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

John Powell from eMapSite stopped by at the Whisper Suite in MySQL Users Conference earlier today to talk about his GlassFish issue. The possible workaround was suggested and then the discussion became interesting on how GlassFish is used for offshore monitoring of windfarms and process weather forecasting data. Hear all about it and watch a flashy demo of their product in this video:


NetBeans, GlassFish, and MySQL is their development stack with a "very positive experience"!

Stay tuned for the stories entry.

And the complete picture album is available at:



Technorati: conf mysqlconf mysql santaclara glassfish netbeans

Posted by Arun Gupta in General  |  Comments[1]

MySQL Users Conference 2009 Day 3 - Cloud Shootout

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

Posted by Arun Gupta in General  |  Comments[4]

MySQL Users Conference 2009 Day 2

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.

• 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
  

• 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
  

• 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

• 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

Posted by Arun Gupta in General  |  Comments[4]

GlassFish and NetBeans at MySQL Users Conference 2009

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, ...

Posted by Arun Gupta in General  |  Comments[6]

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

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".

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

ISV & OEMs Webinar Replay: GlassFish- and MySQL-Backed Applications with Netbeans and JRuby-on-Rails

I presented a webinar for ISV and OEMs on "Developing GlassFish- and MySQL-Backed Applications with NetBeans and JRuby-on-Rails" last week.



The slides and a complete recording of the webinar are now available here.

Technorati: webinar glassfish mysql netbeans jruby rubyonrails

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

Customers frustrated with Oracle's maintenance and support prices - GlassFish & MySQL can offer relief

Here are some quotes from a recent article talking about Oracle's maintenance and support fees:

Before Oracle acquired BEA earlier this year, the company charged 18% to 20% for support and maintenance. Oracle increased those fees to meet its own structure and also raised list prices on most BEA products.

That didn't sit well.

and


One Java-centric VAR, who spoke on the condition of anonymity, said some of his BEA WebLogic customers are moving to alternative application servers just to get away from Oracle.

and

"What company comes in this climate and not only jacks up prices but support prices as well?" asked one frustrated BEA customer, who spoke on the condition of anonymity.

and

"Many SAP and Oracle customers intend to push back their maintenance fees," he said. "Customers seek an option to just pay for tax and compliance updates without paying for future innovation. They are willing to pay for future modules when that time comes. If they can't access such options, they would prefer third party options like Rimini Street for Oracle [E-Business Suite] and SAP's applications."

Have you been bitten by Oracle's price raise ?

Interested in an industry-grade, highly performant, feature-rich, and open source alternative ?

GlassFish and MySQL together provide an excellent choice - give it a try!

Technorati: glassfish mysql opensource sun oracle

Posted by Arun Gupta in General  |  Comments[1]

Developing GlassFish- and MySQL-Backed Applications with Netbeans and JRuby-on-Rails - Free Webinar on Mar 26

This is a re-run of an earlier webinar.

Would you like to know how JRuby,NetBeans, GlassFish, and MySQL can power your Rails applications ?



This informative technical webinar explains the fundamentals of JRuby and how the NetBeans IDE makes developing/debugging/deploying Rails applications on GlassFish quick, fun and cost-effective.

The webinar starts 10am PT on Mar 31st, 2009 and can be accessed from a browser.

Register here.

Technorati: jruby rubyonrails glassfish netbeans mysql webinar

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

Webinar Replay Available: GlassFish and MySQL-backed applications with NetBeans and JRuby-on-Rails

I presented a webinar on "Developing GlassFish- and MySQL-Backed Applications with NetBeans and JRuby-on-Rails" last week.



The slides and a complete recording of the webinar are now available here.

Technorati: webinar glassfish mysql netbeans jruby rubyonrails

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

Developing GlassFish- and MySQL-Backed Applications with Netbeans and JRuby-on-Rails - Free Webinar on Jan 27

Would you like to know how JRuby, NetBeans, GlassFish, and MySQL can power your Rails applications ?



This informative technical webinar explains the fundamentals of JRuby and how the NetBeans IDE makes developing/debugging/deploying Rails applications on GlassFish quick, fun and cost-effective.

The webinar starts 10am PT on Jan 27th, 2009 and can be accessed from a browser.

Register here.

Don't miss out, it's going to start in less than 12 hours!

Technorati: jruby rubyonrails glassfish netbeans mysql webinar

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

Sun Tech Days 2009, Singapore - Welcome Reception

Follow up from Part 1.

Attended "What Developers should care about MySQL ?" by Colin and "Groovy and Grails" by Chuk-munn Lee.

I enjoyed both the talks for different reasons. Colin's talk explained the pluggable storage engine architecture that is unique to MySQL (pronounced my-ess-kew-ell, not my-sequel). It was interesting to know that the different storage engines can be picked a la carte based upon the requirements. The performance comparison for INSERTs was 5x between MyISAM, InnoDB and Archive storage engines. But then InnoDB provide transactions and other goodies. Multiple performance tuning tips such as using negative unsigned int instead of BIGINT and partitioning databases if the number of records grow more than 1 billion were good! Keep an eye on his blog for slides.

Chuk's talk introduced Groovy, Grails, showed several samples of NetBeans and Grails integration. A Grails application can be deployed as a WAR file on GlassFish. Alternatively you can download the Grails module from GlassFish v3 Update Center and use the standard "run-app" command to run your Grails application using the embedded GlassFish v3 instead of Jetty. This is explained nicely in the screencast below:


Here are couple of pictures from rest of the day:

Posted by Arun Gupta in General  |  Comments[3]