| Author |
Message
|
| alerajeshh |
 Posted: Tue Sep 24, 2013 7:30 am Post subject: ODBC & JDBC |
 |
|
Acolyte
Joined: 19 Aug 2013
Posts: 55
|
ODBC & JDBC
1) When to use JDBC and when to use ODBC?
If you are using any .esql in message flow then you have to create ODBC (System DSN) for connecting to the database.
If you are using other than .esql in message flows then you have to create JDBC Type 4 Configurable Service
2) For Updating database Table?
We can update the database table using
Compute -ODBC
Java Compute-JDBC (if you are using MbSQL stmt in code use ODBC)
Database Node- ODBC
3) For Database Retrieval?
Compute-Compute
Java Compute- JDBC (if you are using MbSQL stmt in code use ODBC)
Database Nodes other than Database Node ( I mean Database Retrieve ,Database Route)—JDBC
4) What is ODBC Connection?
For ODBC we need to create System DSN, and mention the System DSN name in the properties of Compute and Database Node.
5) What is JDBC Connection?
For JDBC we need to create JDBC Type4 Configurable Service.
There are two ways of creating configurable service.
a) Through commands
b) Using MQ-Explorer
For Database Retrieve, Database Route Nodes mention the JDBC Type4 configurable service name in the properties tab.
For Java Compute Node we need to set up in the code.
Class.forName("com.ibm.db2.jcc.DB2Driver");
Connection conn =getJDBCType4Connection("xxxxx",DBC_TransactionType.MB_TRANSACTION_AUTO);
Depending on the database type select the respective driver.
please correct me if am wrong...
Thank you |
|
| Back to top |
|
 |
| Simbu |
| Posted: Tue Sep 24, 2013 7:48 am Post subject: |
|
|
Master
Joined: 17 Jun 2011
Posts: 289
Location: Tamil Nadu, India
|
| Mapping node is missing here which uses JDBC. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Tue Sep 24, 2013 9:21 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| Simbu wrote: |
| Mapping node is missing here which uses JDBC. |
What about the ESQL functions that can be called from the Mapping Node?
_________________
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 |
|
|
| Simbu |
| Posted: Tue Sep 24, 2013 10:55 pm Post subject: |
|
|
Master
Joined: 17 Jun 2011
Posts: 289
Location: Tamil Nadu, India
|
| smdavies99 wrote: |
| Simbu wrote: |
| Mapping node is missing here which uses JDBC. |
What about the ESQL functions that can be called from the Mapping Node? |
Thanks, we can use ODBC in this way in Mapping Node but I presumed that "alerajeshh" refereed only the direct interaction with ODBC or JDBC from the node. |
|
| Back to top |
|
|
| McueMart |
| Posted: Wed Sep 25, 2013 4:11 am Post subject: |
|
|
Chevalier
Joined: 29 Nov 2011
Posts: 490
Location: UK...somewhere
|
| Im not sure what the exact purpose of the post was. But if you are posting general information about ODBC and JDBC, then you missed the important information out pertaining to mqsisetdbparms and mqsicvp (i.e. what they are used for). |
|
| Back to top |
|
|
|
|
