Googlebot, CookieLocaleResolver and default locale

Googlebot doesn't set a locale on request.

What does this mean? Well, in my case when I localized www.uutispuro.fi, googlebot only minded about english content. Even if I made different urls and sitemaps for webmaster tools.

Why such a behaviour? I'm using Spring's CookieLocalResolver, and ofcourse it had a default to en_US. This took a while for me to notice. Setting the default to "fi" does what I was expecting in the first place.

<bean id="localeResolver" class="org.springframework.web.servlet.i18n.CookieLocaleResolver">
  <property name="defaultLocale" value="fi"/>
</bean>

jpa + hibernate + spring + c3p0 + hibernate-search pom.xml

Maven pom.xml file for a jpa, hibernate, spring, quartz, hibernate-search app.
Versions: jpa 2, Spring 3, hibernate 3.5, hibernate-search 3.2, c3p0 0.9.1.2

I have been using this for making a rss news site. I decided to share this if someone else is struggling with getting the versions match with hibernate-search and hibernate or getting the right dependencies with c3p0.

I'm using jetty and hsqldb for developing. In production, I have lighttpd in front of jetty and the production database is mysql which I'm using.
 

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>fi.netbox</groupId>
<artifactId>news</artifactId>
<packaging>war</packaging>
<version>1.0-SNAPSHOT</version>
<name>news</name>
<description>Code</description>

<properties>
	<spring.version>3.0.4.RELEASE</spring.version>
	<hibernate.version>3.5.6-Final</hibernate.version>
	<jetty.version>6.1.24</jetty.version>
	<aspectj.version>1.6.0</aspectj.version>
	<debug.level>DEBUG</debug.level>
</properties>

