Making a little java server under oracle

Hi

Im hoping someone can help me with a project that im doing at university. I'm investigating the possibility of having a simple server application written in java that runs in oracle in the usual way (loaded with loadjava)

I have made a little server before, but that used threads. It was of the form:

public class ServerEngine{
// For each request make a new connectionHandler
}

public class ConnectionHandler{
// Handle request then die
}

I got this to work under oracle briefly but then I cant use SQLPlus+ after running it. I'm guessing this is because I used threads which I think oracle doesnt like. My question is then, if oracle doesnt like threads, how can i get the job done?

One thing that works in my favour is that there is only one client. The server tells the client when things of interest have occured. But what I'm worried about is the implementation that I make, hogging resources of making SQLPlus die on me. Is there anyway I can get the server application to run in the background so that I can just forget about it?

Can someone share their wisdom with me: ) Thanks

Kind Regards

Simon Received on Fri Nov 29 2002 - 07:28:39 CST