| Author |
Message
|
| nemesis |
 Posted: Fri Oct 12, 2012 12:40 am Post subject: WebSphere Adapter |
 |
|
Newbie
Joined: 10 Jan 2007
Posts: 4
|
Hi,
Is there any specific advantage of using WebSphere Adapter for JDBC instead of using the built-in nodes in WMB for database interaction ? Does the JDBC adapter perform better as compared to the nodes (in WMB 7 and above) particularly when the number of database transaction is huge ?
Any insight on this would be appreciated.
Thanks. |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Fri Oct 12, 2012 3:51 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
well, if we're talking about high volume, I have a tendency of pushing DB connectivity off the broker into a J2EE environment reading from a queue with and MDB. Advantage: the DB and the broker flow now scale independently.
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Oct 12, 2012 4:16 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| The DatabaseInput node *is* the WebSphere Adapter. |
|
| Back to top |
|
|
| mgk |
| Posted: Fri Oct 12, 2012 6:03 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
| Quote: |
| The DatabaseInput node *is* the WebSphere Adapter. |
No it's not! The DBInput node uses ESQL to access the DB and is ODBC only...
Kind regards,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| mqsiuser |
| Posted: Fri Oct 12, 2012 6:25 am Post subject: Re: WebSphere Adapter |
|
|
Yatiri
Joined: 15 Apr 2008
Posts: 637
Location: Germany
|
| nemesis wrote: |
Is there any specific advantage of using WebSphere Adapter for JDBC instead of using the built-in nodes in WMB for database interaction ?
[...]
Any insight on this would be appreciated. |
An important reason why you would use a (standalone - one without Message Broker) Adapter is that you need to retrieve data remotely (remote to a/the Broker): You want a reliable QMGR to QMGR connection (through the network (distance)). So 2 QMGRs: One with Broker (e.g. centrally in your companies head office) and one (or some/many) with just (we used the WBI-Adapter-Framework) an "Adapter" (without a Msg-Broker) (e.g. decentrally in your companies subsideries... e.g. distributed worldwide).
So: (probably) you cannot install a broker everywhere... so you "just" install e.g. the WBI-adapters framework. Which adapter do you use?
Though afaikr there is the possibility to deploy/install msg-broker "like an adapter" / a reduced version "in adapter mode" since version 7(?).
I'd always prefer to use broker to access a DB (over (installing and configuring) the WBI-Adapter-Framework). But for reliability reason the DB you are accessing should/must be near... probably don't access a (remote) DB, where your JDBC or ODBC has to go through some network hops.
_________________
Just use REFERENCEs |
|
| Back to top |
|
|
| nemesis |
| Posted: Mon Oct 15, 2012 12:47 am Post subject: |
|
|
Newbie
Joined: 10 Jan 2007
Posts: 4
|
| Thanks a lot for your inputs. That helps learning some of the finer details. |
|
| Back to top |
|
|
|
|
