RFC 2 JDBC scenario

[deepak_shah]

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.

[Former Member · Accepted solution]

hi,

[;

the above link wll help you to solve ur query.

Regards.

Siddhesh Naik

[Former Member]

Hi,

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

Regards

Seshagiri

[Former Member]

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.)

[former_member537867]

Hi Deepak,

Plz do refer the following threads:

Regards,

Vinod.

[Former Member]

Hi Deepak,

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

chk this link it will be helpfull

Regards

Sampath