<dependencies>
	<!-- Spring Dependencies -->
	<dependency>
		<groupId>org.springframework</groupId>
		<artifactId>org.springframework.core</artifactId>
		<version>${spring.version}</version>
	</dependency>
	<dependency>
		<groupId>org.springframework</groupId>
		<artifactId>org.springframework.context.support</artifactId>
		<version>${spring.version}</version>
	</dependency>
	<dependency>
		<groupId>org.springframework</groupId>
		<artifactId>org.springframework.jdbc</artifactId>
		<version>${spring.version}</version>
	</dependency>
	<dependency>
		<groupId>org.springframework</groupId>
		<artifactId>org.springframework.transaction</artifactId>
		<version>${spring.version}</version>
	</dependency>
	<dependency>
		<groupId>org.springframework</groupId>
		<artifactId>org.springframework.orm</artifactId>
		<version>${spring.version}</version>
	</dependency>
	<dependency>
		<groupId>org.springframework</groupId>
		<artifactId>org.springframework.web</artifactId>
		<version>${spring.version}</version>
	</dependency>
	<dependency>
		<groupId>org.springframework</groupId>
		<artifactId>org.springframework.web.servlet</artifactId>
		<version>${spring.version}</version>
	</dependency>
	<dependency>
		<groupId>javax.transaction</groupId>
		<artifactId>jta</artifactId>
		<version>1.1</version>
	</dependency>
	<dependency>
		<groupId>org.springframework</groupId>
		<artifactId>org.springframework.aop</artifactId>
		<version>${spring.version}</version>
	</dependency>
	<dependency>
		<groupId>org.springframework</groupId>
		<artifactId>org.springframework.test</artifactId>
		<version>${spring.version}</version>
		<scope>test</scope>
	</dependency>
	<dependency>  
		<groupId>org.hibernate</groupId>  
		<artifactId>hibernate-entitymanager</artifactId>  
		<version>${hibernate.version}</version>  
	</dependency>
	<dependency>
		<groupId>org.hibernate</groupId>
		<artifactId>hibernate-annotations</artifactId>
		<version>${hibernate.version}</version>
	</dependency>
	<dependency>
		<groupId>org.hibernate</groupId>
		<artifactId>hibernate-search</artifactId>
		<version>3.2.1.Final</version>
	</dependency>
	<dependency>
		<groupId>org.hibernate</groupId>
		<artifactId>hibernate-tools</artifactId>
		<version>3.2.4.GA</version>
	</dependency>
	<dependency>
		<groupId>org.hsqldb</groupId>
		<artifactId>com.springsource.org.hsqldb</artifactId>
		<version>1.8.0.10</version> 
	</dependency>
	<dependency>
		<groupId>com.mysql.jdbc</groupId>
		<artifactId>com.springsource.com.mysql.jdbc</artifactId>
		<version>5.1.6</version>
	</dependency>
	<!-- LOGGING DEPENDENCIES - LOG4J -->
	<dependency>
		<groupId>org.slf4j</groupId>
		<artifactId>slf4j-log4j12</artifactId>
		<version>1.4.2</version>
	</dependency>
	<dependency>
		<groupId>log4j</groupId>
		<artifactId>log4j</artifactId>
		<version>1.2.14</version>
	</dependency>
	
	<!--  TestNG DEPENDENCY FOR TESTING -->
	<dependency>
		<groupId>org.testng</groupId>
		<artifactId>testng</artifactId>
		<version>5.7</version>
		<classifier>jdk15</classifier>
		<scope>test</scope>
	</dependency>
	
	<!--  JETTY DEPENDENCIES FOR TESTING  -->
	<dependency>
		<groupId>org.mortbay.jetty</groupId>
		<artifactId>jetty</artifactId>
		<version>${jetty.version}</version>
		<scope>provided</scope>
	</dependency>
	<dependency>
		<groupId>org.mortbay.jetty</groupId>
		<artifactId>jetty-util</artifactId>
		<version>6.1.24</version>
	</dependency>
	<dependency>
		<groupId>org.mortbay.jetty</groupId>
		<artifactId>jetty-management</artifactId>
		<version>${jetty.version}</version>
		<scope>provided</scope>
	</dependency>
	<dependency>
		<groupId>javax.persistence</groupId>
		<artifactId>com.springsource.javax.persistence</artifactId>
		<version>2.0.0</version> 
	</dependency>
	<dependency>
		<groupId>javax.servlet</groupId>
		<artifactId>com.springsource.javax.servlet</artifactId>
		<version>2.5.0</version>
	</dependency>
	<dependency>
		<groupId>javax.servlet</groupId>
		<artifactId>com.springsource.javax.servlet.jsp</artifactId>
		<version>2.1.0</version>
	</dependency>
	<dependency>
		<groupId>javax.servlet</groupId>
		<artifactId>com.springsource.javax.servlet.jsp.jstl</artifactId>
		<version>1.2.0</version>
	</dependency>
	<dependency>
		<groupId>javax.el</groupId>
		<artifactId>com.springsource.javax.el</artifactId>
		<version>1.0.0</version>
	</dependency>
	<dependency>
		<groupId>org.apache.xmlcommons</groupId>
		<artifactId>com.springsource.org.apache.xmlcommons</artifactId>
		<version>1.3.4</version>
	</dependency>
	
	<dependency>
		<groupId>com.sun.syndication</groupId>
		<artifactId>com.springsource.com.sun.syndication</artifactId>
		<version>1.0.0</version>
	</dependency>
	<dependency>
		<groupId>org.jdom</groupId>
		<artifactId>com.springsource.org.jdom</artifactId>
		<version>1.1.0</version>
	</dependency>
	<dependency>
		<groupId>com.opensymphony.quartz</groupId>
		<artifactId>com.springsource.org.quartz</artifactId>
		<version>1.6.2</version>
	</dependency>
	<dependency>
		<groupId>com.mchange.c3p0</groupId>
		<artifactId>com.springsource.com.mchange.v2.c3p0</artifactId>
		<version>0.9.1.2</version>
	</dependency>
	<dependency>
		<groupId>javax.mail</groupId>
		<artifactId>mail</artifactId>
		<version>1.4.1</version>
	</dependency>
	<dependency>
		<groupId>junit</groupId>
		<artifactId>junit</artifactId>
		<version>4.8.1</version>
	</dependency>
	<dependency>
		<groupId>commons-codec</groupId>
		<artifactId>commons-codec</artifactId>
		<version>1.4</version>
	</dependency>
