| Author |
Message |
 Topic: Connecting to Database SQL Server Using ESQL |
mona
Replies: 6
Views: 8355
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Sun Sep 09, 2012 5:23 am Subject: Connecting to Database SQL Server Using ESQL |
Hi
1- Create Data source
2- in property compute node we set Datasource and Transation = cmmite
3- create database definaition
4- write ESQL code for use DB in compute node
5- use mqsisetdbparms ... |
| Topic: Config service of TCPIPserver for use SSL |
mona
Replies: 2
Views: 2538
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Aug 27, 2012 11:00 pm Subject: Config service of TCPIPserver for use SSL |
Thank's
After upgrade to ver 7.0.0.4 , SSL is OK |
| Topic: Config service of TCPIPserver for use SSL |
mona
Replies: 2
Views: 2538
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Aug 26, 2012 10:08 pm Subject: Config service of TCPIPserver for use SSL |
Hi
I'm using WMB 7.0.0.1
In the configurable connection parameters on the default configurable services for TCPIP server or TCPIP client nodes, SSLPorotocol and SSLCiphers not exist, So after change ... |
| Topic: Question about SSL |
mona
Replies: 1
Views: 1538
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Aug 24, 2012 11:52 pm Subject: Question about SSL |
Hi
For use SSL over TCP/IP connection, whether we should build flow for do handshake? or the handshack do auto in Layer TCP/IP ? |
| Topic: Receive data from DB |
mona
Replies: 14
Views: 7005
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 26, 2012 10:30 am Subject: Receive data from DB |
Thank's a lot
after run mqsicvp , i get success
also , i can insert data to Database |
| Topic: Receive data from DB |
mona
Replies: 14
Views: 7005
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 25, 2012 11:15 am Subject: Receive data from DB |
Thank you for all friends, I use above code and also ROW type but i get following error
BIP2488E: ('.fetch_from_db.Main', '8.3') Error detected whilst executing the SQL statement ''DE ... |
| Topic: Receive data from DB |
mona
Replies: 14
Views: 7005
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 25, 2012 3:20 am Subject: Receive data from DB |
Thanks
I use these codes
DECLARE M CHARACTER;
SET M = (SELECT D.Name FROM Database.table AS D WHERE D.ID = '10');
also
SET OutputLocalEnvironment.Destination.MQDestinationList.De ... |
| Topic: Receive data from DB |
mona
Replies: 14
Views: 7005
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 25, 2012 2:00 am Subject: Receive data from DB |
Hi
How can i receive data from Database(oracle) and Save in variable, for example
Set ?? = (SELECT D.Name FROM Database.table AS D WHERE D.ID = '10');
|
| Topic: Recive message without Set Length |
mona
Replies: 16
Views: 9796
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sat Jul 07, 2012 8:40 am Subject: Recive message without Set Length |
my default: first 2 byte in message not content of length of message, so I don't use it bytes.I want get stream of data(hex or ...) without using first 2 byte of message.
e.g data
0800202001000 ... |
| Topic: Recive message without Set Length |
mona
Replies: 16
Views: 9796
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sat Jul 07, 2012 12:26 am Subject: Recive message without Set Length |
Hi
I send data with any size to WMB with below config, but only first 80 byte(defult) save in QOUT and other of data save in QFail(len 130 = 80 in Qout & 50 in Qfail)
TCP/IP input server ----o ... |
| Topic: Recive message without Set Length |
mona
Replies: 16
Views: 9796
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 02, 2012 8:36 am Subject: Recive message without Set Length |
Thank's form all friends for support me.
1) set up a Receive node to read the fixed length part of the stream. In your case, two bytes
2) wire up a computeNode to the out terminal of A SECOND Rec ... |
| Topic: Recive message without Set Length |
mona
Replies: 16
Views: 9796
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 02, 2012 4:10 am Subject: Recive message without Set Length |
I don't sure about fix length of header, because sometime 2 first byte of message include message length, and sometime no exist this 2 first byte.
i want write the function that, without accounting ... |
| Topic: Recive message without Set Length |
mona
Replies: 16
Views: 9796
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 02, 2012 2:11 am Subject: Recive message without Set Length |
Hi
1- I send message from POS (it is variable length) to WMB and don't allow me to change length of the message ,do you know other way? |
| Topic: Recive message without Set Length |
mona
Replies: 16
Views: 9796
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Jul 01, 2012 11:26 pm Subject: Recive message without Set Length |
who can recived bata(Hex)from TCP/IP input node without Set Length in record detection?(becase, I don't know length of message)
Tcpip input server--out---> Qoutput & Tcpip input server--fail ... |
| Topic: problem in TCP/IP |
mona
Replies: 8
Views: 4645
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jun 26, 2012 8:34 pm Subject: problem in TCP/IP |
yes, if change the property of record detection to 'Connection clode', don't any data receive.
of course, I think problem in compute node code, because i got these error:
--------------------------- ... |
