HSQLDB - My favorite for small lightweight and robust RDBMS with JDBC interface. Another reason for love? Database backup is trivially easy!
Observation for today: It absorbs OutOfMemory error and returns SQLException that it couldn't connect to the client for the call and subsequent ones.
BTW: Tomcat 4.1.12 is a memory hog, much more than previous versions.