Also you might try tweaking your -Xms (minimum heap size) and -Xmx (maximum heap size) arguments for your JVM. If your PostgreSQL driver does not actually have a memory leak, this may do the trick.
You can Google for specifications and examples. Set these in Catalina.sh CATALINA_OPS. Oliver -----Original Message----- From: users-return-242170-OLIVER.TANGLIN=saic....@tomcat.apache.org on behalf of Ilya Kazakevich Sent: Thu 6/6/2013 5:50 PM To: 'Tomcat Users List' Subject: RE: Tomcat and PostgreeSQL I've never heard about it but looks like JDBC PostgreSQL driver has memory leak. What version of driver do you use? Try to google "postgre SQL JDBC memory leak" Actually any memory leak should be investigated using profiler tool. Google for "java profile memory leaks" Ilya. >-----Original Message----- >From: Hector Del Mestre [mailto:hectordelmes...@gmail.com] >Sent: Friday, June 07, 2013 12:46 AM >To: users@tomcat.apache.org >Subject: Tomcat and PostgreeSQL > >Hello: >I'm on a project and asked me to install Apache Tomcat as server pages and >PostgreSQL as database engine. So far so good and right install everything >correctly. >The application was done with AppFuse architecture originally utlizando >MySQL, but issues like licensing and client wants to use PostgreSQL. >And that is where I'm stuck, because Tomcat (or rather the Java VM) began >comsumir large amount of memory (I get 1.5 GB of RAM) when using the >application and there comes a time when it is hung and not answers, and this >is the only application deployed on the server. >Well, now the fatal question: >Tomcat need any special configuration to use PostgreSQL? >With MySQL the application works normally. > >Team Summary (Virtualized with VMWare): >S.O.: OpenSUSE 12.3 >PostgreSQL 9.2 >Apache Tomcat: 7.0.39 >RAM: 4 GB >Processor: 1 with two (2) cores. > >Any guide / link will help. > >Note: >Sorry for the English, I am using a translator. > >Atte. > >-- >Héctor Del Mestre --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
--------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
