| Author |
Message |
 Topic: How to call oracle TO_TIMESTAMP() in MbSQLStatement? |
bab
Replies: 1
Views: 2233
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Fri Mar 03, 2017 5:05 am Subject: How to call oracle TO_TIMESTAMP() in MbSQLStatement? |
Hi , I am using MbSQLStatement for ODBC connection in JCN.
When executing SELECT statement with WHERE clause , calling TO_TIMESTAMP() method to convert string into timestamp format , throws the fo ... |
| Topic: How to handle commit and rollback in Java method? |
bab
Replies: 7
Views: 3717
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Aug 22, 2016 9:35 pm Subject: How to handle commit and rollback in Java method? |
Yes. You are correct. I tried to storing the connection object inside global cache, it is throwing error.
Looking for alternate solution... |
| Topic: How to handle commit and rollback in Java method? |
bab
Replies: 7
Views: 3717
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Aug 22, 2016 4:34 am Subject: How to handle commit and rollback in Java method? |
| Thanks for your reply. It could be better if you say how to store session ? Store in global cache or which format? |
| Topic: How to handle commit and rollback in Java method? |
bab
Replies: 7
Views: 3717
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Aug 21, 2016 10:16 pm Subject: How to handle commit and rollback in Java method? |
Hi ...
I am trying to commit database connection explicitly inside java method.
I know Compute and Java Compute nodes are handling commit and rollback automatically.
But I need to handle c ... |
| Topic: How to parse xml string in ESQL? |
bab
Replies: 2
Views: 3210
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 17, 2016 3:41 am Subject: How to parse xml string in ESQL? |
I have the following string value.
<customer><name>john</name><city>sydney</city></customer>
I want to convert the above string represented value into xml and ... |
| Topic: How to return mbElement[] from Java to ESQL? |
bab
Replies: 14
Views: 7527
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Aug 09, 2016 9:20 pm Subject: How to return mbElement[] from Java to ESQL? |
Thanks for your suggestions.
@mqjeff - I tried whatever you specified in the following statement
CALL retrieveData(CAST(AGE AS INTEGER),OutputRoot) into RESULT;
But i didn't ret ... |
| Topic: How to return mbElement[] from Java to ESQL? |
bab
Replies: 14
Views: 7527
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Aug 09, 2016 6:29 am Subject: How to return mbElement[] from Java to ESQL? |
Thanks for your reply.
I got output.
I have used in the following way:
SET OutputRoot.XMLNSC.employees=null;
DECLARE outputref REFERENCE TO OutputRoot.XMLNSC.employees;
CALL ret ... |
| Topic: How to return mbElement[] from Java to ESQL? |
bab
Replies: 14
Views: 7527
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Aug 08, 2016 8:38 pm Subject: How to return mbElement[] from Java to ESQL? |
| It is returning MbElement properly and I can able to add child element under OutputRoot->XMLNSC->employees and I can able to access the children of employees element in the Expressions tab while ... |
| Topic: How to read xsd file contents in Compute node? |
bab
Replies: 10
Views: 9815
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Aug 08, 2016 3:20 am Subject: How to read xsd file contents in Compute node? |
Thanks for all your reply.
@Vitor and @fjb_saper , I need to generate XML contents dynamically based on the XSD file. |
| Topic: How to return mbElement[] from Java to ESQL? |
bab
Replies: 14
Views: 7527
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Aug 08, 2016 2:32 am Subject: Error: SqlRoutine::clearDownChildEnv |
I am using the following code in ESQL
CALL retrieveData(CAST(AGE AS INTEGER),OutputRoot.XMLNSC.employees) into RESULT;
Calling java method as follows :
create function retr ... |
| Topic: How to read xsd file contents in Compute node? |
bab
Replies: 10
Views: 9815
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Aug 05, 2016 2:14 am Subject: How to read xsd file contents in Compute node? |
Hi i am new to IIB.
I know we can able to read xml data using XMLNSC parser in IIB.
Is there any way to read xsd file contents in ESQL or Compute Node? |
| Topic: How to return mbElement[] from Java to ESQL? |
bab
Replies: 14
Views: 7527
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 04, 2016 5:03 am Subject: How to return mbElement[] from Java to ESQL? |
| I can able to pass REFERENCE type but i am unable to return mbElement[] type. |
| Topic: How to return mbElement[] from Java to ESQL? |
bab
Replies: 14
Views: 7527
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 04, 2016 3:59 am Subject: How to return mbElement[] from Java to ESQL? |
Thanks for your reply.
I read the documentation available here [url=https://www.ibm.com/support/knowledgecenter/SSMKHH_9.0.0/com.ibm.etools.mft.doc/ak20708_.htm]They mentioned about REFERENCE type ... |
| Topic: How to return mbElement[] from Java to ESQL? |
bab
Replies: 14
Views: 7527
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 04, 2016 3:28 am Subject: How to return mbElement[] from Java to ESQL? |
Hi I am new to IIB.
I want to pass REFERENCE as a argument to Java method and transform it then i want to return in the form of mbElement[].
Is there any way to do?
Kindly reply. |
| Topic: How to access element name dynamically? |
bab
Replies: 4
Views: 3819
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 04, 2016 3:22 am Subject: Thanks for all your replies. |
| Thanks for all your replies. |
