| Author |
Message
|
| basva |
 Posted: Tue Oct 05, 2004 11:59 am Post subject: SQL Driver for WMQI broker in AIX |
 |
|
Apprentice
Joined: 27 Nov 2002
Posts: 39
|
Hi
Does anyone know whether there is a ODBC driver for SQL database for MQSI broker running in AIX environment?
Thanks
Satish |
|
| Back to top |
|
 |
| kirani |
| Posted: Tue Oct 05, 2004 12:10 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
I dont think its currently available.
DataDirect was planning on building one ...
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| maxis |
| Posted: Mon Oct 25, 2004 3:49 am Post subject: |
|
|
Centurion
Joined: 25 Jun 2002
Posts: 144
|
| does that mean .... broker running aix cannt query SQL server ? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Oct 25, 2004 4:47 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Yes. You can't talk to a Microsoft specific database from a non-Microsoft product.
Surprise!
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| SixBlade |
| Posted: Mon Nov 15, 2004 2:00 am Post subject: |
|
|
Apprentice
Joined: 03 Dec 2003
Posts: 26
Location: UK
|
|
| Back to top |
|
|
| psn |
| Posted: Mon Nov 15, 2004 6:00 am Post subject: |
|
|
Disciple
Joined: 30 Oct 2002
Posts: 193
Location: France
|
What you need on the Broker is an ODBC Driver , not an JDBC Driver !
PSN |
|
| Back to top |
|
|
| EddieA |
| Posted: Mon Nov 15, 2004 10:15 am Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
Maybe it's time to look at the "new" External Java Methods introduced by FixPac 4. As long as this doesn't cause a problem:
| Quote: |
| Only JDBC type 4 database connections are permitted. |
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| SixBlade |
| Posted: Wed Nov 17, 2004 5:49 am Post subject: |
|
|
Apprentice
Joined: 03 Dec 2003
Posts: 26
Location: UK
|
psn,
I know the broker needs ODBC data sources for the Compute and database nodes. It seemed to me like DataDirect had drivers for MSSQL and AIX. For the JDBC case: you can write a custom Java plugin node and use JDBC there, works fine(just did that). _If_ you find this cheaper/easier/better than byuing the 3rd party driver and using Compute/Database nodes. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Nov 17, 2004 5:59 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| SixBlade wrote: |
| you can write a custom Java plugin node and use JDBC there, works fine(just did that). |
I thought it was documented best practice to only use the WBIMB API database functions, as use of JDBC might interfere with the normal transaction handling of the broker?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| SixBlade |
| Posted: Wed Nov 17, 2004 7:05 am Post subject: |
|
|
Apprentice
Joined: 03 Dec 2003
Posts: 26
Location: UK
|
jefflowrey,
an very important aspect.
Regarding transactions, the JDBC Java node is not 1 with the message flow, so especially if running a transaction updating several databases this approach is not the best one. This is not often the case in "my" current environment.
Btw, I found the following information in the WBIMB help, "Coordinated message flows":
"You must use DB2, Oracle, or Sybase databases if you want globally-coordinated message flows. "
Unfortunately, I have not looked into these global transactions from the broker much yet (uses XA, in Oracle that requires Java enabled, it's not here....), but I guess you're on own anyway using MSSQL, currently anyway?
Either way, this is an important aspect,....haven't looked into if you can listen for "global commit" in a plugin node....(?).. |
|
| Back to top |
|
|
|
|
