Saritha

• Jan 19th, 2006

Type 4 driver is pure java JDBC driver. every database has its own driver classes which are usually distributed through jar files.There is not specific installation for these drivers. If you want...

Answer Question  Select Best Answer

A) Create a CallableStatement object.B) A CallableStatement object contains a call to a stored procedure.C) The execution call should be like CallableStatement cs = con.prepareCall("{call SHOW_SUPPLIERS}");D) We need not make an instance of the Connection class before making a Callable statement.Explanation: The callable statement is prepared based on the connection object only check option c, where...

krudupa9

 Profile Answers by krudupa9 Questions by krudupa9

• Dec 30th, 2005

Answer is DWe have to make a connection object as we call the method prepareCall() of connection object.

Answer Question  Select Best Answer

A) TrueB) FalseExplanation: The JDBC 2.0 API is the latest update of the JDBC API. It contains many new features, including scrollable result sets and the new SQL:1999 (formerly SQL 3) data types.

rmaghi@yahoo.com

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

• Dec 13th, 2005

A. True

Answer Question  Select Best Answer

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

A) Java Native InterfaceExplanation: Any all-Java JDBC driver should work with J++

A) Class.forName

A) 18B) 24C) 32D) 64Explanation: because In JDK 1.1, java.math.BigInteger is implemented in C. It supports a precision of thousands of digits. The same is true for BigDecigmal.

A) This type of error occurs during an attempt to connect to a database with the bridge.B) The error is coming from the ODBC driver manager.C) The problem is due to the native libraries not present.D) The error is due to the fact that an ODBC DSN (data source name) needs to be configured on the client machineExplanation: the problem is because of the point d mentioned and not due to native DLL’s not...

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