| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Accessing Database using JavaCompute JDBC Drivers |
« View previous topic :: View next topic » |
| Author |
Message
|
| Kumar4 |
 Posted: Tue Sep 25, 2007 8:25 am Post subject: Accessing Database using JavaCompute JDBC Drivers |
 |
|
Apprentice
Joined: 12 Aug 2007
Posts: 27
|
Hi,
I'm testing a flow where I can access database using JDBC Drivers thru JavaCompute Node,how can I specify the driver, database information using JavaCompute Node and also a sample code where I can use just a SELECT statement to get the record info from DB?
Thanks |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue Sep 25, 2007 8:34 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You write Java code to do this.
There isn't any Broker specific support for JDBC - either in developing Flows or in the MB Java API.
There's no difference between running JDBC in Broker than in running it in a standalone java program or in a J2EE app server.
You really should not be doing this unless you absolutely have to. The Broker ODBC database functions are significantly more user friendly and manageable. If you need to call these functions from a JavaCompute node, you can use the MbSqlStatement class.
I don't think anyone here is going to help you learn JDBC.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Kumar4 |
| Posted: Tue Sep 25, 2007 9:57 am Post subject: |
|
|
Apprentice
Joined: 12 Aug 2007
Posts: 27
|
I know about JDBC.
Wondering whether the ODBC connection can work for Linux?
I'm connecting to Oracle DB from Linux
Thanks |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Sep 25, 2007 10:01 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
The only Linux that does not support ODBC connections to Oracle databases from Message Broker v6.0.x is zLinux.
If you are working on Message Broker v6.0.x, and deploying to zLinux and you need to use Oracle databases... then you *have* to use JDBC.
If you are using message broker on any other Linux other than zLinux, you should be fine.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
