How to handle when the database crashes while reading the
data from the database?
Answers were Sorted based on User's Feedback
Answer / deepti agrawal
We write the JDBC code in the try & catch block. So if the
database crashes it will return some kind of exception
which can be handled through the code.
| Is This Answer Correct ? | 11 Yes | 0 No |
dear friends I have made connection with SQLSERVER where the following code is compiling properly but giving error at the runtime . I think error in this line where i am sending the value through string Connection connection = DriverManager.getConnection ( "jdbc:microsoft:sqlserver://localhost:1433","sa",""); import java.sql.*; //import mssqlserver.*; public class TestSQLCON { public TestSQLCON() throws Exception { // Get connection DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver()); System.out.println(); System.out.println("Successfully connected one"); System.out.println(); Connection connection = DriverManager.getConnection ( "jdbc:microsoft:sqlserver://localhost:1433","sa",""); if (connection != null) { System.out.println(); System.out.println("Successfully connected"); System.out.println(); // Meta data DatabaseMetaData meta = connection.getMetaData(); System.out.println("\nDriver Information"); System.out.println("Driver Name: " + meta.getDriverName()); System.out.println("Driver Version: " + meta.getDriverVersion()); System.out.println("\nDatabase Information "); System.out.println("Database Name: " + meta.getDatabaseProductName()); System.out.println("Database Version: "+ meta.getDatabaseProductVersion()); } } public static void main (String args[]) throws Exception { TestSQLCON test = new TestSQLCON(); } } so please help me
What are the Normalization Rules?
What is meant by dao?
how to prevent finally block from execution
What are the jdbc statements?
What does it mean to "materialize" data?
Explain in detail about JDBC and its general features?
What is the feature of jdbc v4?
What is jdbc dialect?
Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
Why do we need a jdbcrowset like wrapper around resultset?
Explain the sequence of steps to connect to the database?