Re: Maintaing single db connection over multiple rpc calls

Josh Walker <[email protected]>
Newsgroups gmane.comp.windows.devel.soap.general
Message-ID <SOAP%[email protected]>
On Mon, 26 Aug 2002 04:55:04 -0700, Rafi MM <[email protected]> wrote:

>Hello
>   I tried to use Apache SOAP rpc call to access the classes(running in a
>remote server)
>which in turn connect to the database and perform the database operations.I
>deployed the service in a Apache TomCat Server while making the scope
>as  "Session".. It was required to maintain a single database connection
>for different method invocations for a particular session..The client
>classes were running in my machine. When testing the thing inside a local
>network,it worked smoothly without any problems and I could maintain a
>single database connection variable over different method invocations for a
>single session.. But when I run the server in a very remote machine, for
>each rpc method call, the constructor of the server class(which is the
>deployed service) is called and a new databse connection is made for the
>session..Thus for each method call within one single session, a new
>database connection is used...I don't know why it happens..Is it due to
>session timeout?
>I would be great if anyone you can  provide a solution to the problem..

Hi Rafi.  I'm sorry I don't have a good answer for your question.  If the
only difference is local vs remote, could there be some kind of timeout
involved?

[disclaimer: I work for the company whose product is described below]
You might also be interested in the SOAP+ Toolkit from Chutney Technologies.
 This is an Apache SOAP compatible implementation that caches responses (in
addition to some other features).  If your application issues a SOAP request
with the same parameters multiple times, you may be able to get a
performance benefit from caching.  I believe there is a free evaluation
version available on component source (http://www.componentsource.com/); try
doing a search for "Chutney".

Good luck solving your problem.

Josh Walker

You can read messages from the SOAP archive, unsubscribe from SOAP, or subscribe to other
DevelopMentor lists at http://discuss.develop.com.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.