Re: [Hibernate] pgadmin eats up memory

[zqzuk <ziq...@ho...>]

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.