JDBC Receiver SELECT

[Former Member]

Hi,

I am working on a scenario where I need to perform a SELECT via JDBC receiver adapter. I have created my message like example shown for SELECT:

http://help.sap.com/saphelp_nw70/helpdata/EN/2e/96fd3f2d14e869e10000000a155106/content.htm

<?xml version="1.0" encoding="UTF-8"?>

<ns1:GET_Locatie xmlns:ns1="http://test.com/gk">
  <Statement>
    <dbTableName action="SELECT">
    <table>OWNER.DBTABLE</table>
    <access>
      <NUMMER></NUMMER>
    </access>
    <key1>
      <POSTCODE>4871 VM</POSTCODE>
      <HUISNUMMER>33</HUISNUMMER>
     </key1>
    </dbTableName>
  </Statement>
</ns1:GET_Locatie>

I checked the database name and this looks correct. Still I am getting an error: java.sql.SQLException: ORA-00942: table or view does not exist

Can there something else be wrong?

Is there perhaps a good blog which covers all?

Thanks for the help!

[Shabarish_Nair · Accepted solution]

<table>OWNER.DBTABLE</table>

>>

what is the actual Table name? Provide that here.

[gagandeep_batra]

Hi

you can check for credentials that have access for particular table which you specified in Receiver CC

Regards

Gagandeep

[anupam_ghosh2]

Hi G Koopmann,

   please kindly check these

• the spelling of the table name. 
• that a view is not specified where a table name is required. 
• that an view exists with same name as that of table.

Pls Contact the database administrator since application privileges are required to access the table.

Also, if attempting to access a table in another schema, make certain that the correct schema is referenced and that access to the object is granted.

Regards

Anupam

[baskar_gopalakrishnan2]

Database name contains multiple table names. This is similar to package and classes convention in a programming language. You need to reference table name through database name

Ex: Database name is Owner

Table name : table_name

Then  fully qualified table name is  Owner.table_name

[Former Member]

pls check the fully qualified name for the database table. put the complete tablename with database name and owner information (if there is) separated by dots or periods.

[former_member184681]

Hi,

You can find some neat examples below:

http://www.riyaz.net/sap/jdbc-adapter-configuration/1200/

And a more detailed one, but related to receiver stored procedure:

http://sapxitutorials.blogspot.com/2009/03/synchronous-soap-to-jdbc-end-to-end.html

Hope this helps,
Greg

[rajasekhar_reddy14]

   Hi,

      The structure you have defined was correct, please check the table and table name correct or not.

Regards,

Raj