Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

new to jdbc

 
Weronpc
Greenhorn
Posts: 26
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am learning JDBC, when I am using java and want to connect to different database, do I have to download different database driver when I use different types of database?

If I am using MS SQL or MySQL, how do I know the JDBC driver name? Also the URL as well..
Class.forName( JDBC_Driver);
DriverManager.getConnection( Database_URL );
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

do I have to download different database driver when I use different types of database?

Yes.


If I am using MS SQL or MySQL, how do I know the JDBC driver name?

Drivers usually come with a "how to" example at the very least. If you want the driver for a particular DB the best way to find one is by googling for "JDBC driver for [database_name]".
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33696
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Mike,
That information would be in the database documentation. Alternatively, you can find it on google. For example, a university writes up how to use mySql in great depth. The information you are looking for is on that page.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic