| Other JDBC Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what are the Different types of exceptions in JDBC? | | 1 |
| how to prevent finally block from execution | Bosch | 3 |
| What is Type-1 Driver and when this driver is used? | | 3 |
| What is Type-2 Driver and when this driver is used? | | 2 |
| r u used any design patterns in your project? | Wipro | 3 |
| Can we make a database connection from HTML ? | BOB-Technologies | 2 |
| What are the sailent features of JDBC 2.0? | | 6 |
| which scenarios we go for jdbc,and which scenario we go for
connection polling and wat r advantages and disadvantages
using connection pooling. | TCS | 2 |
| What is Statement and PreparedStatement? whatz the
difference? | | 2 |
| What is the difference between triggers and procedures? | | 1 |
| Hi to all.. well i want to make a standalone application
which can use the concept of connection pooling, constraint
is that i have not to use any application server like
weblogic etc.
Please help me out.
Thaks in advance. | Huawei | 2 |
| what does batchUpdate does? | HCL | 5 |
| What is Type-4 Driver and when this driver is used? | | 3 |
| What does Class.forName return? | IBM | 6 |
| write down exceptions those appear in java programs when u
write JDBC Programs? | | 2 |
| What is JDBC? | | 2 |
| 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 | | 1 |
| Can we use the one instance of Statment to execute more
than one query ? | TCS | 2 |
| What are the Isolation level in JDBC transaction? | | 1 |
| Difference between Dirty, commited ,phantom,repeatable
reads? | | 2 |
| |
| For more JDBC Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
