wood burning stoves 2.0*
The moose likes JDBC and the fly likes new to jdbc Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "new to jdbc" Watch "new to jdbc" New topic
Author

new to jdbc

Weronpc
Greenhorn

Joined: Jun 12, 2004
Posts: 26
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 );


1 + 1 = 10
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336


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]".


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30116
    
150

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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: new to jdbc
 
Similar Threads
mysql JDBC driver
JDBC driver
Informix JDBC, setQueryTimeout
some confusions about jdbc...
Do you need a DSN when using JDBC