</dependencies>
<build>
	<finalName>news</finalName>
	<resources>
		<resource>
			<filtering>false</filtering>
			<directory>src/main/resources</directory>
		</resource>
		<resource>
			<filtering>false</filtering>
			<directory>src/main/config/${config.dir}</directory>
		</resource>
	</resources>
	<plugins>
		<plugin>
			<groupId>org.apache.maven.plugins</groupId>
			<artifactId>maven-compiler-plugin</artifactId>
			<configuration>
			<source>1.5</source>
			<target>1.5</target>
			</configuration>
		</plugin>
		<plugin>
			<groupId>org.mortbay.jetty</groupId>
			<artifactId>maven-jetty-plugin</artifactId>
			<version>6.1.24</version>
		</plugin>
		<plugin>
			<groupId>org.apache.maven.plugins</groupId>
			<artifactId>maven-war-plugin</artifactId>
			<configuration>
				<webappDirectory>${project.build.directory}/${project.build.finalName}</webappDirectory>
			</configuration>
		</plugin>
	</plugins>
</build>
<repositories>
	<repository>
		<id>com.springsource.repository.bundles.release</id>
		<name>SpringSource Enterprise Bundle Repository - SpringSource Bundle Releases</name>
		<url>http://repository.springsource.com/maven/bundles/release</url>
	</repository>
	<repository>
		<id>com.springsource.repository.bundles.external</id>
		<name>SpringSource Enterprise Bundle Repository - External Bundle Releases</name>
		<url>http://repository.springsource.com/maven/bundles/external</url>
	</repository>
	<repository>
		<id>jboss - public</id>
		<name>jboss - public</name>
		<url>http://repository.jboss.org/nexus/content/groups/public-jboss/</url>
	</repository>
</repositories>
</project>

 

Spring Recipes, second edition

More than a year ago I read a very good book (in my opinion at least), Spring Recipes, A Problem-Solution Approach. It had many things which I needed or wanted to try. Just excellent. Well, time has passed and the first book has shown me everything it has to offer. Time for a new good book about Spring. It seems the solution is the new second edition of Spring Recipes which I just received :) First of all, it has been renewed to Spring 3. It has over 1000 pages (ok, it's quite big), but is there any other book which contains so many detailed things about Spring?

c3p0, Spring, Hibernate and NoResultException

I was fighting for a while with NoResultException and c3p0:s config because I thought that was the problem with NoResultExceptions I got. While making uutispuro.fi I finally realized it wasn't the source of the problem.

I had a method doing a persist and a method doing a merge which I had surrounded with try and catch ... and of course with a finally block doing an em.close().

The problem was with the queries doing a .getSingleResult(). I forgot that these might throw the error in hand, and if they did, the closing of entitymanager wasn't done.


try {
Query query = em.createQuery("select query");
return query.getSingleResult();
} catch (NoResultException e) {
log.debug(e);
} catch (Exception e) {
log.error(e);
} finally {
em.close();
}


Spring controller and redirecting

Two ways to use redirecting. First one uses the url mapping configured in an xml file. The url seems to be the same for the client (or actually is, depends on the situation). The second one tells the client to redirect to a certain page, so the url in the client changes accordingly.

1. Use the Spring url mapping
Map model = new HashMap();
model.put("article_id", "get it from db?");
return new ModelAndView("article", model);


2. Tell the client to go to a certain page
return new ModelAndView(new RedirectView("index.jsp"));