Stored Procedures with java

[Albert]

I must do an application J2EE to execute stored procedures, that is a hugh problem, because I really know how can I do that, but my question is the following one:

There are stored procedures that delay long time in finishing processing, for example 5 minutes (I have one delays 20 hours), time in which my application could fall by timeout.
The call to the procedure I am doing it within bean, my question is if somebody knows some form to cause that the application leaves to bean running the procedure, while I show a "in progress" screen so that once it finishes the application shows a final window with the summary of the process.
It was thinking to use threads.

Some suggestion?

Albert

[Felissa]

My suggestion goes by the side of the data base. If this to your reach to modify the stored procedure, or the design of the data base,
(I either do not have idea of the logical design of the data base ) but first I suggest to you you could not be denormalize the data base with the purpose of improving the times of the consultation.

Perhaps you should have tables with some totals already calculated. You could update the tables “automatically” with triggers on the INSERT/DELETE/UPDATE the present tables of querys. This is going to make a little bit slower the update of the tables, but you can improve the times of the consultations.

Which is your motor of data base?

Felissa

[Albert]

I am working with oracle 10g, now the subject of procedures, lamentably are one that I cannot touch and that are delayed enough, in average one hour, and is executed weekly.

Albert

[Eric]

If you have access to the data base, you can denormalize the design of the logical structure of the data base.

if the Stored Procedures runs weekly, I suppose that it is batch… isn't it?
You could leave the results in temporary tables, and what it is consulted they are these temporary tables, that become to be above every week.
The bad thing of this you have the information one week late; although depending on the necessities of the logic of the business, could be acceptable.
Greetings,

Eric

[Albert]

Thanks to all, I comment as I solved my problem in case somebody needs help:

finally I create a model in the data base where I save my process that desire to execute from the application WEB,

and a program in java that is called from a shell through crontab that executes these processes, thus can be running in the server

To know how it goes the progress of the single procedure I consult the state of the scheduler table,

which is by_toexecute, inexecution, executedOk and executedwitherror.

Albert