| Author |
Message |
 Topic: Odbc SQL Server: RAISEERROR |
raphael.silva
Replies: 3
Views: 2897
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 13, 2011 8:45 am Subject: Odbc SQL Server: RAISEERROR |
I made some tests.
I used PASSTHRU statement to call the procedure.
That way, my handler code was reached.
I have some doubts. Why does it works for PASSTHRU but it doesn't calling the declared s ... |
| Topic: Odbc SQL Server: RAISEERROR |
raphael.silva
Replies: 3
Views: 2897
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 13, 2011 6:27 am Subject: Odbc SQL Server: RAISEERROR |
Yes I did it like this:
DECLARE EXIT HANDLER FOR SQLSTATE LIKE '%'
BEGIN
SET Environment.h.SQLSTATE = SQLSTATE;
SET Environment.h.SQLCODE = SQLCODE;
SET Environment. ... |
| Topic: Odbc SQL Server: RAISEERROR |
raphael.silva
Replies: 3
Views: 2897
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 13, 2011 4:42 am Subject: Odbc SQL Server: RAISEERROR |
Hi!
I'm calling a MS SqlServer 2008 stored procedure through ESQL, using datadirect Odbc.
The procedure does some validations and eventualy it raises an exception through the RAISEERROR instructio ... |
| Topic: ODBC NOT RESPONDING |
raphael.silva
Replies: 9
Views: 3920
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Mar 29, 2011 5:28 am Subject: ODBC NOT RESPONDING |
Ok, I'll do that.
Tks |
| Topic: ODBC NOT RESPONDING |
raphael.silva
Replies: 9
Views: 3920
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Mar 28, 2011 12:57 pm Subject: ODBC NOT RESPONDING |
I've already tried to enable ODBC trace.
Nothing appeared at the log. It seems that the command wasn't sent to the database.
The connection seems to be fine by the execution of SELECT 1 FROM Data ... |
| Topic: ODBC NOT RESPONDING |
raphael.silva
Replies: 9
Views: 3920
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Mar 28, 2011 12:18 pm Subject: ODBC NOT RESPONDING |
I just run a test in my code like this:
SET OutputRoot.XMLNSC.XML.RETURN[] = SELECT 1 FROM Database.DUAL;
Everytime I run it, I got the response very fast.
That makes me think that the connecti ... |
| Topic: ODBC NOT RESPONDING |
raphael.silva
Replies: 9
Views: 3920
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Mar 28, 2011 11:16 am Subject: ODBC NOT RESPONDING |
Yes, I established the connection through the odbc test application running at the broker server.
And the javacompute node as well was able to connect to the same database.
In the log I didnt noti ... |
| Topic: ODBC NOT RESPONDING |
raphael.silva
Replies: 9
Views: 3920
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Mar 28, 2011 11:03 am Subject: ODBC NOT RESPONDING |
Hello!
I'm using MessageBroker 6.1.0.5 to connect to an Oracle and a SQLServer database.
The connection to the SQLServer works perfectly, but when I try to call stored procedures from Oracle, I'm ha ... |
