File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes not-odbc connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "not-odbc connection" Watch "not-odbc connection" New topic

not-odbc connection

Max Nordio

Joined: Jul 27, 2001
Posts: 5
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,
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

here are the basics, although you might already know this stuff
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).
I agree. Here's the link:
subject: not-odbc connection
jQuery in Action, 3rd edition