CrazyEngineers
  • how to call a three procedures in a single statement?

    kunaljd

    Member

    Updated: Oct 22, 2024
    Views: 1.9K
    I am currently facing this problem. i have to write a single callable statement that will call three procedures and calling second procedure from first procedure is not a option . please help.
    0
    Replies
Howdy guest!
Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.
Replies
  • Manish Goyal

    MemberDec 27, 2010

    can you please explain with an example so that we can have more better idea?
    Are you sure? This action cannot be undone.
    Cancel
  • kunaljd

    MemberDec 27, 2010

    hello goyal,
    CallableStatement cs2 = con.prepareCall("{call ADDITION(?,?,?)}");
    cs2.registerOutParameter(3,java.sql.Types.INTEGER);
    cs2.setInt(1,10);
    cs2.setInt(2,25);
    cs2.execute();
    this is how we call a procedure of database using java.
    in above statement only one procedure is called . but i have to call three procedure at same time.
    Are you sure? This action cannot be undone.
    Cancel
  • Sachin Jain

    MemberDec 27, 2010

    kunaljd
    hello goyal,
    CallableStatement cs2 = con.prepareCall("{call ADDITION(?,?,?)}");
    cs2.registerOutParameter(3,java.sql.Types.INTEGER);
    cs2.setInt(1,10);
    cs2.setInt(2,25);
    cs2.execute();
    this is how we call a procedure of database using java.
    in above statement only one procedure is called . but i have to call three procedure at same time.
    You want to call these procedures using one statement still their execution will be sequential as i think.
    So you can make another procedure which calls the three required procedures.
    And then call the new procedure.
    It think it may work....
    Are you sure? This action cannot be undone.
    Cancel
  • Manish Goyal

    MemberDec 28, 2010

    I think you can do so by using concept of Multi-threading in java
    Are you sure? This action cannot be undone.
    Cancel
  • kunaljd

    MemberDec 29, 2010

    Re: how to call three procedures in a single statement?

    hi goyal,

    do you know how to use multithreading to call three procedures?
    if yes then please share your your knowlege.
    Are you sure? This action cannot be undone.
    Cancel
Home Channels Search Login Register