Monday, October 19, 2009

Wicket in iPhone Development

Since Apple released iPhone on June 29th 2007, it has attracted a lot of attention. It revolutionizes the mobile world with its novel touch screen and motion sensor. In addition, iPhone SDK provides developers with new possibilities to bring their creativity on the mobile platform. The advent of iPhone has certainly brought mobile computing to next generation.

Wicket is a lightweight Java web framework. After prototyping, Wicket quickly caught my interest due to its Simplicity, Clean Separation of Concerns, and Ease of Deployment. With my experience in Swing, I found it familiar and easy to use, especially for small scale web development.

To start with Wicket, first download the latest binary from Apache Wicket. The latest stable version at the time of this writing is 1.4.1. Here is a hello world example:

web.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE web-app
PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>
  </display-name>MyApp</display-name>
  <filter>
    <filter-name>MyApp</filter-name>
    <filter-class>org.apache.wicket.protocol.http.WicketFilter</filter-class>
    <init-param>
      <param-name>applicationClassName</param-name>
      <param-value>com.mycompany.wicket.MyApp</param-value>
    </init-param>
  </filter>
</web-app>

Next, you can start developing your web application. A Wicket page consists of two parts, HTML and Java class. They should have the same naming, but just with different file extension. For instance, HelloPage.html and HelloPage.java.

HelloPage.html
<html>
  <head>
    <title>Hello World</title>
  </head>
  <body>
    <span wicket:id="hello">Label here</span>
  </body>
</html>
HelloPage.java
package com.mycompany.wicket;

import org.apache.wicket.markup.html.WebPage;
import org.apache.wicket.markup.basic.Label;

public HelloPage extends WebPage {

  public HelloPage() {
    add(new Label("hello", "Hello World"));
  }

}
Please notice Wicket defines a property wicket:id which is used in Java for correlation. The discerning reader may notice that the text "Label here" will be replaced with "Hello World" in this example. It provides the clean way to separate the view from controller and model. Therefore, web designer can prototype the web pages with mockup data and only need to deal with pure HTML.

Remember we set applicationClassNamein web.xml. Before deployment, this class need to be created. In this example, we configure the bookmarkable URL for HelloPage.class as "/hello". Now, it's time to deploy the web application. I chose Jetty in favor of its lightweightness so that it's fast to test. Once deployed, you could access the page by pointing your browser to http://127.0.0.1:8080/hello if on local.

MyApp.java
package com.mycompany.wicket;

import org.apache.wicket.markup.html.WebApplication;

public MyApp extends WebApplication {

  @Override
  public void init() {
    super.init();
    mountBookmarkablePage("/hello", HelloPage.class);
  }

  @Override
  public Class getHomePage() {
    return HelloPage.class;
  }

}

You should see "Hello World" if everything goes smoothly so far. However, you will find it's not displayed in correct zoom level on iPhone. To solve the issue, simply add following line in the header of your HTML.
<head>
  <meta name="viewport" content="width=device-width; initial-scale=1.0; maximum-scale=1.0;">
  <title>Hello World</title>
</head>

Programming on mobile devices has its own discipline which lies in the limitations of the resources such as CPU power, memory, network bandwidth, just to name a few. There may be some unexpected behaviors when you start testing on the handset. For instance, you might see a noticeable flash while navigating pages. Following is a list of some advices:

1. Avoid background images in CSS.
2. Store larger static files in native application.
3. Delayed refresh and update in a batch.
4. Server side caching (ex. Hibernate caching).
5. Avoid using redirect.

The iPhone SDK allows you to create sleek and user-friendly interface. And mobile web provides you the flexibility to update your software. How you decide to use them really depends on your requirements. A common best practice is try to mimic the look and feel of native interface for you mobile web if used. It will give your users better navigation experience.

Thursday, October 15, 2009

Hibernate, C3p0, and MySQL

In today's applications, database connection pooling is a common best practice. It improves performance by reusing existing connections as establishing a new one is fairly expensive. C3p0 is one of the well-known database connection pool libraries. And Hibernate is now the de facto standard for object-relational mapping (ORM) in Java world. Here is a sample configuration to use C3p0 in Hibernate for MySQL database:
<!-- Basic -->
<property name="hibernate.connection.driver_class">org.gjt.mm.mysql.Driver</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
<property name="hibernate.connection.url">jdbc:mysql://127.0.0.1/test</property>
<property name="hibernate.connection.username">username</property>
<property name="hibernate.connection.password">password</property>
<property name="hibernate.connection.default_schema">test</property>

<!-- C3p0 -->
<property name="hibernate.c3p0.acquire_increment">1</property>
<property name="hibernate.c3p0.idle_test_period">300</property>
<property name="hibernate.c3p0.timeout">120</property>
<property name="hibernate.c3p0.max_size">25</property>
<property name="hibernate.c3p0.min_size">1</property>
<property name="hibernate.c3p0.max_statement">0</property>
<property name="hibernate.c3p0.preferredTestQuery">select 1;</property>
Two properties to put focus on are idle_test_period and timeout. The property idle_test_period defines the interval to test unchecked-out connections while timeout is the time unused connections can live in the pool. However, you might see Communication Link Failure errors occasionally in your log, even though it's configured to have connections tested. Listed are some possible causes:

Network
Make sure your system allows connecting to the database. For example, your unix system may have /etc/hosts.allow or /etc/hosts.deny turned on for access control. Or your firewall could block or kill your connections based on the rules.

Database
Check the system configuration on your database. MySQL has a wait_timeout setting which will close the connections idle over a period of time. If your idle_test_period and timeout are greater than MySQL wait_timeout (28800 seconds by default), your unused connections will have chance to be reset by MySQL server before tested or timed out by C3p0.

Configuration
Choose the connection pool library for your configuration. By default, Hibernate should pick the right one for you. But, if there are more than one connection pool libraries on your classpath, it may not be the way you expect. Hibernate allows you to specify the library by setting the property provider_class as follows:
<property name="hibernate.connection.provider_class">
  org.hibernate.connection.C3P0ConnectionProvider
</property>
Of course, you could just simply remove other connection pool libraries.

Reference
How to configure the C3P0 connection pool