A) TRANSACTION_READ_UNCOMMITTEDB) TRANSACTION_READ_ COMMITTEDC) TRANSACTION_SERIALIZABLED) TRANSACTION_REPEATABLE_READ.Explanation: A Dirty read allows a row changed by one transaction to be read by another transaction before any change in the row has been committed.

Sunanda

• Jan 20th, 2006

B) TRANSACTION_READ_ COMMITTED

Answer Question  Select Best Answer

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

Bhaumik Patel

• Apr 27th, 2006

To do connection pooling in webLogic 9.01. Start the weblogic server.2. Open the weblogic console (url: http://localhost:7001/console) and log on using your username and password.3. In the left side t...

Answer Question  Select Best Answer

vipin

• Jul 10th, 2006

All the application server needs information about the installed webserver's port and name, through these entries it creates a connector and stored. This connector is used to communicate with App server.

Answer Question  Select Best Answer

kumarbbk

 Profile Answers by kumarbbk Questions by kumarbbk

• Aug 27th, 2006

A RowSet object contains a set of rows from a result set or some other source of tabular data, like a file or spreadsheet. Because a RowSet object follows the JavaBeans model for properties and event ...

Answer Question  Select Best Answer

Hema

• Aug 23rd, 2006

This is from orqfaq.comimport java.sql.*;class dbAccess { public static void main (String args []) throws SQLException { DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver()); ...

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

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

In establishing a connection is to have the appropriate driver connect to the DBMS. The following line of code illustrates the general idea:E.g.String url = "jdbc:odbc:Fred";Connection con = DriverManager.getConnection(url, "Fernanda", "J8");

Ramu Kondapalli

• Jul 18th, 2006

First You can lode the driver calssee into your program.This can be achived by the useing of follwing Code.Class.forName("oracle.jdbc.driver.OracleDriver");once the driver is avilable now u can get an...

kk

• Jul 6th, 2005

Connection con=DriverManager.getConnection(url,"Krish","k2");

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

ramesh.sukka

 Profile Answers by ramesh.sukka Questions by ramesh.sukka

• Dec 1st, 2007

Thread is dispatchable unit of work and Process is group of inter related threads. So when you start more than one process in single JVM, JVM will give default priority to all threads. If you want alt...

Answer Question  Select Best Answer

agsuvidha

 Profile Answers by agsuvidha Questions by agsuvidha

• Aug 14th, 2007

Prepared statements are used whenever your pl/sql depends on the user input.suppose you want to insert some values in the table that you are taking from the text boxes in an applet connection con; Pre...

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

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

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

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

Chaka

 Profile Answers by Chaka Questions by Chaka

• Jun 13th, 2011

As many as you want, as long as it's one-at-a-time and you reset the Statement object after each usage:Statement st=con.createStatement(SQL_String1)ResultSet rs=st.executeQuery();//process rs herest.close();st=null;st=con.createStatement(SQL_String2)etcetc

manikant

• Oct 31st, 2005

No upper bound

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

A) SQLWarning objects are a subclass of SQLException that deal with database access warningsB) Warnings stop the execution of an application, as exceptions do; they simply alert the user that something did not happen as plannedC) Connection object has a getWarning() method in it.D) Statement and ResultSet objects have getWarning() methods in it.Explanation: warning does not stop the execution of the...

anjudony

 Profile Answers by anjudony Questions by anjudony

• Apr 5th, 2006

No. The JDBC-ODBC Bridge does not support concurrent access from different threads. The JDBC-ODBC Bridge uses synchronized methods to serialize all of the calls that it makes to ODBC. Multi-threaded J...

Basavaraja.P.A

• Dec 20th, 2005

B].Warnings don't stop the execution of an application

Answer Question  Select Best Answer