wood burning stoves 2.0*
The moose likes EJB and other Java EE Technologies and the fly likes call to procedure stops java application till procedure gets executed. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "call to procedure stops java application till procedure gets executed." Watch "call to procedure stops java application till procedure gets executed." New topic
Author

call to procedure stops java application till procedure gets executed.

Pratibha Malhotra
Ranch Hand

Joined: Dec 21, 2003
Posts: 199
Hi,

I have a requirement to execute a procedure from a java application.
This procedure would take 20-30 minutes to execute. My application will stops till my procedure gets executed.

I don't my application to wait for my procedure to cpomplete its execution.

Is there any way/logic using which I can make this happen.
I don't want to use threads for the above mentioned.


~ Pratibha Malhotra<br /> <br />Sun Certified Java Programmer<br />SCEA 1.4 (In Progress)<br />~~~~~~~~~~~~~~~~~~~~~~~~~~~<br />"Many of life's failures are people who did not realize how close they were to success when they gave up!!"
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

You could make it asynchronous via JMS. That is if your business needs can handle it. That being said, unless your procudure is doing admin-type tasks (archiving a bunch of data, report building etc. ) then I reckon it might be doing more then it should - since 20-30 mins. is an awful long time for a procedure to run.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Kishore Nair
Greenhorn

Joined: Nov 30, 2004
Posts: 10
You can also do an Observer/Observable model with your stored proc call in a separate thread which is an observable and the main app as an observer. When the proc is complete, you can use "notify" to tell the Observer that the thread is done.


Never resign to your fate
Kishore Nair
Greenhorn

Joined: Nov 30, 2004
Posts: 10
Oops didn't see the "I don't want to use threads" part.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29287
    
140

Moving to EJB and Other J2EE Technologies since this is not specific to JDBC


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: call to procedure stops java application till procedure gets executed.
 
Similar Threads
SQL LOCK
Servlet release database Connection
Reduce oracle SELECT query Response Time
call to procedure stops java application till procedure gets executed.
Can I use Pure JSP Code without any java beans for a web application