it just cross my mind that is it because of this line of config in my applicationContext.xml:
<property name="maxOpenPreparedStatements"> <value>100</value> </property> if so, i suppose i only need to reduce the value? what would be the proper value please? thanks. zqzuk wrote: > > Hi, i m using Hibernate, Spring and Tapestry and PostgreSQL in this > software. the software includes extensive database opertaions incl query, > update, insert, but no db creation or such. > > atm all functions are working properly, but a serious problem is that > after a buntch of method calls my memory is running out. i checked system > status and i noticed there are almost 70 pgadmin.exe threads! and the > figure is rising as more db operations are performed. it seems that > each time a query is made, a separate thread is created, and none is > released. > > this is a severe problem as it means my software can not run properly.... > is it because i did wrong with configuration? or theres serious problem > in my code? but with hibernate and spring the db connection is handled by > the program by itself isnt it? > > how can i solve this problem please, thanks so much! > > > -- View this message in context: http://www.nabble.com/pgadmin-eats-up-memory-tf2116332.html#a5835715 Sent from the Hibernate forum at Nabble.com. ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ hibernate-devel mailing list hibernate-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hibernate-devel