View RSS Feed

My Java Tips

  1. Calling stored procedures

    by , 11-12-2011 at 06:21 PM (My Java Tips)
    Stored procedures contain set of SQL statements and are stored on the database server. Their query execution plan is already define, so they run faster and improve the performance. In this post, I will talk about how to call stored procedures.


    An object of CallebleStatement (extends PrepareStatement) is used to execute store procedures. PrepareCall() method is use to create CallebleStatementís object.

    Java Code:
    CallebleStatement cst;
    Cst = conn.prepareCall(ď{call
    ...