| Author |
Message
|
| javamaverik |
 Posted: Thu Feb 17, 2011 4:36 am Post subject: Can't find the datasource name while configuring in DBNode |
 |
|
Newbie
Joined: 25 Jan 2010
Posts: 3
|
Hi All,
I could not find the DataSource Name in DatabaseRetrival Node
The JDBC Provider name which i have configured using mqsicreateconfigurableservice.
Since two days i am bashing my head to find the solution
Please help |
|
| Back to top |
|
 |
| fatherjack |
| Posted: Thu Feb 17, 2011 4:57 am Post subject: Re: Can't find the datasource name while configuring in DBNo |
|
|
Knight
Joined: 14 Apr 2010
Posts: 522
Location: Craggy Island
|
| javamaverik wrote: |
Hi All,
I could not find the DataSource Name in DatabaseRetrival Node
The JDBC Provider name which i have configured using mqsicreateconfigurableservice.
Since two days i am bashing my head to find the solution
Please help |
Where did you look?
_________________
Never let the facts get in the way of a good theory. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Feb 17, 2011 7:03 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
The Toolkit knows nothing about any configurations made on the runtime.
The Message Flow Editor only knows about Eclipse level projects - like, for example, Data projects. |
|
| Back to top |
|
|
| javamaverik |
| Posted: Thu Feb 17, 2011 7:36 pm Post subject: Thnx for replying the prob is |
|
|
Newbie
Joined: 25 Jan 2010
Posts: 3
|
First of all thnx to all for replying..
I am a java developer recently i started working on WMB 6.1.
i was doing some samples given in product documentation of WMB. In which i am working with SimpleMessagingRouting Eg after configuring the db with mqsiconfigureproperties command as given and import the sample it showing the datasource name in properties of DatabaseRetreive Node,
but the problem comes when i want to do sample on my own by creating a a new project and try to see the datasource name in databaseretrieve node It is not at all displaying.
please let me know how to configure the datasource name for nodes such as DatabaseRetrievalNode or DatabaseRoute Node in their properties to compile the expression for selecting the data and routing.
Thnx in Advance.... |
|
| Back to top |
|
|
| fatherjack |
| Posted: Fri Feb 18, 2011 12:38 am Post subject: |
|
|
Knight
Joined: 14 Apr 2010
Posts: 522
Location: Craggy Island
|
Just enter a data source name in the data source name field in the properties of the database node. Then configure the ODBC ini file to point this data source name to your database alias (see "configuring databases" in the inforcenter.)
_________________
Never let the facts get in the way of a good theory. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Feb 18, 2011 2:10 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You have to create a Data project that points to the JDBC database.
Then you need to mark this project as a referenced project on the message flow project.
Then you will get a popup for the DatabaseRetrieve node.
As mentioned, though, this has nothing to do with the runtime behavior. If you want to just use the provider you've already configured in runtime, JUST TYPE THE NAME INTO THE BOX. |
|
| Back to top |
|
|
| javamaverik |
| Posted: Sun Feb 20, 2011 8:35 pm Post subject: Thanx a lot !!! |
|
|
Newbie
Joined: 25 Jan 2010
Posts: 3
|
Dear All,
Thanks a lot for your quick reply i got it correctly this time. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sun Feb 20, 2011 11:21 pm Post subject: Re: Thnx for replying the prob is |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| javamaverik wrote: |
First of all thnx to all for replying..
I am a java developer recently i started working on WMB 6.1.
i was doing some samples given in product documentation of WMB. In which i am working with SimpleMessagingRouting Eg after configuring the db with mqsiconfigureproperties command as given and import the sample it showing the datasource name in properties of DatabaseRetreive Node,
but the problem comes when i want to do sample on my own by creating a a new project and try to see the datasource name in databaseretrieve node It is not at all displaying.
please let me know how to configure the datasource name for nodes such as DatabaseRetrievalNode or DatabaseRoute Node in their properties to compile the expression for selecting the data and routing.
Thnx in Advance.... |
As a new java developer on broker and maybe an oldtime java developer, let us give you a few pointers:
- Don't do any XML parsing in your Java code. Let the broker do the parsing for you...
- Intellectually compare the MbElement to the node you would look at in the XML Domain document
- Take advantage of the "on demand parsing" that the broker offers
- Work with the "message tree"
- Realize that a skilled XML java developer learning the broker is at a disadvantage as he has to relearn how to do most of that stuff the "right" way with WMB.
- Realize that there are things for which the Java compute node may be less suitable than another node (XSLT, ESQL, PHP, JSON, etc...)
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
