on 08-14-2008 6:58 AM
Hi
I am working on a synchronous interface that has jdbc at the receiver side..
I need to be doing a select dynamically based on a filed from the request like
select locationId from dbTablename where empId = 'xxx' AND delFlag =0
the xxx will be populated from a filed in the request
For this i have set up a request structure with action as "SQL_QUERY" and the following query in the access field
SELECT location_id from dbtablename where empID='$cv_EMPID$' and delFlag=0
I have a key element which has a sub-element "cv_EMPID"
Unfortunately, the query doestn pull any records from the dbtable..
In sxmb_moni , I get a query like this
- <STATEMENT>
- <TABLENAME action="SQL_QUERY">
<TABLE>tablename</TABLE>
</TABLENAME>
<access>select cv_locationID from tablename where cv_empID='$cv_EmpID$'</access>
- <key>
<cv_EmpID>60000016</cv_EmpID>
</key>
</STATEMENT>
but there is no response
What do u think is the problem here?
Thanks
Krishna
Hi,
Use this for Refference
https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/step%2bby%2bstep%2brfc%2bto%2bjdbc%2bscenario
Regards
Seshagiri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Krishna,
Even though the Problem solved by yourself,
if you share the solution it will be helpfull for others who come across the same prolem in future
Regards
Seshagiri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Solved by myself..
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Refer these links:
http://help.sap.com/saphelp_nw70/helpdata/en/b0/676b3c255b1475e10000000a114084/content.htm
Check out this-
http://help.sap.com/saphelp_erp2005vp/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
Also check that, JDBC driver is installed correctly- for this
Check out these links
http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm
http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
Regards,
Nithiyanandam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.