| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| JDBC vs ODBC |
« View previous topic :: View next topic » |
| Author |
Message
|
| pottas |
 Posted: Thu Dec 10, 2009 1:12 am Post subject: JDBC vs ODBC |
 |
|
Disciple
Joined: 27 Oct 2005
Posts: 185
Location: South Africa
|
Hi guys,
First of all, compliments of the season.
I had a discussion with one of my colleagues yesterday around using JDBC Type 4 Drivers as opposed to the ODBC Drivers.
We have projects running currently that uses DB2 and Oracle Databases with an ODBC connection. His idea is to change the ODBC connections to JDBC Connections.
Now I need to understand a few things:
1. Is ODBC slower than JDBC?
2. If going for the JDBC option, I guess all our ESQL Nodes will have to be changed to JavaCompute Nodes?
3. What would be the criteria to do a change like this? Performance? Maintainability? Project-specific defines?
My worry is that I am not the world's main authority on Java - so if we do the JDBC-thingie, all our existing Compute Nodes will have to be converted to Java.
I guess my question is - why would you want to go the JDBC route? |
|
| Back to top |
|
 |
| nathanw |
| Posted: Thu Dec 10, 2009 1:33 am Post subject: |
|
|
Knight
Joined: 14 Jul 2004
Posts: 550
|
I know it is not exactly what you are wanting but this is an interesting readon the comparison of JDBC and ODBC
http://forums.sun.com/thread.jspa?threadID=5360664
on the matter of your choice it is purely that, your choice. maybe a comparison between several connections should be ran over a period of time to enable a decision to be made
_________________
Who is General Failure and why is he reading my hard drive?
Artificial Intelligence stands no chance against Natural Stupidity.
Only the User Trace Speaks The Truth  |
|
| Back to top |
|
|
| pottas |
| Posted: Thu Dec 10, 2009 1:50 am Post subject: |
|
|
Disciple
Joined: 27 Oct 2005
Posts: 185
Location: South Africa
|
Thanks nathanw, appreciated.
I read throught the post you sent and it doesn't look like there is any significant difference between the two drivers.
My take on this is to stay with ODBC (according to me tested and proven), it would anyway be the least impact on the current development we have done already.
The challenge is to convince my cronies - and I don't think I really have a lot of proof yet... |
|
| Back to top |
|
|
| nathanw |
| Posted: Thu Dec 10, 2009 1:53 am Post subject: |
|
|
Knight
Joined: 14 Jul 2004
Posts: 550
|
The question that should be answered by both sides with convincing arguments is WHY
is this a case of personal preference?
is this a performance issue?
is this company policy?
the amount fo work involved not only on developing and chaning code but future supporting etc, could out weigh the benefits
I suppose like alot of things it is down to what is best for the environment, but then I am a "if it aint broke, don't fix it kind of guy!"
_________________
Who is General Failure and why is he reading my hard drive?
Artificial Intelligence stands no chance against Natural Stupidity.
Only the User Trace Speaks The Truth |
|
| 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
|
|
|
|
