| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| DB connectivity |
« View previous topic :: View next topic » |
| Author |
Message
|
| smdavies99 |
 Posted: Wed Jul 29, 2015 9:54 pm Post subject: |
 |
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
But the OP has suggested that this is all done via a WebService.
So transactionality goes right out of the window pretty much right from the word go.
This all seems like some of the 'Requirements' we get posted here from time to time. Some of these are clearly dreamed up by people who might have had exposure to Broker back when it was a mere shadow of what it is today. (I am being generous here)
The general concensus from those who frequent this place that this way of doing DB access is wrong and outmoded. That said, if that is the only way they have of doing it then and because it might be a 'Jobsworth'[1] who can't be shown up then it might be time for a Gallic Shrug and just getting on with it.
For those who don't know.
[1] Jobsworth means basically someone saying 'It is more than my job is worth to let you do that' when they stop you doing something totally logical. Usually said by some low ranking civil servant (or local gov) employee, security guard etc etc.
_________________
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 |
|
 |
| akil |
| Posted: Wed Jul 29, 2015 11:28 pm Post subject: |
|
|
Partisan
Joined: 27 May 2014
Posts: 338
Location: Mumbai
|
In cases where the database interactions are complex (not supported via the database retrieve, mapping nodes), and a preference to use Java instead of ESQl, the choice comes down to using a JCN v/s and MDB... I think in such cases MDB wins ..
_________________
Regards |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Jul 30, 2015 4:35 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
This whole question reminds me of an attitude expressed by a long-ago poster, who found himself in a position of being asked to leave the forum..
In making any kind of real decision between WAS and IIB, I'd really want to run performance comparisons - including resource utilization on the DB.
Also, the thread pool for JDBC is entirely different for the thread pool for ESQL in broker. Unless you use the java functions to use the ODBC connection.
So in general, they are entirely different things. |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Jul 30, 2015 5:03 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mqjeff wrote: |
| In making any kind of real decision between WAS and IIB, I'd really want to run performance comparisons - including resource utilization on the DB. |
I'd certainly, were I to find myself on the kind of site the OP describes, want to take a fairly deep dive into why the site wanted it done like that.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
|
|
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
|
|
|
|
