File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes interview question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "interview question" Watch "interview question" New topic
Author

interview question

Jackie Wang
Ranch Hand

Joined: Apr 18, 2002
Posts: 315
How can I get the JDBC connection?
Any suggestion for this question's answer?
Thanks!
Dave Vick
Ranch Hand

Joined: May 10, 2001
Posts: 3244
Jackie
After you register the driver then you use the getConnection method of the Driver class to get a connection to the database. i.e.
Connection conn = DriverManager.getConnection( url, "userID", "passwd");
Is that what you were looking for?


Dave
Jackie Wang
Ranch Hand

Joined: Apr 18, 2002
Posts: 315
thx for the prompt reply.
Yup, that's what i ask for.
However, any information which I can "register" the driver?
Thanks!
Irene Loos
Ranch Hand

Joined: Apr 15, 2002
Posts: 78
Check API for more info but shortly:

Interface java.sql.Driver
public abstract interface Driver
The interface that every driver class must implement.
The Java SQL framework allows for multiple database drivers.
Each driver should supply a class that implements the Driver interface.
The DriverManager will try to load as many drivers as it can find and then for any given connection request, it will ask each driver in turn to try to connect to the target URL.
It is strongly recommended that each Driver class should be small and standalone so that the Driver class can be loaded and queried without bringing in vast quantities of supporting code.
When a Driver class is loaded, it should create an instance of itself and register it with the DriverManager. This means that a user can load and register a driver by calling
Class.forName("foo.bah.Driver")


registerDriver
public static synchronized void registerDriver(Driver driver) throws SQLException
Registers the given driver with the DriverManager. A newly-loaded driver class should call the method registerDriver to make itself known to the DriverManager.
Parameters:
driver - the new JDBC Driver that is to be registered with the DriverManager
Throws: SQLException
if a database access error occurs


Irene Loos
Ta Ri Ki Sun
Ranch Hand

Joined: Mar 26, 2002
Posts: 442
try this, by the way, the url, "SMSMySQL" , is your data source name, change it to whatever you configured yours to be

Ta Ri Ki Sun
Ranch Hand

Joined: Mar 26, 2002
Posts: 442
sorry, forgot to disable smilies.
replace that url with this, if appropriate of course.
jdbcdbc:SMSMySQL
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: interview question