| Author |
Message |
 Topic: ESQL Behavior (Caching?) |
Dave Ziegler
Replies: 23
Views: 8002
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 01, 2015 3:39 pm Subject: ESQL Behavior (Caching?) |
I changed the driver to SQL Server Native Client 10.0 and now it works (was just using SQL Server before).
I thought it had to be a driver issue, but my sysadmin didn't think it would matter. Tur ... |
| Topic: ESQL Behavior (Caching?) |
Dave Ziegler
Replies: 23
Views: 8002
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 01, 2015 2:40 pm Subject: ESQL Behavior (Caching?) |
| So... IIB is clearly caching something here. I made a request, it worked, made another one and it failed as per usual. I deleted the ODBC connection in the ODBC applet and fired off more requests. ... |
| Topic: ESQL Behavior (Caching?) |
Dave Ziegler
Replies: 23
Views: 8002
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 01, 2015 10:26 am Subject: ESQL Behavior (Caching?) |
| The most frustrating part of this is that executing the same SQL via Enterprise Manager works over and over and over. Only through Broker does this occur. |
| Topic: ESQL Behavior (Caching?) |
Dave Ziegler
Replies: 23
Views: 8002
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 01, 2015 10:01 am Subject: ESQL Behavior (Caching?) |
Did that as well and nothing conclusive came of it.
I'll ride out the PMR process and report back. |
| Topic: ESQL Behavior (Caching?) |
Dave Ziegler
Replies: 23
Views: 8002
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 01, 2015 9:03 am Subject: ESQL Behavior (Caching?) |
It returns empty after the first call.
After a timeout passes, it is populated as expected. |
| Topic: ESQL Behavior (Caching?) |
Dave Ziegler
Replies: 23
Views: 8002
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 01, 2015 8:35 am Subject: ESQL Behavior (Caching?) |
Works the first time, fails the second time (with hard-coded values), and this is in the trace:
2015-04-01 11:29:58.959208 3920 UserTrace BIP2562I: Node 'Main.Handle POST'&# ... |
| Topic: ESQL Behavior (Caching?) |
Dave Ziegler
Replies: 23
Views: 8002
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 01, 2015 8:16 am Subject: ESQL Behavior (Caching?) |
| Logged a PMR. |
| Topic: ESQL Behavior (Caching?) |
Dave Ziegler
Replies: 23
Views: 8002
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 01, 2015 8:10 am Subject: ESQL Behavior (Caching?) |
So this is weird. I did this too:
DECLARE input REFERENCE TO InputRoot.JSON.Data;
DECLARE dataRow ROW;
CALL MyProc(input.username, input.password, input.status, input.datefrom, input.datet ... |
| Topic: ESQL Behavior (Caching?) |
Dave Ziegler
Replies: 23
Views: 8002
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 01, 2015 8:06 am Subject: ESQL Behavior (Caching?) |
| Just because... I set the domain on my HTTP Input node to 'blank' (was JSON), and popped a RCD node directly after it with JSON set as the domain. Same results, but I expected as much. |
| Topic: ESQL Behavior (Caching?) |
Dave Ziegler
Replies: 23
Views: 8002
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 01, 2015 8:00 am Subject: ESQL Behavior (Caching?) |
| Hard-coded values produce the same results fyi. |
| Topic: ESQL Behavior (Caching?) |
Dave Ziegler
Replies: 23
Views: 8002
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 01, 2015 7:56 am Subject: ESQL Behavior (Caching?) |
| Do you mean hard-code the values? |
| Topic: ESQL Behavior (Caching?) |
Dave Ziegler
Replies: 23
Views: 8002
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 01, 2015 7:55 am Subject: ESQL Behavior (Caching?) |
Try wiring the values and see what happens 
2015-04-01 09:23:45.658028 7392 UserTrace BIP2539I: Node 'ImbESQLManager': Evaluating expression ''input.from'' at ... |
| Topic: ESQL Behavior (Caching?) |
Dave Ziegler
Replies: 23
Views: 8002
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 01, 2015 7:46 am Subject: ESQL Behavior (Caching?) |
Sounds obvious, but, are you sure that you're sending the same message every time to the compute node?
Yes, I'm clicking Execute on the same JSON from Fiddler. Works again after a timeout elapse ... |
| Topic: ESQL Behavior (Caching?) |
Dave Ziegler
Replies: 23
Views: 8002
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 01, 2015 7:41 am Subject: ESQL Behavior (Caching?) |
Good suggestion, I'll try this first.
Also noticed the to/from dateto/datefrom weren't lining up, so I fixed that. Not sure how it was working at all to be honest, I guess the parser is position-b ... |
| Topic: ESQL Behavior (Caching?) |
Dave Ziegler
Replies: 23
Views: 8002
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 01, 2015 7:32 am Subject: ESQL Behavior (Caching?) |
| I have removed the TIMESTAMP question from this equation. Changing the input params to CHARACTER and passing them into the stored proc as VARCHAR had no effect. Still works the first time, but not on ... |
