Skip to Content
avatar image
Former Member

Can JDBC adapter be scheduled to call stored procedures

Can JDBC adapter be scheduled to call stored procedure in other database passing previous date as input parameter

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    May 16, 2007 at 05:24 AM

    Hi

    /people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

    Check the above mentione blog

    Regards

    krishna

    Note:reward points if useful

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 16, 2007 at 05:18 AM

    hello,

    Can u plz elaborate u r requirement?

    Add comment
    10|10000 characters needed characters exceeded

  • May 16, 2007 at 05:25 AM

    Yes you can call Stored Procedures using the JDBC receiver adapter.

    Regards

    Bhavesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Gurus,

      actually our scenario is jdbc->XI( <-RFC->)->File

      Here our payload is around 5000 records

      can it be advisable to use rfc synchronous communication.

      The scenario will be exected only in night times.so can we schedule the adapter as we are using sp9.

      If not what must be the good design approach.

      And also after scheduling to a perticular period ,if there is any down time of XI server,will the process start immediately after the sever up or it will again watch for that perticular time.

  • avatar image
    Former Member
    May 08, 2009 at 11:00 AM

    ok

    Add comment
    10|10000 characters needed characters exceeded