| Author |
Message |
 Topic: IIB9: ESQL UPDATE |
gisly
Replies: 9
Views: 8341
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Fri Sep 13, 2019 2:00 am Subject: IIB9: ESQL UPDATE |
Hi! Sorry for reviving this post but I just wanted to say that we've come across a similar behaviour in IIB v. 10.0.0.13
UPDATE DOCUMENT AS SET FIELD1=someFunction() WHERE D.FIELD2 = ?
fi ... |
| Topic: JDBC TYPE 4 SQL Server 2008 cannot connect in IIB v 9 |
gisly
Replies: 3
Views: 4417
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Feb 24, 2016 12:19 am Subject: JDBC TYPE 4 SQL Server 2008 cannot connect in IIB v 9 |
That aside, have you been albe to create a DB view of this Database in the Toolkit? That would prove that you can connect to the SQLServer via JDBC.
Thanks for the tip. Yes, it's created successfully ... |
| Topic: JDBC TYPE 4 SQL Server 2008 cannot connect in IIB v 9 |
gisly
Replies: 3
Views: 4417
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sat Feb 20, 2016 8:49 am Subject: JDBC TYPE 4 SQL Server 2008 cannot connect in IIB v 9 |
Hi!
I cannot configure SQL Server JDBCProvider for IIB v 9.0.0.3 (the Oracle one works on the same machine; there's a requirement to use JDBC for SQL Server).
This is a fragment from the exception t ... |
| Topic: Execution group timestamp becomes garbled |
gisly
Replies: 1
Views: 2744
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Aug 25, 2015 11:43 pm Subject: Execution group timestamp becomes garbled |
I managed to solve it:
the wrong date was in the file:
C:\ProgramData\IBM\MQSI\components\(broker name)\repository\brokeraaeg.dat
(DateLastUpdated="16870-05-25")
I changed the date t ... |
| Topic: Execution group timestamp becomes garbled |
gisly
Replies: 1
Views: 2744
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Aug 25, 2015 7:44 am Subject: Execution group timestamp becomes garbled |
Hi!
I've got a strange thing on my local Windows WMB v 7.
When started, all execution groups on all broker instances write the following into their console.logs:
16870-05-25 11:57:27.498 Execut ... |
| Topic: Retaining the original value of an escaped XML string |
gisly
Replies: 10
Views: 7826
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 06, 2015 7:20 am Subject: Retaining the original value of an escaped XML string |
Hi!
Sorry for writing only now, we finally realized kimbert was right.
So we managed to persuade them to send us correct data. |
| Topic: WMB v7: caching an SQL Server stored procedure parameters |
gisly
Replies: 1
Views: 2776
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 06, 2015 7:18 am Subject: WMB v7: caching an SQL Server stored procedure parameters |
Hi!
I've got the following issue:
we call an SQL Server 2012 stored procedure via ODBC in Message Broker v 7 (tested on Windows and HP-Unix).
Here's the procedure definition in ESQL:
CREATE ... |
| Topic: Retaining the original value of an escaped XML string |
gisly
Replies: 10
Views: 7826
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 25, 2015 6:26 am Subject: Retaining the original value of an escaped XML string |
Thanks.
Well, my problem is that what they are sending has to be a correct XML. And that's all they are obliged to do. I see your point, but I don't think they're obliged to escape the ampersand &quo ... |
| Topic: Retaining the original value of an escaped XML string |
gisly
Replies: 10
Views: 7826
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 25, 2015 4:37 am Subject: Retaining the original value of an escaped XML string |
Hi!
But this
<response>
<someTag>SOME TEXT CONTENT WITH XML ENTITIES LIKE &</someTag>
</response>
is a valid XML, isn't it?
If it were simply ... |
| Topic: Retaining the original value of an escaped XML string |
gisly
Replies: 10
Views: 7826
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 25, 2015 12:19 am Subject: Retaining the original value of an escaped XML string |
Hi!
I've got aproblem with Message Broker v. 7
I obtain a response from an HTTP-node. The XML in the response has a tag, which contains an escaped XML string.
It looks like that
<response> ... |
| Topic: Passing arrays to an Oracle stored procedure: encoding |
gisly
Replies: 2
Views: 4685
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sat Oct 11, 2014 3:34 am Subject: Passing arrays to an Oracle stored procedure: encoding |
| Thanks, that's what we actually ended up doing. |
| Topic: Passing arrays to an Oracle stored procedure: encoding |
gisly
Replies: 2
Views: 4685
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Oct 06, 2014 10:01 pm Subject: Passing arrays to an Oracle stored procedure: encoding |
Hi!
I've got to pass an array of strings to an Oracle stored procedure calling it from Message Broker v. 7. As far as I can understand, I can't do it using ESQL, so I'm using Java.
I've found an exa ... |
| Topic: Message Broker 7 Oracle 12 C Connectivity |
gisly
Replies: 4
Views: 5293
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Sep 10, 2014 10:28 pm Subject: Message Broker 7 Oracle 12 C Connectivity |
Hi! Sorry for posting into this old thread.
Did you manage to overcome the issue?
We first hit an issue with client connectivity in Oracle whereby the sqlnet.ora needed to be updated on Oracle sid ... |
| Topic: Propagating error messages from XSLT to Message Broker trace |
gisly
Replies: 2
Views: 3744
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jan 17, 2014 10:33 am Subject: Propagating error messages from XSLT to Message Broker trace |
| Yes, thank you, I've seen that thread but it has no answers to my questions |
| Topic: Propagating error messages from XSLT to Message Broker trace |
gisly
Replies: 2
Views: 3744
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jan 17, 2014 5:33 am Subject: Propagating error messages from XSLT to Message Broker trace |
Hi,
I have got an xsl-transformation file, which throws an exception in case of bad data:
<xsl:message terminate="yes">ER=BAD,TEXT=the number <xsl:value-of select="$ ... |
