File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes SQLException: 1) Descriptor 2) Processes Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQLException: 1) Descriptor 2) Processes" Watch "SQLException: 1) Descriptor 2) Processes" New topic

SQLException: 1) Descriptor 2) Processes

Shrihari Kulkarni

Joined: Feb 05, 2003
Posts: 1
I'm getting following exceptions in JFrame based database application. Why are they?

Operating System: Windows NT Server.
Database: Oracle8i on (Windows 2000 Server)
Driver: Thin driver of

1) java.sql.SQLException: Io exception: Descriptor not a socket: socket write error (While closing statement/resultset)
2) java.sql.SQLException: ORA-00020: maximum number of processes (59) exceeded (This exception is coming randomly i.e. not at perticular stage, not after perticular code's execution. But in one execution of the programme, it comes at least once and database connection gets lost.)
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1141

Your first exception is probably due to your code. Don't show no code and exception stack trace, don't get no more help from me.
Your second exception is due to the configuration of your Oracle database (and probably also partly due to your code). You can alleviate this problem by modifying the Oracle configuration files. Please read the Oracle documentation for more details. All of the Oracle documentation is available from:
Hope this helps.
Good Luck,
I agree. Here's the link:
subject: SQLException: 1) Descriptor 2) Processes
It's not a secret anymore!