Hello
Im working with jdbc on a MSSQL Database.

In my java client im executing a stored procedure called myProc on the
database.
Im doing this with the following code:

.....
Statement stmt = con.createStatement();
String sql1 ="execute myProc";
stmt.execute(sql1);

My problem is, that this stored procedure takes at least one hour to
finish. So i cant close the java client during this time, otherwise the
stored procedure will be canceled. I can call it in a seperate thread,
but that doesnt help. Nevertheless the client cant be closed.

Is there a possibility to call a stored procedure on the MSSQL DB
without java to wait for a return value?

Thanks in advance
G. Agu