Interested to Buy Any Domain ? << Click Here >> for more details...
What is de-normalization?
- 1 Answers
- 4137 Views
- I also Faced
- E-Mail Answers
Answer / arpana
It is the process of attempting to optimize the performance
of the database by adding redundant data.Implemented in the
form of index views.With the help of this querying is very easy.
| Is This Answer Correct ? | 2 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 causes the "No suitable driver" error?
What does setautocommit do?
What are the different types of resultset?
What is JDBC API and when do we use it?
What is the use of jdbc?
What is the limitation of PreparedStatement and how to overcome it?
What are the steps to connect to the database in java?
What is the query used to display all tables names in SQL Server (Query analyzer)?
Where is jdbc used?
How do you determine the sensitivity of the ResultSet object?
What does Class.forName return?
Core Java 
