on 03-27-2012 11:14 AM
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!
<table>OWNER.DBTABLE</table>
>>
what is the actual Table name? Provide that here.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
you can check for credentials that have access for particular table which you specified in Receiver CC
Regards
Gagandeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi G Koopmann,
please kindly check these
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The structure you have defined was correct, please check the table and table name correct or not.
Regards,
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.