| Author |
Message |
 Topic: In IIB10, getting Invalid SQL Statement error from Oracle |
asrajesh
Replies: 3
Views: 3592
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Sat Dec 29, 2018 5:25 am Subject: In IIB10, getting Invalid SQL Statement error from Oracle |
| Somebody, please help us in this issue as it is affecting our environment badly |
| Topic: In IIB10, getting Invalid SQL Statement error from Oracle |
asrajesh
Replies: 3
Views: 3592
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sat Dec 22, 2018 10:14 pm Subject: In IIB10, getting Invalid SQL Statement error from Oracle |
Thanks gfrench for your reply
We are running on HP Unix Platform.
Yes .. we have migrated ODBC driver to use the V10 driver. Please find below the ODBC setting for this DB
[ODSDB]
... |
| Topic: In IIB10, getting Invalid SQL Statement error from Oracle |
asrajesh
Replies: 3
Views: 3592
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Dec 19, 2018 1:38 am Subject: In IIB10, getting Invalid SQL Statement error from Oracle |
Recently, we have migrated from IIB 9 to IIB 10.0.0.14. We had one service (done in IIB9) which calls Oracle SP that returns Ref cursor in the output parameter.
The service was working fine in IIB ... |
| Topic: Passing Ref cursor as INPUT parameter to Oracle SP in ESQL |
asrajesh
Replies: 8
Views: 6515
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Oct 31, 2017 6:06 am Subject: Passing Ref cursor as INPUT parameter to Oracle SP in ESQL |
sorry .. I did not notice properly.
So, in short, Reference cursor cannot be sent as Input parameter using ESQL to Oracle SP..
Am I correct ? |
| Topic: Passing Ref cursor as INPUT parameter to Oracle SP in ESQL |
asrajesh
Replies: 8
Views: 6515
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Oct 31, 2017 5:16 am Subject: Passing Ref cursor as INPUT parameter to Oracle SP in ESQL |
Thanks Vitor for your reply..
But, the link does not have information about passing ref cursor to ORACLE SP (through ESQL)..
I don't think the Stored Procedure in the database is overloaded.. Th ... |
| Topic: Passing Ref cursor as INPUT parameter to Oracle SP in ESQL |
asrajesh
Replies: 8
Views: 6515
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Oct 31, 2017 2:19 am Subject: Passing Ref cursor as INPUT parameter to Oracle SP in ESQL |
Hi
We are using IIB 9 .. and MQ 8
We have a requirement of calling ORACLE SP from ESQL . That SP accepts two String values and one Ref Cursor as Input parameter and Two String values as Output p ... |
| Topic: 2393-MQRC _SSL_INITIALIZATION_ERROR |
asrajesh
Replies: 12
Views: 20608
|
Forum: IBM MQ Security Posted: Sat May 25, 2013 12:27 am Subject: 2393-MQRC _SSL_INITIALIZATION_ERROR |
Hi Morag,
Yes .. you are correct. we wanted to use MQSCO structre in MQCONNX to use SSL (through client connection channel) to connect to the queue manager.
After compiling the program using c ... |
| Topic: 2393-MQRC _SSL_INITIALIZATION_ERROR |
asrajesh
Replies: 12
Views: 20608
|
Forum: IBM MQ Security Posted: Tue May 14, 2013 9:54 pm Subject: 2393-MQRC _SSL_INITIALIZATION_ERROR |
Thanks Hughson .. we changed the library as libmqm.so & the compilation script used
cc amqssslc.c -o mqsslput /opt/mqm/lib/libmqm.so
It worked.. Thank you so much...
Regards
S. Rajesh |
| Topic: 2393-MQRC _SSL_INITIALIZATION_ERROR |
asrajesh
Replies: 12
Views: 20608
|
Forum: IBM MQ Security Posted: Tue May 14, 2013 7:36 am Subject: 2393-MQRC _SSL_INITIALIZATION_ERROR |
Thanks Zpat,.. Can you please explain in detail about the libraries which should be used
Regards
Rajesh |
| Topic: 2393-MQRC _SSL_INITIALIZATION_ERROR |
asrajesh
Replies: 12
Views: 20608
|
Forum: IBM MQ Security Posted: Tue May 14, 2013 6:21 am Subject: 2393-MQRC _SSL_INITIALIZATION_ERROR |
| I do face a similar problem. When I run amqssslc is working fine. Where as when I take the source code, complile and run, it throws MQRC 2012 ( MQRC_ENVIRONMENT_ERROR). Not clear on which environmen ... |
| Topic: Expansion of WSDL |
asrajesh
Replies: 2
Views: 2934
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Feb 14, 2013 4:03 am Subject: Expansion of WSDL |
Thank you very much for your valuable tips. Really, this would help us..
For this issue, we have tried the versioning and it worked fine.. Thanks a lot
Regards
S. Rajesh |
| Topic: Expansion of WSDL |
asrajesh
Replies: 2
Views: 2934
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Feb 13, 2013 6:06 am Subject: Expansion of WSDL |
Hi,
Good day.
We are using WMB 7.0. We are in the process of migrating from existing middleware to message broker in phased approach. Currently, we have deployed some services in production a ... |
| Topic: Webservice call returning WSWS3400I failure |
asrajesh
Replies: 8
Views: 5997
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Feb 05, 2013 7:04 am Subject: Webservice call returning WSWS3400I failure |
Thank you very much ....
We found the issue. The issue was there was some extra spaces in the input message. We did a TRIM and the problem resolved..
String behaviour of broker..
Regards
S. ... |
| Topic: Webservice call returning WSWS3400I failure |
asrajesh
Replies: 8
Views: 5997
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Feb 04, 2013 7:08 am Subject: Webservice call returning WSWS3400I failure |
1. Since HTTPRequest node handle both SOAP as well as XML message, we went in for HTTPRequest node. Kindly note that the flow is working fine in other UNIX box.
2. We are using WMB version 7
T ... |
| Topic: Webservice call returning WSWS3400I failure |
asrajesh
Replies: 8
Views: 5997
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Feb 04, 2013 6:05 am Subject: Webservice call returning WSWS3400I failure |
Hi,
When calling webservice from our flow(using HTTPRequest node), we are receiving WSWS3400I failure response with the following message (in BLOB body)
<soapenv:Envelope
xmlns:so ... |
