MQSeries.net :: View topic - Do I need an JDBC adapter?

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Do I need an JDBC adapter?

Do I need an JDBC adapter?

« View previous topic :: View next topic »

Author

Message

Seagull

Posted: Thu Jun 26, 2008 8:18 am Post subject: Do I need an JDBC adapter?

Novice

Joined: 05 Feb 2007
Posts: 11

I need some help in doing a database insert.There is an existing stored procedure already to insert on the server.

All I need to do is call from the broker(esql) and pass the incoming xml as string.

A call statement from an compute node to the storep proc..on a db server will work for me or do I need a JDBC adapter to do this?

Even for retreival and updates there are stored procs on server in this case for implementing an update/retrieve do we need adapter?

WMB V6.1 is in usage.

Thanks.

vsr

Posted: Thu Jun 26, 2008 8:57 am Post subject:

Centurion

Joined: 04 Apr 2006
Posts: 104

It depends on your architecture, how your system is designed. If your architect decides to use WMB as an ESB to make the calls then use broker flows otherwise use adaptor.

If you have already purchased/using WMB and didn't have adaptor, I prefer using broker to achieve the goal. If I were you I would talk to the architect first.

broker_new

Posted: Thu Jun 26, 2008 2:07 pm Post subject:

Yatiri

Joined: 30 Nov 2006
Posts: 614
Location: Washington DC

I assume that you are using Broker as an ESB.
try to avoid the adapters as much as possible because if you consider the maintenance wise Broker is easy to maintain compared to JDBC adapter.
if it is an Adapter you need the Adapter framework to be installed on the same server...e.t.c...We had tough time with adapters and implemented everything in Broker....Offcourse Broker is the Powerful ESB in the market.

Seagull

Posted: Fri Jun 27, 2008 5:40 am Post subject: Yes as an ESB..

Novice

Joined: 05 Feb 2007
Posts: 11

Yes . We are planning to use it as ESB.Till now we do not have any adapters.

I am being asked on if we can achieve without the adapter and if so a call from esql to these stored procs by passing xml string would do the job or not?

So if it is how I have to approach then let me know or if there is some other way of acheiving it..please put your thoughts here.

Thanks for the information.

Maximreality

Posted: Mon Jun 30, 2008 4:08 am Post subject: Re: Yes as an ESB..

Acolyte

Joined: 04 Jun 2004
Posts: 65
Location: Copenhagen

You can call stored procedures from the broker, so if that is your only requirement i would not buy the JDBC adapter.

But make a poc and verify that the broker meet your requirements

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Do I need an JDBC adapter?

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