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
How can you make the connection using jdbc?
What are temp tables ?
How can you know about drivers and database information ?
What do you understand by jdbc driver and explain its types?
Which Java and java.sql data types map to my specific database types?
Is jdbc connection secure?
Why do we need jdbc api?
How we can you use preparedstatement.
Why can't Tomcat find my Oracle JDBC drivers in classes111.zip?
Explain the locking system in jdbc?
What are the components of jdbc?
Explain the necessary steps to connect to the database in java?
What are the conditions applies to varchar variable, when using in procedures?
How can we execute stored procedures?
Write a program JDBCcode forfetching student database with SQL.