Posted: Sat Apr 02, 2016 2:25 pm Post subject: Why do few database nodes support odbc and few jdbc ?
Novice
Joined: 26 Mar 2016 Posts: 19
Hi, I am looking to understand as to why Database and DatabaseInput Nodes work with ODBC connection whereas the DatabaseRoute and DatabaseRetrieve Nodes need JDBC connnection. Why is this difference and why not all database nodes work with either ODBC or JDBC ?
Joined: 10 Feb 2003 Posts: 6076 Location: Somewhere over the Rainbow this side of Never-never land.
The only people who can answer that are inside IBM. Any guesses made by those of us who don't work for IBM would be pure speculation and not worth a bent penny. _________________ 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.
Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA
smdavies99 wrote:
The only people who can answer that are inside IBM. Any guesses made by those of us who don't work for IBM would be pure speculation and not worth a bent penny.
My guess (worth exactly the value put on it by my associate) is that some nodes (of an older vintage) are part of the IIB C++ runtime and therefore use ODBC while others (of a more modern persuasion) execute within the JVM and hence use JDBC. _________________ Honesty is the best policy.
Insanity is the best defence.
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