ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Help In Database Retrive

Post new topic  Reply to topic
 Help In Database Retrive « View previous topic :: View next topic » 
Author Message
princedeepak
PostPosted: Sun Apr 28, 2013 8:17 pm    Post subject: Help In Database Retrive Reply with quote

Novice

Joined: 10 Apr 2013
Posts: 16

I have Selected Microsoft SQL Server for my DataSource Name

And When i try to add Query elements empty no tables are being displayed in the drop down menu.

Can anyone help me with the database retrive node...

Thanks for your answers for my previous queries ..
Back to top
View user's profile Send private message
exerk
PostPosted: Sun Apr 28, 2013 11:43 pm    Post subject: Reply with quote

Jedi Council

Joined: 02 Nov 2006
Posts: 6339

And just how is this related to WMQ? Are you asking in relation to XA?
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys.
Back to top
View user's profile Send private message
princedeepak
PostPosted: Mon Apr 29, 2013 12:35 am    Post subject: How to USE DATABASE NODE Reply with quote

Novice

Joined: 10 Apr 2013
Posts: 16

exerk wrote:
And just how is this related to WMQ? Are you asking in relation to XA?


Actually i am trying to get familiar with database nodes in, Websphere Message Broker....

Sorry for the Wrong Section...

Moderator can you move this please...
Back to top
View user's profile Send private message
exerk
PostPosted: Mon Apr 29, 2013 12:41 am    Post subject: Reply with quote

Jedi Council

Joined: 02 Nov 2006
Posts: 6339

Moved as requested...
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys.
Back to top
View user's profile Send private message
princedeepak
PostPosted: Mon Apr 29, 2013 1:16 am    Post subject: IS THERE AN OPTION TO CONNECT REMOTE DATABASE(DB2) Reply with quote

Novice

Joined: 10 Apr 2013
Posts: 16

Can anyone explain how to connect to the remote database (DB2) using Message Broker 8.

Thanks inadvance...
Back to top
View user's profile Send private message
smdavies99
PostPosted: Mon Apr 29, 2013 1:52 am    Post subject: Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

There are many similar questions in this forum. Have you looked at any of these?
What have you tried for yourself?
Have you been able to get the data with an ESQL compute node
Does the ODBC connection work?
Does using the 'mqsicvp' command work?

All of this information is available in the InfoCentre.

Please tell us what you have tried and what the results were. We are not here to do your job for you. And to anticipate one of my colleagues responses (unless he is at Impact this week),

Have you attended any of the training classes for this product?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
Back to top
View user's profile Send private message
princedeepak
PostPosted: Mon Apr 29, 2013 2:28 am    Post subject: Reply with quote

Novice

Joined: 10 Apr 2013
Posts: 16

smdavies99 wrote:
There are many similar questions in this forum. Have you looked at any of these?
What have you tried for yourself?
Have you been able to get the data with an ESQL compute node
Does the ODBC connection work?
Does using the 'mqsicvp' command work?

All of this information is available in the InfoCentre.

Please tell us what you have tried and what the results were. We are not here to do your job for you. And to anticipate one of my colleagues responses (unless he is at Impact this week),

Have you attended any of the training classes for this product?



Sorry, sir i just need to know how to connect with mssql server for db operations , and to work with db nodes in message broker. And i have done a search in this forum. none of those couldn't solve my issue...

Hope you understand.
Back to top
View user's profile Send private message
smdavies99
PostPosted: Mon Apr 29, 2013 2:35 am    Post subject: Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

Have you tried verifying the connection to the ODBC Database using the 'mqsicvp' command?

If you have not told broker about the ODBC connection using the 'mqsisetdbparms' command then you will need to use that first.

There are plenty of other posts on this forum relating to this. Please tell us what you have tried and if it fails, how it fails. So far you have not supplied any of this information.
We work on the principle of 'self-help' here. We are here to help you learn.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
Back to top
View user's profile Send private message
lancelotlinc
PostPosted: Mon Apr 29, 2013 3:14 am    Post subject: Reply with quote

Jedi Knight

Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA

DatabaseRetrieve node uses JDBC, not ODBC.

http://publib.boulder.ibm.com/infocenter/wmbhelp/v8r0m0/index.jsp?topic=%2Fcom.ibm.etools.mft.doc%2Fac37390_.htm

