JDBC Interview Questions

it is used tom initialize the driver .

class.forName()method create an  instance of specified driver, loads that driver, and then register that driver with the DriverManager class.

Packages are

java.sql and javax.sql only..

Those mentioned in the previous lists are the classes & interfaces in those packages.

java.sql.BatchUpdatException Provides information about errors that occurred during batch operations   java.sql.Blob Provides access to and manipulation of Binary Large Object data  ...

import java.sql.*;class JDBCtableread{ public static void main(String args[])throws Exception { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url="jdbc:odbc:dsn2";//dsn name ...

Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(SELECT COF_NAME, PRICE FROM COFFEES"); while (rs .next() ) {  //Iam assuming there are 3 columns in th...

Stored Procedures can be called in java by using the prepareCall() method which returns a CallableStatement object.

CallableStatement cs = con.prepareCall("{call Procedure_name}");

ResultSet rs = cs.executeQuery();

This document demonstrates how to return a JDBC ResultSet as REF CURSOR from a Java Stored Procedure. JDBC ResultSet is a table of data representing a database, which is usually generated by executing...

JDBC is a core API of Java 1.1 and later which provides a standard set of interfaces to SQL-compliant databases.

Call-level interfaces such as JDBC are programming interfaces allowing external access to SQL database manipulation and update commands. They allow the integration of SQL calls into a general programm...

Batch Updates are nothing but a bunch of updations that are done at a time without interruption. All the update statements are added to a Batch by using the addBatch() method and the Batch is&nbs...

we can add batch system using add.batch();

try {  Connection conn = DriverManager.getConnection("URL",'USER"."PWD");  //For Simple statement used for static query. Statement stmt = conn.createStatement();  &n...