Skip to main content
B
bikerboy
Participant
June 13, 2006
Answered

Which is better ODBC or JDBC

  • June 13, 2006
  • 3 replies
  • 488 views
dear all,
after upgrading most of our servers from cf5 to CFMX7.1, it is now time to start working on some performance strategies for the upgrades. currently we went with the ODBC connector in CFMX for testing purposes. one of our server will occasionally lose the odbc and we have to reboot the server to get it rolling again.

this leads up to the question of which is better for performace (speed, less process inducive) and realiability. ODBC or JDBC with CFMX7.1
thanx
sean
This topic has been closed for replies.
Correct answer SafariTECH
I would concur ... as CF is java based, it will run better with JDBC rather than having to interpret a bridge between the 2.

There are a couple of very remote instances where ODBC may be required, but you will have much better results with JDBC.

3 replies

B
bikerboyAuthor
Participant
June 14, 2006
thanx much, got some reading to do, but it looks like JDBC will be it. need to set the test server up with it.

thanx again
sean
S
SafariTECHCorrect answer
Inspiring
June 14, 2006
I would concur ... as CF is java based, it will run better with JDBC rather than having to interpret a bridge between the 2.

There are a couple of very remote instances where ODBC may be required, but you will have much better results with JDBC.
P
paross1
Participating Frequently
June 14, 2006
JDBC, no question.

Phil
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices