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]