Skip to Content

RFC 2 JDBC scenario

Hi,

I am trying a RFC to JDBC scenario wherin i am insertin records into Oracle Database.

I am testing the scenario from XI RWB.

While testing i am getting error that tables doesnot exists.

" JDBC message processing failed; reason Error processing request in sax parser: Error when executing statement for table/stored proc. 'QSTAG_DO_BR' (structure 'Statement'): java.sql.SQLException: ORA-00942: table or view does not exist ".

But i checked it in the database and the tables do exists in the database.

plzz help.

Regards,

Deepak Shah.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 09, 2008 at 04:49 AM

    hi,

    [Sending data from R/3 Table to SQL Server Table;

    the above link wll help you to solve ur query.

    Regards.

    Siddhesh Naik

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 09, 2008 at 04:50 AM

    Hi Deepak,

    chk that u have given the table correct and even for the jdbc connection

    chk this link it will be helpfull

    Calling stored procs in MaxDb using SAP Xi

    Regards

    Sampath

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 09, 2008 at 05:09 AM

    Hi Deepak,

    Plz do refer the following threads:

    Reaciver JDBC Adapter

    SENDER JDBC ADAPTER ERROR

    Regards,

    Vinod.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 09, 2008 at 05:25 AM

    take the insert query from XI payload and put it in database using oracle IDE, with the same user which you give in the XI CC.

    (it might be the case that user dosen't have sufficient rights on that table.)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 09, 2008 at 05:29 AM

    Hi,

    Table name and the field values are Case Sensitive, please check those

    FILE to JDBC Adapter using SAP XI 3.0

    Regards

    Seshagiri

    Add comment
    10|10000 characters needed characters exceeded