java.sql.SQLException: ORA-00020: maximum number of processes (100) exceeded

sumithradevi_at_hotmail.com
Date: 10/30/03 

Date: 29 Oct 2003 19:03:00 -0800

Hello Friends,

I am getting the following error.
java.sql.SQLException: ORA-00020: maximum number of processes (100)
exceeded

I am closing all my resultsets and all my connections in the try
block.
should i close ResultSets and Connections in the catch block aswell?.

or the problem is due to the connection pool settings in weblogic or
on the oracle side instead of in my application.

Thanks in Advance
s

Relevant Pages

  • Re: Long running open connections badly leak memory
    ... Alin Sinpalean schrieb: Joerg von Frantzius wrote: ... When I close the connections, memory is reclaimed properly. ... What I meant to say is "are you sure you are explicitly closing ALL Statements and ResultSets when you're done with them?". ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: java.sql.SQLException: ORA-00020: maximum number of processes (100) exceeded
    ... | I am closing all my resultsets and all my connections in the try ... | should i close ResultSets and Connections in the catch block aswell?. ...
    (comp.lang.java)
  • Re: Too Many Processes?
    ... > uses stored procedures extensively to access the data. ... I've been closing my connections after executing any data ... As long as you are correctly closing AND disposing of your objects when ...
    (microsoft.public.sqlserver.programming)
  • Re: How to gracefully (programmatically) kill an app?
    ... | closing the console window. ... want the server application to stop accepting connections. ... that server file maintenance can be done with the first event and a full ... In dictatorships, you need courage to fight evil; ...
    (microsoft.public.vc.mfc)
  • rblsmtpd/qmail-smtpd hung processes
    ... After a while the server just quits accepting smtp connections, or will connect/disconnect very quickly. ... Since I'm not seeing any log activity that shows what's going on, I'm having a hard time figuring it out. ... Our email/dns provider is closing up shop in about a week. ... I only had about 3 weeks notice on this and I've been configuring a pair of FreeBSD machines to take over DNS and E-Mail for about a dozen sites. ...
    (freebsd-questions)