| Author |
Message
|
| PisgahMan |
 Posted: Wed Sep 12, 2007 4:35 am Post subject: JDBC vs ODBC discrepancy in mapping node(?) |
 |
|
Voyager
Joined: 27 Jul 2004
Posts: 93
|
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 error' I get the following.
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
In the properties of my mapping node, I have the datasource which is the exact same as in my compute node on the step previous(which works fine). Seems like (maybe) there is some mismatch between the JBDC connection I used in the tool kit and the ODBC used at runtime.
Can you tell me how to resolve this? Is there some place in my jdbc RDB definitions I need to add my OBDC datasource name? |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Sep 12, 2007 4:36 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
There is no mismatch between the JDBC RDB definitions and the ODBC datasource.
There is absolutely no connection between them at all.
Runtime only uses ODBC.
Welcome to Message Broker. Please get some training.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| PisgahMan |
| Posted: Wed Sep 12, 2007 4:45 am Post subject: |
|
|
Voyager
Joined: 27 Jul 2004
Posts: 93
|
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.
Does anyone know why I might get that error on a mapping node when a compute note works fine with the same datasource name? |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Sep 12, 2007 4:53 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| PisgahMan wrote: |
| You last comment was unnecessary |
Given the complexity of WMB it's a very valid point, which you should use on those in your organisation with budgetary controls to obtain such training for yourself. Teaching yourself WMB is a long, slow and pain filled process. Teaching yourself WMB with the aid of this forum is not something we're equipted to do. Despite the apparent belief of many of our posters.
| PisgahMan wrote: |
Does anyone know why I might get that error on a mapping node when a compute note works fine with the same datasource name? |
This is not what you asked. You asked about differences between the datasource in the mapping node and in the toolkit. These are, as previously pointed out, different things configured in different places and used for different things.
As to why the compute node works but the mapping node fails, check out the use of the datasource in each node and their requirements. In conjunction with the above comment.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Sep 12, 2007 5:00 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
If you uncheck "throw exception on database error" does the runtime problem go away?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| PisgahMan |
| Posted: Wed Sep 12, 2007 5:08 am Post subject: |
|
|
Voyager
Joined: 27 Jul 2004
Posts: 93
|
| 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 dataset are there. |
|
| Back to top |
|
|
| PisgahMan |
| Posted: Wed Sep 12, 2007 5:14 am Post subject: |
|
|
Voyager
Joined: 27 Jul 2004
Posts: 93
|
| 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. |
|
| Back to top |
|
|
| PieterV |
| Posted: Wed Sep 12, 2007 5:26 am Post subject: |
|
|
Disciple
Joined: 04 Jan 2006
Posts: 164
Location: Belgium
|
I think the difference between the Java Compute Node (using JDBC) and the compute node (use ODBC) is that you need to define the datasource name in the compute nodee and also have your database connectionstring in the .odbc.ini and issue the command mqsisetdbparms.
In the JCN it probably works with only programming the connection directly in the java code. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Sep 12, 2007 5:27 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
If you write a select in the previous node for the same things you are selecting against in the mapping... do you get results?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| PisgahMan |
| Posted: Wed Sep 12, 2007 5:30 am Post subject: |
|
|
Voyager
Joined: 27 Jul 2004
Posts: 93
|
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. |
|
| Back to top |
|
|
| PisgahMan |
| Posted: Wed Sep 12, 2007 6:02 am Post subject: |
|
|
Voyager
Joined: 27 Jul 2004
Posts: 93
|
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 suppose I'll just try to do my mapping in the compute node itself. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Sep 12, 2007 6:11 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
The mapping node should work just as well as the select.
It may be a) harder for you to debug, and b) harder for us to debug from here - since it's mostly a GUI thing rather than a code thing.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| PisgahMan |
| Posted: Wed Sep 12, 2007 6:18 am Post subject: |
|
|
Voyager
Joined: 27 Jul 2004
Posts: 93
|
| 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. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Sep 12, 2007 6:33 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Delete the mapping node and .msgmap file and start over.
Pay close attention to the options you are presented in each dialog box before the mapping editor opens.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| PisgahMan |
| Posted: Wed Sep 12, 2007 9:06 am Post subject: |
|
|
Voyager
Joined: 27 Jul 2004
Posts: 93
|
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. 1br1srdb is the one that was working on compute but not mapping nodes.
If I create a system dsn called d1aor1, the mapping node WILL work. The compute node works fine with 1br1srdb which I using as sort of an alias.
This is all on my local machine. The WMB DEV environment is AIX so I am not sure if a similar issue will happen there. |
|
| Back to top |
|
|
|
|
