How I can call Stored Procedure asynchronously from java function

[Bikash Paul]

Hi,
I want to call one Stored Procedure from java function asynchronously that means my function should not wait whether that Stored Procedure executed or not.It should simply call that Stored Procedure and it should not wait for execution.Can any one please guide me how i can do that.
Below r my codes :-

public void callStoredProcedure(String sp_name) throws Exception
{
Connection conn = null ;
CallableStatement cstmt= null ; 
try
{ 
conn = connect("Pdr"); 
String query = "{ call "+ sp_name+"(?) }";
cstmt = conn.prepareCall(query);
cstmt.setString(1,"PDR_USER");
cstmt.execute(); 
}
catch(Exception e)
{
System.out.println("Exception at dBOperation bean at callStoredProcedure()***"+e.getMessage()); 
e.printStackTrace(System.out);
}
finally
{
if(cstmt != null)
cstmt.close();
if(conn != null)
close(conn);
} 
} 

Thanks & Regards
Bikash
[ February 09, 2004: Message edited by: Bikash Paul ]

[Ernest Friedman-Hill]

Moving to JDBC.

[john guthrie]

i think jdbc calls are all blocking. given that, you can start up a "throwaway" thread to do the call, then have your main thread start up the throwaway and carry on. the extra thread just exits when the stored procedure call returns

[Bikash Paul]

Hi,
Can u give me some idea how i can use throwaway thread in my function.
Thanks & Regards
Bikash

[john guthrie]

sorry, i meant that you just create a thread to do the SP call, then exit. just a regular java thread, pooled or otherwise.

[Mani Narayanan]

Jus try out this code
//this call is the thread class where one will execute the store procedure
class DBProcess implements Runnable
{
private String sp_name;
DBProcess(String sp_name)
{
this.sp_name = sp_name
}

public void run() throws Exception
{
Connection conn = null;
CallableStatement cstmt= null;
try
{
conn = connect("Pdr");
String query = "{ call "+ sp_name+"(?) }";
cstmt = conn.prepareCall(query);
cstmt.setString(1,"PDR_USER");
cstmt.execute();
}
finally
{
if(cstmt != null)
cstmt.close();
if(conn != null)
close(conn);
}
}
}
the following is the calling class
class RunDB
{

public static void main (String[] args)
{
if (args.length > 0)
{
DBProcess db = new DBProcess (args[0]);
try
{
new Thread(db).start();
}
catch (IllegalThreadStateException e)
{
//add code
}
catch (Exception e)
{
//add code
}
}
}
}