cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Receiver problem

Former Member
0 Kudos

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.

.

Accepted Solutions (1)

Accepted Solutions (1)

former_member181985
Active Contributor
0 Kudos

Not required.

JDBC Adapter in Receiver mode can act as synchronous.

Answers (3)

Answers (3)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.

former_member181985
Active Contributor
0 Kudos

> 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]

MichalKrawczyk
Active Contributor
0 Kudos

hi,

>>>Do I need to create the JDBC sender adapter to pass the response back to Proxy?

no

Regards,

Michal Krawczyk