| Author |
Message |
 Topic: Handle XML in Java |
newbee001
Replies: 20
Views: 8852
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Fri Aug 19, 2016 9:24 am Subject: Handle XML in Java |
Jeff,
In this case, should I assume safely that we dont need to bother about encoding for inbound message from ANY SYSTEM received in broker, but only when generating outbound messages (say to main ... |
| Topic: Handle XML in Java |
newbee001
Replies: 20
Views: 8852
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Aug 19, 2016 7:39 am Subject: Handle XML in Java |
Yes, you are right. Sending byte[] to DB2 doesn't works for XML datatype, but string does.
I've a question, if my 'emp' data received from mainframe in EBCDIC format, applying the below hard coded ... |
| Topic: Handle XML in Java |
newbee001
Replies: 20
Views: 8852
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 17, 2016 3:34 pm Subject: Handle XML in Java |
Thanks, the problem is resolved.
Is this correct? pls advise.
byte[] mybytes=(byte[]) emp.toBitstream(null, null, null, 546, 1208, 0);
String empStr = new String(mybytes,"UTF-8&qu ... |
| Topic: Handle XML in Java |
newbee001
Replies: 20
Views: 8852
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 17, 2016 1:17 pm Subject: Handle XML in Java |
I'm getting below Db2 exception by passing xml in string/byte[] format from JCN -
SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=XMLSTR
however am able to run bel ... |
| Topic: Handle XML in Java |
newbee001
Replies: 20
Views: 8852
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 17, 2016 12:03 pm Subject: Handle XML in Java |
yes jeff, the pbm is resolved after changing the code as below -
String ccsid = inMessage.getRootElement().getFirstElementByPath("Properties/CodedCharSetId").getValueAsString();
... |
| Topic: Handle XML in Java |
newbee001
Replies: 20
Views: 8852
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 17, 2016 11:51 am Subject: Handle XML in Java |
hi victor,
Database node will accept only ODBC datasource name. Please correct me if i'm wrong.
we have JDBC provider defined for DB connection and JCN seems the better choice..
https://devel ... |
| Topic: Handle XML in Java |
newbee001
Replies: 20
Views: 8852
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 17, 2016 10:40 am Subject: Handle XML in Java |
Hi,
Thanks jeff for your suggestion.
yes vitor, its a jdbc user and hence need to develop in java..
below is my xml structure
Properties
MQMD
XMLNSC
<employees>
< ... |
| Topic: Handle XML in Java |
newbee001
Replies: 20
Views: 8852
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 17, 2016 9:21 am Subject: Handle XML in Java |
Hi,
I've a requirement to insert 'xml' data from Java compute node to the DB2 table column of data type 'xml'.
Please guide me on how to write the code to insert xml data directly.
Thanks in ... |
| Topic: Stored Procedure vs Inline Query - Design Choice |
newbee001
Replies: 2
Views: 2520
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 04, 2016 6:41 am Subject: Stored Procedure vs Inline Query - Design Choice |
| Thanks Jeff.. that summarizes everything.. |
| Topic: Stored Procedure vs Inline Query - Design Choice |
newbee001
Replies: 2
Views: 2520
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 04, 2016 6:09 am Subject: Stored Procedure vs Inline Query - Design Choice |
Hi,
Is it best to write SP or inline SQL query for frequent (not bulk) DB inserts to design my audit component? Assume the volume of the transaction in a day will be 10,000. Looking for pros and co ... |
