How the JDBC application works?
No Answer is Posted For this Question
Be the First to Post Answer
What is sqlwarning and discuss the procedure of retrieving warnings?
what is meant by connection pooling?
What is the return type of class.forname() method?
What is Type-2 Driver and when this driver is used?
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
Explain different types of locks in jdbc?
Does the database server have to be running Java or have Java support in order for my remote JDBC client app to access the database?
How to insert and delete a row programmatically? (new feature in JDBC 2.0)
What is the role of jdbc drivermanager class?
If iam using JDBC API, do I also have to use ODBC?
what is the best way, in terms of performance, to do multiple insert/update statements, a PreparedStatement or Batch Updates?
Name the types of jdbc drivers.