aspose file tools*
The moose likes JDBC and the fly likes not-odbc connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "not-odbc connection" Watch "not-odbc connection" New topic
Author

not-odbc connection

Max Nordio
Greenhorn

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

Joined: Jul 09, 2001
Posts: 1879

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: not-odbc connection