tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jonathan Mast <>
Subject Re: PostgreSQL vs MySQL with Tomcat
Date Thu, 15 Jan 2009 22:50:21 GMT
Our organization has products backed by both databases and we are almost
entirely shielded from the database details in Tomcat.  I don't really see
how it should matter in terms of Tomcat (or any Web container).  I'm
thinking this is more a Java issue than a Tomcat issue.

The main differences we've encountered is that the MySQL implementation of
JDBC requires some extra parameters to be passed along when connections are
made, otherwise the ResultSet will fail on particular conditions.  But this
is an database layer issue, and the db layer exists independently of the web

Our observation of the MySQL vs Postgre debate is this: (btw we use versions
5.0 and 8.1 respectively)
* Postgre has more features (sequences and triggers) but also an enormous
amount of complexity
* MySQL has much finer authorization control, but lacks some of the big-boy
features such as triggers
** of course a lot has changed in the newer versions of both of these DBMS

On Thu, Jan 15, 2009 at 5:20 PM, Ken Bowen <> wrote:

> Hi all (especially Chris -- very informative long post today on
> Tomcat/MySQL):
> For a several reasons (including the apparent infinite default for
> connection timeout), I'm contemplating switching one or two projects from
> MySQL to PostgreSQL.  I'd like to gather opinions on the tradeoffs,
> including:
> Unfortunately, MySQL isn't really that tunable. On the other hand, MySQL
> requires very little in the way of tuning!
> I created a couple of proof-of-concept projects with PostgreSQL for someone
> about six months ago, and the only really puzzling thing what how to set up
> "sequences" corresponding to MySQL's AUTOINCREMENT (I'm not sure I've really
> wrapped head around it completely anyway).  For those small projects, it
> worked well, but there was no stress involved.
> I'd like to hear about people's experiences and what they think are the
> strengths and weaknesses of each DBMS for use behind Tomcat.
> Thanks much in advance,
> Ken Bowen
> ---------------------------------------------------------------------
> To unsubscribe, e-mail:
> For additional commands, e-mail:

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message