tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matt Fisher" <>
Subject Re: Tomcat 3.2.2 crashes with JDBC
Date Fri, 28 Sep 2001 01:47:34 GMT
I take that back. Maybe I am seeing bugs in J-Netdirect's JDBC drivers.

The OutOfMemory errors occur most often in connection with classes in the
JSQLConnect package, e.g.:

  Root cause:
     at com.jnetdirect.jsql.t.a(Unknown Source)

But sometimes they occur in connection with other things, e.g.:

  Root cause:
     at java.lang.StringBuffer.append(Unknown Source)
     at sqlUtilities.makeXMLFromCurrentRow(, Compiled Code)

The latter method, makeXMLFromCurrentRow(), is one of our custom methods.

Incidentally, it did not help to stop Tomcat, increase the memory allocation by
setting the TOMCAT_OPTS environment variable, and restart Tomcat. We gave it 512
megs, of which only a small fraction seemed to be used. The performance meter
showed only a slight increase in memory use during stress testing.

Seems like some compartment within that 512 megs is being set to a ridiculously
low default. I wonder what that might be....

I'll contact J-Netdirect, but if anyone can think of another angle to try, I'd
appreciate your advice. The setup again is Tomcat 3.2.1, Apache 1.3.20, Windows
2000 Server, SQL Server 2000 database, JSQLConnect and JSQLOptionalAPI.

 - Matt
----- Original Message -----
From: "Matt Fisher" <>
To: <>
Sent: Thursday, September 27, 2001 12:51 PM
Subject: Re: Tomcat 3.2.2 crashes with JDBC

> Pransanth wrote:
> <<So can you help me with where I can find the right driver . Also, could you
> suggest the best driver i could use for MS SQL 2000. I will shortly be
> to SQL 2000 from MS access.>>
> If you can afford a commercial JDBC driver, see:
> There are no doubt other vendors of quality drivers. However, J-Netdirect's
> JSQLConnect and JDBCOptionalAPI are the only ones I have used. These jar files
> work well with Tomcat 3.2 and SQL Server 2000. I have not encountered any
>  - Matt Fisher

View raw message