IBM Integration Bus (formerly WebSphere Message Broker) is integration broker that provides connectivity and universal data transformation in heterogeneous IT environments.
Questions tagged [ibm-integration-bus]
428 questions
11
votes
2 answers
How to resolve WebSphere MQ Reason code 2195 related error?
I am getting an WebSphere MQ Reason code 2195 MQRC_UNEXPECTED_ERROR when I try to connect to the message flows deployed on the execution group. Can somebody please tell me what exactly does this reason code mean? Queue manager, broker , execution…
Tanu
- 369
- 5
- 7
- 18
10
votes
6 answers
Is it good programming to have a return type of Exception?
I ran into an odd situation during a use case on a project: ESQL is calling a java method, sending it a String input parameter which the method will unmarshal, apply some logic, and then store useful info from the unmarshalled object. So, the method…
JWiley
- 3,129
- 8
- 41
- 66
5
votes
1 answer
Dynamic JSON key/value pairs generation in ESQL
How to transform JSON response retrieved from external system to meaningful data (key/value pairs) in ESQL?
Retrieved JSON:
{
"data": [
{
"name": "application.info.header",
"value": "headerValue"
},
…
Muhammad Faizan Uddin
- 1,339
- 12
- 29
5
votes
2 answers
How to select distinct in esql?
I have a subflow in esql (IBM Websphere Message Broker) where I need to achieve something similar to select distinct functionality.
Some background: I have a table in an Oracle database group_errcode_ref. This table is pretty much a fixed…
bbedward
- 6,368
- 7
- 36
- 59
5
votes
1 answer
What is the XQuery equivalent of the ESQL COALESCE function?
I'm trying convert WMB 7 mapping nodes to IIB 9 nodes. The auto-convert process turns some ESQL functions to XQuery functions.
Specifically, it turns the ESQL function
COALESCE (var0, var1)
(which returns the first non-null value, as in if var0 =…
Alaychem goes to Codidact
- 533
- 5
- 19
5
votes
3 answers
CURRENT_TIME format in esql
What is the default format of the function CURRENT_TIME in esql and how do we change it as per our requirements(24 hr or 12 hr formats)
Lee
- 101
- 1
- 2
- 6
4
votes
3 answers
How to get all values of a MbGlobalMap inside the IIB Global Cache?
I'm storing some information inside a MbGlobalMap (embedded Global Cache) of the IBM Integration Bus. If the map is called EXAMPLE.MAP I can access the values as follows:
MbGlobalMap map = MbGlobalMap.getGlobalMap("EXAMPLE.MAP");
Object value =…
Yannick
- 663
- 1
- 10
- 33
3
votes
0 answers
MQFTE monitor to append the messages from queue to file
I have a requirement where I want create different files from MQ messages based on the filename in the header. If a file is already existing in the folder location, the message in the queue should be appended to the contents of already existing…
Hane
- 43
- 5
3
votes
1 answer
ESQL String Splitter Functions For Splitting Delimited Strings
ESQL does not have an inbuilt string splitting function like Java and whilst it's easy enough to build a static function and add the *.jar to the IIB classpath several sites I've worked at have a blanket ban on using Java.
So what does an efficient…
TJA
- 2,969
- 2
- 25
- 32
3
votes
2 answers
JSON array creation in esql
I am new to IIB and I am struggling to create below JSON data in Extended SQL. Kindly suggest me.
{
"name" : "John Doe",
"age" : -1,
"known" : false,
"address" : { "street" : null, "city" : "unknown" },
"belongings" : ["this",…
Raghu
- 31
- 1
- 1
- 5
3
votes
2 answers
ELK for IBM Integration Bus 10 (IIB)
We would like to use ELK for monitoring our IBM Integration Bus.
We would like to preform 2 things:
Get the IIB log (the default broker log) from several Linux servers to logstash (is there any tutorial to do that? grok?)
Write messages that goes…
octo-developer
- 181
- 1
- 1
- 10
3
votes
2 answers
Skip certificate validation in IIB
I am using HTTPRequest node to make requests using TLS. Is there a way to skip certificate validation (checking the certificate chain, the expiration date) with standard IIB settings? I know this is risky.
gisly
- 673
- 1
- 8
- 30
3
votes
1 answer
IIB Java Compute Node vs ESQL Compute Node
What the pros anc cons of using Java compute node instead of esql compute node in IIB 9.0 ?
Is Java really slower than esql ?
Is there any example when JCN will suits better than ECN ?
Vito Karleone
- 355
- 1
- 6
- 17
3
votes
2 answers
Get Multiple Outputs From Single Input Message
I want to get multiple output from a single XML input message.
Amrit
- 137
- 2
- 2
- 13
3
votes
1 answer
IIB/ESQL: How to test if UUID is valid, if not generate one
I have a message flow in IBM Integration Bus.
I have some input that specifies a UUID, I want to test if that UUID is valid and if it is not I'd like to generate one.
Downstream if I call something like UUIDASCHAR I get a BIP2582 exception for…
bbedward
- 6,368
- 7
- 36
- 59