How can we maintain the integrity of a database by using jdbc?
No Answer is Posted For this Question
Be the First to Post Answer
What are different types of transactions?
How vendor Naming registry supports JNDI?
How to update a resultset programmatically?
What are the different types of JDBC drivers?
How can we store and retrieve images from the database?
What is a Connection?
Which constraint cannot be specified as an explicit constraint and should be specified with the column only ?
How to handle when the database crashes while reading the data from the database?
Can you define a foreign key, with a key from the same table?
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
How can we set null value in jdbc preparedstatement?
What is odbc and jdbc in dbms?