Jason,
Actually this may work well, if not solve my issues .. if it's working for
you. One request, could you send a small sample piece of code that connects
to your database through the method you've chosen to use? It would be most
helpful in speeding the massages I would need to make in adjusting the code
for this correct.
The issue I'm having .. too reiterate
The program that I have written works correctly except for one thing ... IIS
leaks memory. Or the garbage collection is not working correctly between
IIS's ASP or Java. I'm not sure. But what I have determined is that it
only does this when a Database is involved.
In the test environment, where it is completely JAVA, using a JVM to execute
a class with a main, to manipulate the Java Class and Database .. there is
no memory lost. When an ASP page calls the Java Class repeatedly it chews
up memory, eventually causing all the database connections to be filled up,
and page responses to go unanswered.
Michael J. Fuhrman
Reliable Business Computers
http://www.creliable.com
-----Original Message-----
From: Jason Lee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 26, 1999 11:37 AM
To: Michael Fuhrman
Subject: Re: Java COM Objects for IIS
Mike,
I know I'm coming into this conversation kinda halfway and not knowing the
whole
issue, but maybe I can offer some insight.
First off, I'm not sure what problem you're having since I haven't seen the
original post. However, I have built a 'hybrid' site using IIS and the MS VM
with tons of Java classes.
At first, I was registering *a lot* of the classes as COM objects which
turned
into a nightmare. I was working with a guy that suggested I present some
sort of
'class interface' for IIS/ASP that then called my classes. So this allowed
me
one COM registration.
I'm using the latest MDAC components and also the com.ms.jdbc.odbc driver
into
our SQL 7 server and it works well. All my db calls are done in Java and
then I
just provide objects for my ASP pages to call (usually strings and ints) and
that way I've cut out ADO - especially since I'm not too fond of ADO anyway.
Like I said, the above might be of no interest to you, but I thougth I'd say
something. There have been a many things I've had to really dig for to get
the
MS VM to work with IIS - it seems that since Java is a competing technology
with
COM, MS doesn't wanna say you can use it with ASP/IIS. But I prefer Java
since I
can port it easily - and actually all dragging all the backend code over to
BEA
Weblogic server and just translating the ASP into JSP (with a few minor
tweaks).
Well, anyway, if there's anything I can offer help on let me know.
Jason
> 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?
>
--------------------------------------
Jason Lee
Lead Developer of E-Commerce Solutions
BioSpace.com, Inc.
594 Howard Street, Suite 400
San Francisco, CA 94105
[p] 415.977.1600
[f]
415.977-1606
---------------------------------------------
This message was sent using Endymion MailMan.
http://www.endymion.com/products/mailman/
===========================================================================
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
