-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Chuck,
[Marking OT as this is not Tomcat-related] On 6/6/13 5:13 PM, Caldarale, Charles R wrote: >> From: Hector Del Mestre [mailto:hectordelmes...@gmail.com] >> Subject: Tomcat and PostgreeSQL > >> 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. > > You'll need to examine the heap and try to determine what the > objects are that are consuming so much space. The jhat tool that > comes with a Sun/Oracle JDK is useful for this: > http://docs.oracle.com/javase/6/docs/technotes/tools/share/jhat.html > > There are also numerous profilers that will help with heap > analysis; YourKit is a favorite, but it's not free. Google will > help you find the free ones besides jhat. > >> Tomcat need any special configuration to use PostgreSQL? > > It shouldn't. Other than changing the JDBC URL, everything else should be the same in terms of configuration /for Tomcat/. Note that your application may have to change if there are any MySQL-specific queries that have been written (e.g. INSERT DELAYED, INSERT ... SELECT, or other MySQL-only queries). If AppFuse says it works with MySQL *or* PostgreSQL, then you may have to set a configuration switch in AppFuse telling it you are now using PostgreSQL. - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.17 (Darwin) Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBCAAGBQJRsediAAoJEBzwKT+lPKRY4zwQALmoQ4kMKax3kkrg6mT7WT3o b/Ty3InVNF03u6ENUNuj6aLZAj7eEurzyE55bhNd6GMDSoqNEPwEosqHhvV6hFgx SVSjWfHh4Ut9woY/V2WDQj00w2HsZ/oLdlTSMakHwqzMkH6m2pbdEXKTNRuuBf9w MoFLo381IqJiOFRisf1LX1R5CzmmWYRpehmF/Gd+OEN7z95CRN+Cei2Grp22oz3r vn2cV6OCpy2UyiUxPa8dJATx6RHZHRGBns3PI2aP6ZxwU4hUqZISsoyiw6V+mDT3 fwsorHfG1kJMUjoH4FKKQqb5hVby+wwTFvu+3KhBNOuyp6hLv71zE3wnYxBnCyFh hewpqFXOWPWgGp3nUDiXN9oLney5HgrUz0jP0nJTJFicGeCEpywjj0Vmd9PfCGCw z1yGzzmjpYeRn5mT48IpSmy2CzOfyb9kLvjfO2gF0rlAWbnAaoufqGiE7wPjJCCG WE+qgtnz3zj6/NmQWxmMWTajV9//QngyHj8rJqZof1hoABHQimoy27K7ro7h2C9x qmxPwul1ZJy64izy5BHbHEh/CGoxkg1Rnsru6Dq1WzxFtJcERJRpICVvQ8zcR5up v7VUE1nCXEoNkFaw7TjZdbxlDdSuk4l7LFhWD9eJ2WrC5+BfC0EcRiiuhLtQ9qz0 TVElEfLZcbhCw0IdzaTD =B6TV -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
