tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kotsiras, Alexandros" <>
Subject RE: IIS redirect
Date Fri, 28 Jul 2000 22:55:02 GMT
I guess that with SQLServer things are easier because there are many
third-party drivers on the market. 
The best place to start with is the JDBC Drivers list page at the Sun
website :
Just select SQLServer and i am sure you 'll get plenty....  
FreeTds is popular  and free if i remember well. 
I always prefer Type 4 (pure Java) but  if  you can't find Type 4 go fot
Type 2. 
In any case AVOID the Sun JDBC-ODBC bridge.
-----Original Message-----
From: Andy Barker []
Sent: Friday, July 28, 2000 5:17 PM
To: ''
Subject: RE: IIS redirect

Where would I find this driver?  Can I use it to talk to MS SQL Server 7.0?
-----Original Message-----
From: Kotsiras, Alexandros []
Sent: Friday, July 28, 2000 3:52 PM
To: ''
Subject: RE: IIS redirect
I was having exactly the same memory usage problems with a DBservlet that
queries an Access Database via JDBC-ODBC bridge. 
For every reload of the DbResults page i would see the memory usage of
java.exe on the WinNT Task manager go up by 1MB !!
It wouldn't take more than 15-20 requests to crash the server. 
I found that the reason was the Sun JDBC-ODBC bridge. I tried exactly the
same Java source code with an identical set of tables in an Oracle Database
and the thin driver ( and everything was fine. 
So i am currently using the infozoom Access driver without any memory
It's a type 2 JDBC driver and does not require an ODBC DSN. 
-----Original Message----- 
From: Andy Barker [ <> ] 
Sent: Friday, July 28, 2000 11:13 AM 
To: '' 
Subject: IIS redirect 
I had problems getting this to work yesterday, but I found the problem.  I 
was having problems with the file, and then I realized the

file had some garbage characters in it.  Once I cleaned up the file 
everything started working. 
I was then able to follow the inprocess-howto instructions to get the JVM 
loaded inproc with IIS.  I am a little concerned now about memory usage.  I 
setup a simple servlet that queries my database.  I then did a test where I 
ran the servlet multiple times while I watched the memory usage.  The usage 
went up by at least a MEG every time I hit refresh on the browser, which 
then invoked the servlet.  The memory usage continued to climb until it got 
to around 45 MEG at which point it seemed to level off.  Will the JVM 
eventually reclaim this memory?  Is this normal, or should I be concerned? 
Andy Barker 

View raw message