Getting Java TPC-W to work with Postgresql and Tomcat
There is a publicly available TPC-W Java implementation written as
part of Prof. Mikko Lipasti's ECE 902 course at the University of Wisconsin-Madison.
This page provides some information for people who want to get this implementation to
work with the Tomcat servlet container and Postgresql databases, I hope it is useful and can safe you some time.
Amit Manjhi from Carnegie Mellon University, described on his page
how to change the code to fit a Tomcat + Mysql environment, this was a good starting point when introducing the needed changes.
I used the following components to do experiments with the TPC-W Java code:
Tomcat Servlet Container (jakarta-tomcat-4.1.24-LE-jdk14)
Sun J2SDK (j2sdk1.4.1_02)
Postgresql (Postgresql 7.3.2 and the included JDBC driver)
Here is a list of things I did:
11.06.2003: I discovered a recent distrubution of the Java TPC-W which eases the configuration of the SQL statements. You can download it from Jan Kiefer's site.
Questions or suggestions? Please drop me a line.