Explain the sequence of steps to connect to the database?
Answers were Sorted based on User's Feedback
Answer / devarathnam c,kotagudibanda(po
Hi... These are the steps to connecting to the database
1: Loading the drivers
2:Get the connection
3:Create the statement
4:Execute the query
5:Process the resultset
6:Close the connection
Is This Answer Correct ? | 18 Yes | 0 No |
Answer / v.kannan
1.Register the Driver
2.Mention the Database Name
3.get the Connection through Driver Manager
4.send the Sql Query
5.get the result through ResultSet
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / 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 |
What port does jdbc use?
What is serialization and deserialization in java programming?
What is JDBC Statement?
What is the limitation of PreparedStatement and how to overcome it?
please tell me the name and url path for type-4 driver ?
what are design patterns?
Is it possible to connect to multiple databases? Using single statement can we update or extract data from two or three or many databases?
How can I use the JDBC API to access a desktop database like Microsoft Access over the network?
How to check jdbc driver version in websphere?
What is the query used to display all tables names in SQL Server (Query analyzer)?
Which database is used with java?
What is jdbc and its types?