Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

not-odbc connection

 
Max Nordio
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I have few questions about db connenction in win32.
I'd like to use a native driver to connect to a mysql database instead of using the odbc driver. What are the advantages and the drawbacks of using native drivers instead of odbc drivers? Could I have problems of syncronizing the accessing to the db using the native drivers?
And if I used a pool connection? What kind of problems could I have?
Eventually, what is the best win32-gui for mysql?
Thank you,
Max.
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
here are the basics, although you might already know this stuff
http://java.sun.com/products/jdbc/driverdesc.html
In general, every driver has its strengths and weaknesses. Just because it is a native driver doesn't mean that it will have limitations(except that usually they are database vendor specific). Usually native drivers are faster and offer a fuller range of features, but again that is specific to the driver itself. The type 4 drivers I've been using have worked seamlessly for all my java needs (for Oracle).
Jamie
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!