Hi people. I using a connection pool in cayenne and have the next error...

  ORA-00020: maximum number of processes...

  Any idea how resolve this problem. Thanks


        Saludos !!
        SALVATIERRA, Mauricio Hugo
        Information Technology 
        Ford Argentina S.C.A.  
        Phono/Fax: 54-11-4756-8750 
        mailto: [EMAIL PROTECTED]
Visit our page: http//www.ford.com.ar/

********************************************************************************************************
STRICTLY CONFIDENTIAL. The contents of this e-mail and any attachments are strictly 
confidential and property of Ford Argentina S.C.A. They may not be used or disclosed 
by someone who is not a named recipient. If you have received this e-mail in error 
please notify the sender by replying to this email inserting the word "Misdirected" as 
the message and delete the present message.
********************************************************************************************************



-----Original Message-----
From: Tony Requist [mailto:[EMAIL PROTECTED]
Sent: Friday, March 26, 2004 14:44
To: Tomcat Users List
Subject: RE: Using PersistentValve for session replication



> I want to store session information in a database to be shared
> between a set
> of servers in a "load balancing without session affinity" configuration.

Lacking input from others, I will answer part of my own question to possibly
help somebody else.

The result is that with a day of work it is possible to use PersistentValve
and PersistentManager to produce "load balancing without session
affinity" -- but you have to overcome some Tomcat issues in the code along
the way.  My assumption is while the code is there, it has not been use
seriously and therefore is not shaken down.

I found and fixed (or worked around) a couple of Tomcat bugs along the way.
If a Tomcat developer is interested in these, I would be glad to give more
details:

* JDBCStore read and writes the database multiple times in load() and
save().  Adding "break;" in a couple strategic places fixes this

* As far as I can tell, the "checkInterval" attribute within
PersistentManager does not work at all

* PersistentValve loads the session for all requests, even static content
(things like *.css, *.js, *.gif).  While this is not wrong, it does not work
well.  I hacked around it, but there could be a clean solution

* Session data is always written out, even when it doesn't change.  I added
a mechanism based on hashCode() to avoid this

* Deserialization errors are not handled correctly

* I could not get the logging to work so I added my own (this might just be
my problem)

- tony



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to