tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: Tomcat 4.x (Major Problem)
Date Fri, 19 Jan 2007 18:38:51 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Andy,

Andy Moller wrote:
> While debugging the database query logs, the reason was that the
> field type is integer, while the passed value was a "string", we went
> and inspected the code design and semantics and it was an impossible
> case that the used "Variable" could have been used in that SQL query.

How are you interacting with your database? Are you using JDBC? If so,
exactly how do you build the query? Are you concatenating strings to
form a single, String-based query, or are you using PreparedStatement
and then filling-in the parameterized values?

> For some reason, at the runtime, a variable reference was switched in
> the JVM, which suggests a memory leak and a HUGE problem with that
> version of Tomcat, and that also confirmed to a certain extent the
> discrepancy problem that occurs with a high volume of user sessions
> in the recent application.

If the JVM really is the culprit, then Tomcat can't do anything about
that. What version of Java are you using? I find it very unlikely that
you have a JVM problem. It is also unlikely that Tomcat is interfering
with your servlet->database communication or somehow breaking your SQL
queries.

Can you post a code snippet? For instance, if you could post some of the
code involved in creating and issuing he SQL query, that might help.

> I would appreciate it if someone confirms that suspicion, and whether
> Tomcat is a reliable server for a high demanding application.

Tomcat is unquestionably reliable for high demand applications. How much
demand are you talking about? Some notions of high demans are higher
than others...

I would imagine that an upgrade to a more modern version of Tomcat would
be a good idea in general, but certainly not a requirement for moving
forward.

- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFFsRA79CaO5/Lv0PARAku1AJ0Svq9Cz1u2x3TOGaOlcQtq8IW37ACbBTA8
QDKxfNhI7amP7nTcMTOUrXw=
=fu3A
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message