Ted,
Thanks for offering the code. Most appreciated. I would like to try and
convert over to JDBC if possible, and haven't really understood Sun's
Implementation of it. As compared to the ADO.
Michael J. Fuhrman
Reliable Business Computers
http://www.creliable.com
-----Original Message-----
From: Kinsler, Ted [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 27, 1999 8:42 AM
To: 'Michael Fuhrman'
Subject: RE: Java COM Objects for IIS
I have always used the ADO objects directly. I have done this because
when I started using ADO the WFC classes did not exist. There may be a
bug with the WFC, I wouldn't know about that as I choose not to use the
WFC.
If you use the ADO object directly and close all database objects you
use, you should not have any memory leaks.
When you test your code outside of IIS/ASP do you execute the methods
enough times to notice the memory leaks?
You might want to modify your code to use JDBC to see if that eliminates
your problem. This would allow you to possibly isolate the problem to a
more defined domain.
If you want to send me your code I could take a quick peek at it and see
if I notice anything out of the ordinary.
-Ted
P.S. From my experiences I have found that there is not an abundance of
people who understand COM, Java, and the MSJVM Java/COM integration very
well. It can get complex when you get down into the details of what is
going on. Fortunately Microsoft has done a good job with the
integration.
> -----Original Message-----
> From: Michael Fuhrman [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, August 26, 1999 10:29 AM
> To: 'Kinsler, Ted'
> Cc: 'Java JSP'; 'Java ServletExec'; 'Java Discussion'
> Subject: RE: Java COM Objects for IIS
>
> Ted,
>
> Thanks,
>
> OK. I'm using the MS's com.ms.wfc.data. I believe this is ADO, since
> I'm
> constantly loading the MDAC updates (2.5 was the latest right?) on
> both my
> workstation and IIS. And, just downloaded the JVM 3.2 build 3186 from
> Microsoft. (Have yet to test it.)
>
> Concerning the closing of all Connections, Recordsets, objects, and
> other
> pieces .. yes I've double checked that. I'm not using sessions, and
> have
> even attempted to change the cache options on IIS.
>
> uhm .. any other suggestions?
>
> Michael J. Fuhrman
> Reliable Business Computers
> http://www.creliable.com
>
> PS .. there's been lots of interest in creating the COM objects ..
> which
> has been frustrating, since up till you no one seemed to want to ask
> about
> this problem. =)
>
>
>
> -----Original Message-----
> From: Kinsler, Ted [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 26, 1999 10:19 AM
> To: 'Michael Fuhrman'
> Subject: RE: Java COM Objects for IIS
>
>
> How are you accessing the database, ADO, RDO, or JDBC?
>
> This is the simple part, are you closing all of your sql statements,
> result sets and database connections?
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
