How can we retrieve a whole row of data at once in JDBC ?

karthikdivi

 Profile Answers by karthikdivi Questions by karthikdivi

• Jan 17th, 2012

As of now it is not possible.

Answer Question  Select Best Answer

As prepare statement also precompiles the SQL stmt & stored procedure also compiles the stmt once &den execute the same,then what is the diff between these 2 stmts?

Murali100

 Profile Answers by Murali100 Questions by Murali100

• Oct 7th, 2012

The difference between these two statements are
1) SQL Query will be compiled every time it is executed. whereas Stored Procedures are compiled only once when they are executed for the first time
2) Stored Procedure is efficient & fast execution than SQL query

Answer Question  Select Best Answer

Why we call Class.forName() not Class.Name()?

Abhinav Kumar Jain

• Jun 18th, 2016

We use Class.forName because of it is responsible to register the driver.ex. Class.forName("oracle.jdbc.driver.OracleDriver"); but Class.Name is not such method.

Answer Question  Select Best Answer

1.Statement (use createStatement method) 2. Prepared Statement (Use prepareStatement method) and 3. Callable Statement (Use prepareCall)

Sreekanth

• Jun 2nd, 2005

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

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

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

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

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

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: 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) 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) The JDK 1.1 and the Java 2 SDK, Standard Edition (formerly known as the JDK 1.2), contain both the JDBC API and the JDBC-ODBC Bridge.B) The Java 2 SDK, Standard Edition, contains the JDBC 2.0 core API, does not include the JDBC 2.0 Optional Package, which is part of the Java 2 SDK, Enterprise Edition, or which you can download separately.C) The JDK 1.1 and the Java 2 SDK, Standard Edition (formerly...

Mchandra

 Profile Answers by Mchandra Questions by Mchandra

• Jan 22nd, 2006

A is correct

Answer Question  Select Best Answer

A) No suitable driver

Raghunath

• Feb 23rd, 2006

When ever an attempt is made to load the invalid driver information compiler time exception arises asValid Driver Information can not be found

Answer Question  Select Best Answer

A) A Type 3 driver is a JDBC-Net pure Java driverB) This translates JDBC calls into a database -dependent net protocol.C) Vendors of database middleware products can implement this type of driver into their products to provide interoperability with the greatest number of database servers.D) a,b aboveExplanation: The JDBC calls are translated into a database-independent net protocol.

satheesh kumar. sriramaneni

• May 4th, 2006

C is the answer here.

Answer Question  Select Best Answer

A) getConnection()Explanation: getConnection() method in DriverManager class.Which is used to get object of Connection interface.

shyam

• Oct 17th, 2006

getConnection() method in DriverManager class.......and.........we can use like............public static synchronized void registerDriver(Driver driver) throws SQLExceptionA newly loaded driver class should call registerDriver to make itself known to the DriverManager.

Answer Question  Select Best Answer

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