| Author |
Message |
 Topic: .odbc.ini alternate servers - MB 8 |
PisgahMan
Replies: 0
Views: 1603
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Wed Oct 01, 2014 11:41 am Subject: .odbc.ini alternate servers - MB 8 |
I have some questions about how the oracle connections will work in the odbc.ini file. Thanks in advance for your help.
Messge Broker 8 on zLinux
Oracle 11g(on servers remote to MB)
1. Is t ... |
| Topic: Question about validation node and CWF messages |
PisgahMan
Replies: 2
Views: 1679
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jan 31, 2008 6:30 am Subject: Question about validation node and CWF messages |
| Well I don't think that will work. I don't think I can use the validate node to check the message format without loading it into that message format first. |
| Topic: Question about validation node and CWF messages |
PisgahMan
Replies: 2
Views: 1679
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jan 31, 2008 6:06 am Subject: Question about validation node and CWF messages |
| I have a situation in which I get 2 different formats of CWF messages on the same queue. Each one is processed differently in the flow. I have each one defined differently in my messageset, and wha ... |
| Topic: Syntax in Mapping editor |
PisgahMan
Replies: 0
Views: 1276
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Sep 17, 2007 8:50 am Subject: Syntax in Mapping editor |
v6.
I am using a message map to pull data from a database and populate an XML message. I have a where clause in the db$:select row of the message editor.
This works fine with a hardcoded value ... |
| Topic: JDBC vs ODBC discrepancy in mapping node(?) |
PisgahMan
Replies: 17
Views: 13524
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Sep 12, 2007 10:14 am Subject: JDBC vs ODBC discrepancy in mapping node(?) |
| Yes, correct. Does the toolkit always and only use JDBC? |
| Topic: JDBC vs ODBC discrepancy in mapping node(?) |
PisgahMan
Replies: 17
Views: 13524
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Sep 12, 2007 9:06 am Subject: JDBC vs ODBC discrepancy in mapping node(?) |
| Alright. I made an interesting discovery. The name of my dev database is 'd1aor1'. I created an ODBC DSN called 1br1srdb so I didn't have to change this as I moved from DEV > TEST > PROD. ... |
| Topic: JDBC vs ODBC discrepancy in mapping node(?) |
PisgahMan
Replies: 17
Views: 13524
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Sep 12, 2007 6:18 am Subject: JDBC vs ODBC discrepancy in mapping node(?) |
| I agree that it should. I can enter garbage in the datasource of the mapping node and I get the same error as if I use the real name. |
| Topic: JDBC vs ODBC discrepancy in mapping node(?) |
PisgahMan
Replies: 17
Views: 13524
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Sep 12, 2007 6:02 am Subject: JDBC vs ODBC discrepancy in mapping node(?) |
The Same SQL does work in the compute node. Using either PASSTHRU or SELECT.
jeff - sorry about those comments earlier. its been a rough morning. Obviously I do need some training.
I supp ... |
| Topic: JDBC vs ODBC discrepancy in mapping node(?) |
PisgahMan
Replies: 17
Views: 13524
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Sep 12, 2007 5:30 am Subject: JDBC vs ODBC discrepancy in mapping node(?) |
PieterV - i am using an ESQL Compute node.
jeff - I'll try to use the exact same SQL in the compute node to make sure it works. |
| Topic: JDBC vs ODBC discrepancy in mapping node(?) |
PisgahMan
Replies: 17
Views: 13524
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Sep 12, 2007 5:14 am Subject: JDBC vs ODBC discrepancy in mapping node(?) |
| Vitor - I was guessing (incorrectly) about the JDBC/OBDC problem. I just can't figure out why it works on a compute node and not a mapping node. I was hoping for something simple. |
| Topic: JDBC vs ODBC discrepancy in mapping node(?) |
PisgahMan
Replies: 17
Views: 13524
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Sep 12, 2007 5:08 am Subject: JDBC vs ODBC discrepancy in mapping node(?) |
| If I uncheck throw exception on database error, it does continue down the happy path, but the values I tried to map from the database are not there. Some hardcoded values I mapped to the output/XML ... |
| Topic: JDBC vs ODBC discrepancy in mapping node(?) |
PisgahMan
Replies: 17
Views: 13524
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Sep 12, 2007 4:45 am Subject: JDBC vs ODBC discrepancy in mapping node(?) |
You last comment was unnecessary, but totally in line with 50% of your other posts. Why did you post anything at all? This is my first message flow and I am trying to work my way thru it.
Doe ... |
| Topic: JDBC vs ODBC discrepancy in mapping node(?) |
PisgahMan
Replies: 17
Views: 13524
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Sep 12, 2007 4:35 am Subject: JDBC vs ODBC discrepancy in mapping node(?) |
v6
I have a mapping node which pulls data from an Oracle database and
uses that data to build and XML message. When I check the box in the mapping node that says 'throw exception on database e ... |
| Topic: 1st Message Flow - Can I use mapping with database results? |
PisgahMan
Replies: 3
Views: 2382
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Aug 10, 2007 9:14 am Subject: 1st Message Flow - Can I use mapping with database results? |
What would the syntax be if you just manually built up the string in ESQL, ...no dataset or mapping at all.....to set the whole output message to the value of your string?
SET OutBody.Message = MyS ... |
| Topic: 1st Message Flow - Can I use mapping with database results? |
PisgahMan
Replies: 3
Views: 2382
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Aug 10, 2007 6:35 am Subject: 1st Message Flow - Can I use mapping with database results? |
jefflowrey, thanks for the quick reply.
That is awesome news regarding JDBC/ODBC. I'll give that a shot. I assume I can somehow pass in a 'WHERE' to that query(?)
What I was doing in ESQL up ... |
