SQL & PL/SQL

Hi All,

I have my front end in Java and back-end in oracle, i am using set_context for storing all the front values and sys_context for fetching those values for processing. As the context is session specific it is working fine for a db session.

But the problem is, the Java layer is not maintaining a connection they are(java team) just establishing a connection whenever needed and after getting the back-end data they are terminating the connection. So in this case i am loosing all my context values from back-end.

Is there any way so that i can identify the application session and retain my values until the application session expires, rather than retaining them for only a db session.


Thanks All.