Even if ODBC has been set up properly, DatabaseRetrieve node will not work until JDBC drivers have been installed and configured.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER
Back to top
View user's profile Send private message Send e-mail
princedeepak
PostPosted: Tue Apr 30, 2013 2:34 am    Post subject: Need Clarification Reply with quote

Novice

Joined: 10 Apr 2013
Posts: 16

When i try a Db Query inside an ordinary Compute node.Message Broker does not show any warning.
That is..
[img]
[IMG]http://www1.picturepush.com/photo/a/12815969/640/12815969.bmp[/IMG]

And When i try to do the same with Database node it shows the following warning

[img]
[IMG]http://www1.picturepush.com/photo/a/12815959/img/12815959.bmp][/img]




Can someone give me an syntax to write the query inside a Database NOde
Back to top
View user's profile Send private message
lancelotlinc
PostPosted: Tue Apr 30, 2013 3:09 am    Post subject: Reply with quote

Jedi Knight

Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA

Database is one word, not two. The 'b' is not capitalized.

Examples are provided with the toolkit, in the InfoCentre, and in the required training class.

Have you attended the required training class?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER
Back to top
View user's profile Send private message Send e-mail
princedeepak
PostPosted: Sun May 05, 2013 8:03 pm    Post subject: "mqsisetdbparms" not set properly ? Reply with quote

Novice

Joined: 10 Apr 2013
Posts: 16

Sir i am trying to use the mqsisetdbparams to configure the datasource

and trying to verify it ... its shows success in first command but during

verification it shows error.

Quoted"C:\Program Files\IBM\MQSI\8.0.0.0>mqsisetdbparms Test -n TESTDB -u db2admin -p d
b2@admin
BIP8071I: Successful command completion.

C:\Program Files\IBM\MQSI\8.0.0.0>mqsicvp Test -n DBTEST
BIP8272E: Datasource 'DBTEST' has not been associated with broker 'Test'.
This invocation of the mqsicvp command requires that the datasource name has bee
n associated with the broker, using the mqsisetdbparms command.
Check that this datasource has been associated with the broker."
Back to top
View user's profile Send private message
smdavies99
PostPosted: Sun May 05, 2013 10:57 pm    Post subject: Re: "mqsisetdbparms" not set properly ? Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

princedeepak wrote:


Quoted"C:\Program Files\IBM\MQSI\8.0.0.0>mqsisetdbparms Test -n TESTDB -u db2admin -p d
b2@admin
BIP8071I: Successful command completion.

C:\Program Files\IBM\MQSI\8.0.0.0>mqsicvp Test -n DBTEST


Errr???

TESTDB != DBTEST
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
Back to top
View user's profile Send private message
princedeepak
PostPosted: Sun May 05, 2013 11:18 pm    Post subject: Reply with quote

Novice

Joined: 10 Apr 2013
Posts: 16

sorry for my silly post eariier , Thought the authentication details work fine externally its throwing the following error while testing using the mqsicvp

can some one help me with this, what have i done wrong in this setup command ?
tnx in advance

BIP2393E: Database error: ODBC return code '-1' from data source ''TESTDB'' usin
g ODBC driver manager ''odbc32.dll''.
The broker received an error when processing a database operation. The ODBC retu
rn code was '-1'. See the following messages for information obtained from the d
atabase about this error.
Use the following messages to determine the cause of the error. Typical problems
are an incorrect data source, or table names. Correct either the database or th
e broker configuration.
BIP2322E: Database error: SQL State ''IM002''; Native Error Code '0'; Error Text
''[Microsoft][ODBC Driver Manager] Data source name not found and no default dr
iver specified''.
The error has the following diagnostic information: SQL State ''
IM002'' SQL Native Error Code '0' SQL Error Text ''[Microsoft][OD
BC Driver Manager] Data source name not found and no default driver specified''

This message may be accompanied by other messages describing the effect on the m
essage broker itself. Use the reason identified in this message with the accomp
anying messages to determine the cause of the error.

BIP8040E: Unable to connect to the database.
Back to top
View user's profile Send private message
Vitor
PostPosted: Mon May 06, 2013 6:15 am    Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

princedeepak wrote:
can some one help me with this, what have i done wrong in this setup command ?


You've set up a database DSN that isn't accessable to the WMB or it's user.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Help In Database Retrive
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.