Explain the sequence of steps to connect to the database?
Answer Posted / william
An alternate, and preferred way, to using the DriverManager class is to use a DataSource object.
1. The data source is registered on the server side, which stores connection information, like: host, port, sid, credentials (optional), driver to use, etc.
2. The application gets a handle on the data source through a JNDI lookup.
3. The DataSource object is a connection factory and you can invoke .getConnection()
One of the reasons it is preferred over the DriverManager is because it is more flexible. The connection information is taken out of the code, therefore if changes need to be made - such as the machine the db resides on, the driver, etc - the application does not have to be recompiled and redeployed.
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is the use of the statement in jdbc?
Is uri the same as url?
Discuss the procedure of retrieving warnings?
What is JDBC Savepoint? How to use it?
How do we call a stored procedure from jdbc?
What is jdbc odbc connection?
DB2 Universal claims to support JDBC 2.0, But I can only get JDBC 1.0 functionality. What can I do?
What does connection pooling mean ?
How many types of resultset are there in jdbc?
What is correlated subquery?
How do I insert/update records with some of the columns having NULL value?
What is jdbc and jdbc drivers?
What is the difference between jdbc and jndi?
What are temp tables ?
How to use JDBC API to call Stored Procedures?