on 06-15-2009 7:24 PM
I have created scenario to fetch data from database table using SELECT action. My scenario is PROXY to JDBC Syncronous communication.
PROXY <>PI<>JDBC SELECT
Do I need to create the JDBC sender adapter to pass the response back to Proxy?
Thanks,
Vijay.
.
Not required.
JDBC Adapter in Receiver mode can act as synchronous.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Praveen,
I had configured the scenario but getting the following error.
- <SAP:Error xmlns:SAP="http://sap.com/xi/XI/Message/30" xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/" SOAP:mustUnderstand="1">
<SAP:Category>XIServer</SAP:Category>
<SAP:Code area="INTERNAL">CLIENT_SEND_FAILED</SAP:Code>
<SAP:P1>500</SAP:P1>
<SAP:P2>Internal Server Error</SAP:P2>
<SAP:P3>(See attachment HTMLError for details)</SAP:P3>
<SAP:P4 />
<SAP:AdditionalText />
<SAP:Stack>Error while sending by HTTP (error code: 500, error text: Internal Server Error) (See attachment HTMLError for details)</SAP:Stack>
<SAP:Retry>N</SAP:Retry>
</SAP:Error>
When I cross checked the JDBC Receiver communication channel in Runtime Work Bench
request and response were successfull. RWB shows the following message.
2009-06-12 09:34:50 Information The message was successfully received by the messaging system.
2009-06-12 09:34:50 Information Message successfully put into the queue.
2009-06-12 09:34:50 Information The message was successfully retrieved from the request queue.
2009-06-12 09:34:50 Information The message status was set to DLNG.
2009-06-12 09:34:50 Information Delivering to channel: DB2ReceiverTableSPT
2009-06-12 09:34:50 Information JDBC Adapter Receiver processing started, required QoS BestEffort
2009-06-12 09:34:50 Information JDBC Adapter Receiver Channel DB2ReceiverTableSPT:
2009-06-12 09:36:35 Information Database request processed successfully.
2009-06-12 09:36:35 Information The message was successfully delivered to the application using connection JDBC_http://sap.com/xi/XI/System.
2009-06-12 09:36:35 Information The message status was set to DLVD.
I had gone thru all the previous threads related to 'CLIENT_SEND_FAILED' but
those did not solve my problem.
Thanks,
Vijay.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Can some one help me with JDBC SELECT syncronous configuration steps in detail will help me a lot. I had gone thru blog
/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step
but this don't have complete information.
Thanks,
Vijay.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> Can some one help me with JDBC SELECT syncronous configuration steps in detail will help me a lot. I had gone thru blog
> /people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step
> but this don't have complete information.
That blog is foundation for newbies............:)
you can check this too..........
[/people/praveen.gujjeti/blog/2009/01/29/best-practices-with-receiver-jdbc-adapter-document-formats|/people/praveen.gujjeti/blog/2009/01/29/best-practices-with-receiver-jdbc-adapter-document-formats]
hi,
>>>Do I need to create the JDBC sender adapter to pass the response back to Proxy?
no
Regards,
Michal Krawczyk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
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.