anushka pancham

Greenhorn
+ Follow
since Aug 23, 2004
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by anushka pancham

Has anybody used the session parameter,JDBCConnectionTimeoutSecs, for closing the connections after some time? I have tried to use it in weblogic.xml (weblogic 7.0) but it did not work. Can anybody tell me if there is any other option to close the connection after some time, if in any case it cannot close. I am using connection pools.
19 years ago
I posted the stored procedure and the java code used for calling it. PLease let me know if you find something.
Julian,

I do not know what tags you are talking about . I cut pasted the code from toad...
How to set a time out on a connection in the connection pools.
My stored procedure is:




And the way it is called in the Actionseervlet is:



These are the details of the code. I went through the code a lot of times but never found any hole in that.

[edited to add code tags]
[ August 25, 2004: Message edited by: Jeanne Boyarsky ]
J2ee application using struts gets stuck at a stored procedure call and never comes out of it. The connetion is never released to the pool. It takes the system down. I am using a cursor in the stored procedure. Can anybody suggest what could be causing this?