| Other JDBC Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to find that, a row is updated or not? | | 2 |
| what exactly happens when we execute
"Class.forname("Driver class name");"?Explain indetail
| Trigent | 10 |
| signature of init method? | | 2 |
| How to find total column from a resultset? | tsys | 5 |
| what is rowset? | Marlabs | 3 |
| Hi........I need to create a dropdown box using
java.....this box should show the values that should be
taken from the database......
Thank you.... | | 1 |
| How can you tune SQL statements? | Wipro | 2 |
| How many isolation levels are supported in JDBC and what
are they? | | 1 |
| how can we get the metaData (columnNames) from a table which
has no Records.. | | 2 |
| Which Driver is preferable for using JDBC API in Applets? | | 1 |
| What is Type-1 Driver and when this driver is used? | | 3 |
| what is connection pooling? | Wipro | 6 |
| callable is interface or class ? | Fidelity | 8 |
| what is meant by connection pooling? | | 3 |
| 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 |
| If iam using JDBC API, do I also have to use ODBC? | | 1 |
| how do we get the connection from connection pool | | 1 |
| wahts is mean by primary key and unique key? | Wipro | 7 |
| JDBC Drivers properties? | Infosys | 1 |
| write down exceptions those appear in java programs when u
write JDBC Programs? | | 2 |
| |
| For more JDBC Interview Questions Click Here |