What are the steps in connecting to database?
Answer Posted / sanket pandit
An alternate, and preferred way, to using the DriverManager class is to use a DataSource object.
This is for SQ L Ans.
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 in
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can we load multiple tables in to dataset?
What is the use of data grid?
What is oledb connection?
What is the difference between Optimistic and Pessimistic locking?
What is openquery?
What is microsoft ole db provider for sql server?
What is the full form of ado.net?
What is ado data control?
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?
What is bubbled event?
Define table relations?
What is difference between executenonquery and executequery?
What is the difference between Response.Expires and Reponse.ExpiresAbsolute?
What is datasource in ado.net?
What is ado.net code?