Home » RDBMS Server » Server Administration » ORA-00020 exception...urgent
ORA-00020 exception...urgent [message #373966] Fri, 18 May 2001 04:52 Go to next message
Harika
Messages: 6
Registered: May 2001
Junior Member
hi everyone
when i am trying to call a stored procedure from
java i am getting the following error
can any one help

Exception :ORA-00020: maximum number of processes (250) exceeded

thanx
Re: ORA-00020 exception...urgent [message #373979 is a reply to message #373966] Fri, 18 May 2001 06:08 Go to previous messageGo to next message
Anil Thomas
Messages: 1
Registered: May 2001
Junior Member
Hi,

Check your java coding. Ensure that each database
you make through java gets closed once your
transaction is over.
Often programmers tend to overlook this. Your application keeps on making database calls and each call will open a connection. At one point of time the number of connections would exceed the database limit. So re-code and ensure your connection to the database has been closed.
Hope it helps !

Regards
Anil
Re: ORA-00020 exception...urgent [message #373991 is a reply to message #373966] Fri, 18 May 2001 08:51 Go to previous messageGo to next message
Harika
Messages: 6
Registered: May 2001
Junior Member
Hi Anil,
thanx
what u have said sounds reasonable
but i have closed the connection

Regards
harika
Re: ORA-00020 exception...urgent [message #373992 is a reply to message #373966] Fri, 18 May 2001 08:53 Go to previous message
Harika
Messages: 6
Registered: May 2001
Junior Member
Hi Anil,
thanx
what u have said sounds reasonable
but i have closed the connection

Regards
harika
Previous Topic: SYSOPER/SYSDBA
Next Topic: sql query
Goto Forum:
  


Current Time: Mon Dec 23 10:35:45 CST 2024