Java and JavaScript in the Database

Hi,

I am looking to explicitly throw the Java session State Cleared exception from pl/sql .Where can i get the exception number ?.

The problem is that after a java program exits unless and until I use addjava or dropjava the program fails to do the activity again.
The program does lot of network read and writes.Even though the socket is closed on both the ends (the client and the server).After, invoking the java stored procedure for the second time it comes out without making a connection.

I observed it is nothing to do with the server.The server to which we connect to is running perfectly fine.the java stored procedure or the ojvm is not releasing the resources or unloading the class files properly.

As soon as you run loadjava or dropjava and then execute the procedure it starts working properly without any code changes.
I can not post the code because it is too huge.

Thanks

Edited by: user605882 on Nov 21, 2008 11:14 AM