| Author |
Message
|
| nize |
 Posted: Thu Aug 12, 2010 12:08 am Post subject: WMB user database support |
 |
|
Voyager
Joined: 02 Sep 2009
Posts: 90
|
Hi,
I need to have a flow making queries to a DB provider called OpenRDA (or OpenAccess) ATS. JDBC (not type 4) and ODBC drivers are provided by the database provider. This database is not in the list of supported databases for neither WMB 6.1 nor WMB 7.0.
How would I solve this? At the moment we solve the problem by having an application implemented in Java, transforming a JMS request to a SQL/JDBC request and then back as JMS to the requester. This is complex and therefore I wonder if there is an alternative solution.
Thanks. |
|
| Back to top |
|
 |
| saurabh867 |
| Posted: Thu Aug 12, 2010 12:22 am Post subject: |
|
|
Voyager
Joined: 13 Jun 2010
Posts: 78
|
I think you can use JCN and perform the same steps you have done with the developed java application.
Regards,
Saurabh |
|
| Back to top |
|
|
| nize |
| Posted: Thu Aug 12, 2010 12:42 am Post subject: |
|
|
Voyager
Joined: 02 Sep 2009
Posts: 90
|
| Yes, a JavaCompute node, thats a good suggestion, which would decrease the complexity somewhat (e.g. sharing runtime processes). However, this would not give me the automatic connection and transaction handling which I would get using ODBC or "JDBC type 4". Would there be any other differences? |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Aug 12, 2010 2:00 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
In FixPack 1 of version 7, Broker ships with the Message Broker Database Extender that may allow you to use ODBC to connect to this database.
it's also available as standalone download as supportPac IE02, but still only works with 7.0.0.1. |
|
| Back to top |
|
|
| mqmatt |
| Posted: Thu Aug 12, 2010 3:19 am Post subject: |
|
|
Grand Master
Joined: 04 Aug 2004
Posts: 1213
Location: Hursley, UK
|
The Database Extender has currently only been tested with SolidDB.
Please let us know (e.g. update this thread) if if you get it to work with OpenRDA. |
|
| Back to top |
|
|
| nize |
| Posted: Thu Aug 12, 2010 3:37 am Post subject: |
|
|
Voyager
Joined: 02 Sep 2009
Posts: 90
|
Yes, I saw that Database Extender (DE) was there, but only supporting SolidDB.
Unfortunately I have no lab environment with WMB 7. Would be nice if IBM provided such in the cloud  .
I am not very familiar with DE. Is there any specific reason to why it would work? |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Aug 12, 2010 4:23 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
If there's a unixODBC driver for OpenRDA then it will likely work with the MB Database Extender, since the MBDE is aimed at supporting that project.
SolidDB is the only thing that has been tested, apparently.
If you're not at version 7, then this is entirely irrelevant. The only supported option is to use JDBC.
The fact that an option is unsupported doesn't mean it won't function. It just means that it exposes you to additional risk. |
|
| Back to top |
|
|
|
|
