Monday, February 12, 2007

Java database interview questions

Java database interview questions

What is the normal procedure followed by a java client to access the db.?

The database connection is created in 3 steps:
1. Find a proper database URL
2. Load the database driver
3. Ask the Java DriverManager class to open a connection to your database

In java code, the steps are realized in code as follows:
1. Create a properly formatted JDBR URL for your database. (See FAQ on JDBC URL for more information). A JDBC URL has the form
jdbc:someSubProtocol://myDatabaseServer/theDatabaseName
2. Class.forName(�my.database.driver�);
3. Connection conn = DriverManager.getConnection(�a.JDBC.URL�, �databaseLogin�,�databasePassword�)

more ....

No comments: