tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: [OT] Tomcat and PostgreeSQL
Date Fri, 07 Jun 2013 14:00:03 GMT
-----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:hectordelmestre@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-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message