What are the steps involved in establishing a connection using jdbc in java?
No Answer is Posted For this Question
Be the First to Post Answer
what happen if we set JDBC string to NULL?
how to retrieve sql exceptions
What is Apache DBCP API?
What is execute(), executeUpdate() and executeQuery() methods?
What is the latest version of JDBC? What are the new features added in that?
How do you determine the sensitivity of the ResultSet object?
Is jdbc part of j2ee?
Difference between Dirty, commited ,phantom,repeatable reads?
What is hbm xml?
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 differences between setmaxrows(int) and setfetchsize(int)?
Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?