my dog learned polymorphism*
The moose likes JDBC 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
Bookmark "SQLException: 1) Descriptor 2) Processes" Watch "SQLException: 1) Descriptor 2) Processes" New topic
Author

SQLException: 1) Descriptor 2) Processes

Shrihari Kulkarni
Greenhorn

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

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

Exceptions:
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: 1135

Shrihari,
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:
http://tahiti.oracle.com
Hope this helps.
Good Luck,
Avi.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQLException: 1) Descriptor 2) Processes