A) TrueB) FalseExplanation: There are also methods that let you move the cursor to a particular row and check the position of the cursor

rmaghi@yahoo.com

 Profile Answers by rmaghi@yahoo.com Questions by rmaghi@yahoo.com

• Dec 13th, 2005

True

Answer Question  Select Best Answer

Supraja

• Dec 2nd, 2005

This link may be quite usefulhttp://www.precisejava.com/javaperf/j2ee/JDBC.htm#JDBC102

justAnother

• Nov 15th, 2005

The following is some information I could find on web regarding JDBC drivers:- The following website (not sure about the information) maintains a list of drivers and their usehttp://www.sqlsummit.com/...

Answer Question  Select Best Answer

Sandy Vohra

• Nov 27th, 2005

Unlike CGI scripts that trigger a new process for each request, Servlets run only one process using a separate Java thread per request.

Answer Question  Select Best Answer

pavani

• Nov 14th, 2005

A single application can have one or more connections with a single database, or it can have connections with many different databases.A user can get information about a Connection object's datab...

Mamatha

• Oct 23rd, 2005

Meta Data- is information that describes about structure and properties of our data. When we define a table we specify each columns name, type of data it holds and restrictions imposed (Constraints) ...

Answer Question  Select Best Answer

Anil Konduru

• Nov 15th, 2005

Save point is a feature using which we can save  status of the transaction to a perticular extent.so that if anytime we have lost a transaction we can get it back using save point.

Answer Question  Select Best Answer

Mamatha

• Oct 23rd, 2005

Using binary streams (ie getBinaryStream() ,setBinaryStream()).But it is not visable in database ,it is stored in form of bytes ,to make it visable we have to use any one frontend tool.

a arun kumar

• Oct 3rd, 2005

We can store the image in the database using the blob(binary large object) data type, where the image is stored in the form of the streams...

Answer Question  Select Best Answer

raviteja

• Nov 22nd, 2005

Connection pooling is one of the way to increase the performance of the jdbc connectivity in client server technology. It optimizes the time taken acquire a new connection on every request by maintain...

Answer Question  Select Best Answer

Prasanna V V

• Aug 31st, 2005

Also JDBC2.0 provides extended support for transactions that includes batch updates and savepoints

PChal

• Aug 11th, 2005

JDBC 2.0 Provides RowSet Implementation

Answer Question  Select Best Answer

Kabali

• Oct 3rd, 2005

hi,in procedure u will have some out parameter with datatype. so according to that we will have to set in callablestatement object registerOutParameter(7,OracleTypes.VARCHAR2 or or INTEGER or CURSOR);

Answer Question  Select Best Answer

ss

• Nov 11th, 2005

in java program if we want execute a statment 1) load the driver by using Class.forname("driver")2) get connection by using driverManager.getConnection("DataSource")3) createStatement con.createStatement();4) execute the query n get resultset.

Karuna Rajesh

• Oct 2nd, 2005

Statement stmt = con.createStatement();ResultSet rs = stmt.executeQuery("select * from user");

Answer Question  Select Best Answer

kecai

 Profile Answers by kecai Questions by kecai

• Oct 26th, 2005

AND, The DriverManager attempts to select an appropriate driver from the set of registered JDBC drivers

kecai

 Profile Answers by kecai Questions by kecai

• Oct 26th, 2005

One more ways is :DriverManager.getDriver(DB.URL)

Answer Question  Select Best Answer

mamatha03

 Profile Answers by mamatha03 Questions by mamatha03

• Oct 24th, 2005

Type-2 driver is Part Java Part Native Driver. This driver is a mixture of Jdbc driver and Vendor speciifc driver . You not only use ODBC to communicate with DataBase. You can also use Vendor specif A...

guptach

 Profile Answers by guptach Questions by guptach

• Sep 23rd, 2005

Type 2 driver is part Native-part Java driver. It is also one of the thin drivers. After the java calls are converted into JDBC calls by using the JDBC API, and those calls use the vendor specific API...

Answer Question  Select Best Answer

Answered by Jey on 2005-05-10 06:01:10: Here are the steps.  Using DriverManager: 1. Load the driver class using class.forName(driverclass) and class.forName() loads the driver class and passes the control to DriverManager class 2.DriverManager.getConnection() creates the connection to the databse  Using DataSource. DataSource is used instead of DriverManager in Distributed...

safiya

• Oct 18th, 2005

First we register the connection and after that we connect the database, in that we give to which database is connecting giving that  ipaddress ,port number,username and password .

sudhakar

• Oct 15th, 2005

it has two steps:1.load the class by using class.forName2.register the driver by using DriverManager class

Answer Question  Select Best Answer

Ramesh

• Oct 18th, 2005

Invove getResultSet() method of the callableStatement object which is inherited from java.sql.Statement interface

Yahel Hamou Malkin

• Oct 7th, 2005

By invoking the getObject on the CallableStatement.CallableStatement proc = conn.prepareCall("{ ? = call " + functionSql + " }");proc.registerOutParameter(1, Types.OTHER);proc.execute();ResultSet results = (ResultSet) proc.getObject(1);

Answer Question  Select Best Answer

It is used to create an instance of a driver and register it with the DriverManager. When you have loaded a driver, it is available for making a connection with a DBMS.

M.Nithiyanandhan

• Oct 17th, 2005

It is used tom initialize the driver .

deepak

• Sep 24th, 2005

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

Answer Question  Select Best Answer

There are 8 packages: java.sql.Driver, Connection,Statement, PreparedStatement, CallableStatement, ResultSet, ResultSetMetaData, DatabaseMetaData.

geetha

• Oct 4th, 2005

Packages arejava.sql and javax.sql only..Those mentioned in the previous lists are the classes & interfaces in those packages.

Jaime

• Jul 17th, 2005

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  ...

Answer Question  Select Best Answer

First JDBC returns results in a ResultSet object, so we need to declare an instance of the class ResultSet to hold our results. The following code demonstrates declaring the ResultSet object rs.E.g.ResultSet rs = stmt.executeQuery("SELECT COF_NAME, PRICE FROM COFFEES");Second:String s = rs.getString("COF_NAME");The method getString is invoked on the ResultSet object rs , so getString will retrieve...

Siladitya Chatterjee

• Sep 29th, 2005

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 ...

Sreekanth Chinthalapalli

• Jun 2nd, 2005

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...

Answer Question  Select Best Answer

The first step is to create a CallableStatement object. As with Statement an and PreparedStatement objects, this is done with an open Connection object. A CallableStatement object contains a call to a stored procedure;E.g.CallableStatement cs = con.prepareCall("{call SHOW_SUPPLIERS}");ResultSet rs = cs.executeQuery();

guptach

 Profile Answers by guptach Questions by guptach

• Sep 23rd, 2005

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();

Jaime

• Jul 17th, 2005

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...

Answer Question  Select Best Answer

JDBC is a layer of abstraction that allows users to choose between databases. It allows you to change to a different database engine and to write to a single API. JDBC allows you to write database applications in Java without having to concern yourself with the underlying details of a particular database.

guptach

 Profile Answers by guptach Questions by guptach

• Sep 22nd, 2005

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

Jaime

• Jul 17th, 2005

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...

Answer Question  Select Best Answer

Chidambara Gupta. Cheedella

• Sep 21st, 2005

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...

sendil

• Sep 12th, 2005

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

Answer Question  Select Best Answer