on 06-29-2010 1:13 PM
Hi,
in the scnario soap to jdbc i am selecting records from oracle database from the soap request and response as to be sent back to soap.
here i am getting this error as
com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'table' (structure 'Statement'): java.sql.SQLException: FATAL ERROR document format: structure 'Statement', key element 'DATA_COMPLETE' contains no values
even i have checked the blog /people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step
kindly suggest
Regards
Vijay
it is syaing that the query what you have formed and structure seems to be not correct.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi all,
Thanks a lot and now the above issue got resolved as there was a small mistake in structure .
now new issue as come up saying that
java.sql.SQLException: ORA-00936: missing expression
for this i noticed that there are no columns in the statement...
now to mapp this column names in request as i get only one field as input so that i can only htat filed ..
Regards
Vijay
for this i noticed that there are no columns in the statement...
now to mapp this column names in request as i get only one field as input so that i can only htat filed ..
Map that field itself to the target structure.....the values in the column wont be populated automatically.
If the one source field contains concatenated value then using substring populate target columns accordingly.
Regards,
Abhishek.
key element 'DATA_COMPLETE' contains no values
Have you ensured that key element is not blank?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
the field data_complete doesnt seem to have any values.
first cehck if the mapping is correct and proper data is being populated in the structure.
Also check if the structure is defined as per the below link - http://help.sap.com/saphelp_nw04/helpdata/EN/2e/96fd3f2d14e869e10000000a155106/frameset.htm
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.