| Author |
Message
|
| sunny2310 |
 Posted: Mon Jul 07, 2014 5:24 pm Post subject: ODBC/JDBC connections in WMB :help: |
 |
|
Newbie
Joined: 15 Aug 2012
Posts: 9
|
Hi Guys,
I am fairly new to WMB. I need to the Difference between the JDBC and ODBC connections in WMB, Wen to use what, Pros and Cons of Each,
Any pointers would be appreciated,
Thanks in Advance,
Sunny |
|
| Back to top |
|
 |
| ruimadaleno |
| Posted: Tue Jul 08, 2014 1:23 am Post subject: |
|
|
Master
Joined: 08 May 2014
Posts: 274
|
Hy sunny,
please pay attention to the manual/infocenter documents, have in mind that not all nodes support the usage of JDBC datasource.
_________________
Best regards
Rui Madaleno |
|
| Back to top |
|
|
| MB Developer |
| Posted: Tue Jul 08, 2014 7:45 pm Post subject: |
|
|
Disciple
Joined: 03 Feb 2014
Posts: 179
|
Hi sunny,
JAVA Compute node --- JDBC Connection
Compute node ---- ODBC Connection
For more find in infocenter
_________________
Thanks.... |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Tue Jul 08, 2014 9:40 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| MB Developer wrote: |
Hi sunny,
JAVA Compute node --- JDBC Connection
Compute node ---- ODBC Connection
For more find in infocenter |
Is that the complete picture?
Perhaps you would like to revise the list of nodes that can use a JDBC Connection for the benefit of everyone.
_________________
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 |
|
|
| alerajeshh |
| Posted: Thu Jul 10, 2014 10:46 am Post subject: |
|
|
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 |
|
|
| mqjeff |
| Posted: Thu Jul 10, 2014 11:58 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
|
| Back to top |
|
|
| alerajeshh |
| Posted: Thu Jul 10, 2014 12:06 pm Post subject: |
|
|
Acolyte
Joined: 19 Aug 2013
Posts: 55
|
| can you please enlighten me ..... |
|
| Back to top |
|
|
|
|
