At least the 7.1 RC3 driver has a memory leak in that the .../jdbc2/PreparedStatement.java class uses Java's ThreadLocal object for "optimization" reasons. However, Sun's J2SE 1.3 leaks memory whenever this class is used. Hence, repeated use of the JDBC driver's PreparedStatement class will cause a major memory leak. Our application running on the Orion application server using PostgreSQL will crash with an OutOfMemoryError in less than an hour while stress testing. Our workaround is to disable the ThreadLocal object by patching the driver before using it. The patch is simple and small; instead of using the ThreadLocal object to retrieve a thread-local SimpleDateFormat instance so that it doesn't have to be instantiated each time (this is the optimization), just instantiate the SimpleDateFormat class each time. We've noticed no performance loss and our application no longer has any memory leaks. Please consider fixing this problem before releasing 7.1. Thanks. Gerald. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
