Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the sequence of steps to connect to the database?
- 3 Answers
- 11167 Views
- Wipro, I also Faced
- E-Mail Answers
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 purpose of jdbc?
Explain what should be done when a SQL exception is raised?
Briefly tell about the jdbc architecture.
How do I retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX method for each column?
DB2 Universal claims to support JDBC 2.0, But I can only get JDBC 1.0 functionality. What can I do?
What is use of connection pooling?
How to know howmuch data is truncated?
What is the use of JDBC DriverManager class?
Can I use JDBC to execute non-standard features that my DBMS provides?
What is jdbc connection interface?
What is the execute method in java?
What is jdbc and why is it required?
How java can be connected to a database?
What is jdbc driver manager?
What causes the "No suitable driver" error?
