Wednesday, July 23, 2008

Implement connection pooling in Tomcat 5.5 using Hibernate 3, MySQL 5
Culled from various sources:

Add JDBC driver, mysql-connector-java-5.1.5.jar to apache-tomcat-5.5.xx\common\lib

Add resource-ref to WEB-INF/web.xml
<web-app ...>


        Resource reference to a factory for java.sql.Connection
        instances that may be used for talking to a particular
        database that is configured in the server.xml file.

Add session-factory name attribute and property elements to WEB-INF/classes/hibernate.cfg.xml
    <session-factory name="java:hibernate/SessionFactory">

        <!-- JNDI Connection -->
        <property name="hibernate.connection.datasource">

        <property name="hibernate.dialect">


Add Resource to META-INF/context.xml, alternatively add Resource to GlobalResources in tomcat server.xml
<?xml version="1.0" encoding="UTF-8"?>

<Context path="/MyApp" reloadable="true">

  <Resource name="jdbc/MySqlDS" auth="Container"
    maxActive="100" maxIdle="10" maxWait="10000"
    username="myUsername" password="myPassword"

That should work!

Sunday, June 08, 2008

Struts2 checkboxlist UI tag rendering one item per line
After struggling with this UI tag for a some time today, I gave up and was attempting to use s:checkbox inside of an s:iterator to render one item per line, unsuccessfully.

So, upon revisiting s:checkboxlist, I found that it's a relatively painless thing to override the checkboxlist.ftl file described here,, add a break at the end of this line

<label for="${}-${itemCount}" class="checkboxLabel">${itemValue?html}</label><br />
and save the file in the webapp/template/simple dir of my web application.

Friday, June 06, 2008

Hello, all!

I've maintained a blog for several years on my own server, and decided it was time to move to a lower maintenance solution. Spaces looked like a good choice, so here goes!

Most of my posts will be technically oriented, simply because there's never enough good information when looking for a solution to a tough problem. Blogging serves as documentation for myself, as much as it does for anyone else trying to solve the same or similar problems.

I have experience using Java, CSS, HTML, JavaScript, Struts 2, Maven 2, Hibernate 3 and other Open Source and Internet technologies. Please feel free to contact me with any questions or comments.