Setup
I have been doing some work on the Ibatis sql maps, setting up caches for query results and defining some dynamic statements. I have not used the dynamic statements before, but found this feature to be very useful. In short, a dynamic statement can contain comparisons, which check the arguments of the statement and modify the resulting SQL query. So far, I have found that using dynamic statements minimize the number of queries in the sql maps, since several, similar statements can be defined using just one dynamic statement.
This reminds me that I made a mental note to post something about the basic setup of this application and
gersbo.net
. The
gersboweb
application is deployed on a Tomcat servlet container, using an Apache web server instance as proxy. The dynamic content of the application is stored in a Postgresql relational database.
The application itself is a J2EE web app, which uses the Struts MVC application framework. The reference to the sql maps refers to the Ibatis data abstraction layer, which I use for the interaction between the application and the postgresql database.
I have been using (and use) several tools to develop the
gersboweb
application. As a possible inspiration to others and to give due credit to the tool makers, I think I should mention the list of tools:
- The JetBeans IntelliJ IDEA IDE is versatile and easy configurable IDE for Java applications. I really cannot recommend it enough.
- TextPad editor is a powerful text editor. You can download definition files for syntaxes, spell checking etc. at the TextPad website.
- DBManager Professional 2.2.0 by DBTools Software is a free management tool for the Mysql and Postgresql database systems.
- DbVisualizer from Minq software is a JDBC based database management tool (Minq used to have a free (w. limited functionality) edition available at their website, but I cannot seem to find it these days).
- I use the Zaval JRC Editor to maintain files containing locale specific resources.
If you enjoyed this post, make sure you subscribe to my RSS feed!