hibernate-devel

[Hibernate] pgadmin eats up memory

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

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#a5835638
Sent from the Hibernate forum at Nabble.com.

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.

Re: [Hibernate] pgadmin eats up memory

[Emmanuel B. <emm...@hi...>]

you need to go to the user forum http://forum.hibernate.org for such help.
This is the Hibernate development mailing list

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!
>
>
>