Skip to Content
avatar image
Former Member

JDBC adapter with multiple table

Hello Experts,

I whant to practise FILE TO JDBC or SOAP TO JDBC scenario ( simple ) that uses multiple database tables. I have seen posts related to this requirement but i am not able to get the complete idea to execute the scenario.

If it uses stored procedure please give me idea regarding stored procedures. If there are any blogs related to this pelase post the links.

and please give me step by step guide to execute the scenario.

Thanks in advance.

arjun

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 10, 2009 at 08:13 PM

    Use this..

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

    Regards,

    Sunil.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 11, 2009 at 07:15 AM

    Hi

    Just create a structure conatining fields to be inserted to DB_Name1 / DB_Name2

    below is for oracle.

    CREATE OR REPLACE PROCEDURE Storeprocedurename
    (
    filed1 CHAR,
    filed2  CHAR,
    filed3  CHAR,
    filed4  CHAR,
    filed5  CHAR
    )
    IS
    BEGIN
    
    INSERT DB_Table1 ;
    
    
    INSERT DB_Table2 ;
      
    
    COMMIT;
    END StoreProcedurename;
    /

    rgds

    srini

    Add comment
    10|10000 characters needed characters exceeded