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

Sekhar

• Mar 15th, 2012

ResultSet rs; where rs is treat like a cursor to a database.if the connection is alive then only we can retrieve the information through resultset object.

RowSet rs;We can retrieve data through rowset object with out depending upon the connection is alive or not.

sudhakar

• Oct 15th, 2005

If the connection is alive, then only the values remain in a ResultSet, where as in RowSet,once we get the results connection need not be alive. 

Answer Question  Select Best Answer

How to achieve a single value from web page to be updated/stored in many tables ?

sekhar

• Mar 15th, 2012

To update data in multiple table using single click ,we can go with triggers in database.we have different types of triggers like after insert,after update,after delete.Better using triggers.

G S

• Nov 4th, 2011

By using Transactions.

Every JDBC Driver will be able to perform Transactions. But its not recommended.

If we want to use out own Transactions we will set

con.setAutoCommit(false); and after executing the transactions we will execute con.commit();

Answer Question  Select Best Answer

chandrika soni

• Apr 2nd, 2012

Java Native Interface (JNI)

Answer Question  Select Best Answer

Chandan

• Jun 20th, 2012

Connection pooling is a technique using which we can get the precreated connection object from the connection pool.After using that connection object, the connection object is released to the pool fo...

Suresh Yerra

 Profile Answers by Suresh Yerra Questions by Suresh Yerra

• Dec 11th, 2011

Usually Acquiring the connection is time consumption task. In order to avoid that situations, we are reusing already created connection objects. This requirement doesnot support DriverManager interface, we have interface DataSource in javax.sql package.

Answer Question  Select Best Answer

koti

• Sep 9th, 2012

U store the object of a class in database. but database is meant for storing the values in the table format. for that reason only sun introduced JNDI for storing the object. by using this concept u can store the object in registry software. with that u can provide the global visibility also

jingboliu

• Sep 24th, 2007

1. Please make sure the java object is serializable2. Serialize the java object into a file3. Store the content of the file to relational database as Blob

Answer Question  Select Best Answer

A) Java Database connectivity

sujith

• Sep 28th, 2012

No it does not contain any full form. It is Java based data access technology and we use it as Java database connectivity for our convenience.

Atul Sonkar

• Jun 5th, 2006

JAVA DATABASE CONNECTIVITY

Answer Question  Select Best Answer

Give me brief description with small Example

Suman Kumar Thati

• Oct 5th, 2012

JDBC-ODBC Bridge is a type 1 JDBC driver which converts JDBC operations in to C language ODBC APIs and then ODBC calls are then passed to appropriate ODBC driver.

dasavtar

 Profile Answers by dasavtar Questions by dasavtar

• Jan 25th, 2011

Type1: JDBC-ODBC Bridge driverThis is a "birdge" driver, Translates all JDBC calls into ODBC calls and sends them to ODBC driver and ODBC inturn will communicate with a database. The Java Na...

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

Manohar

• Nov 2nd, 2012

ExecuteUpdate() is ment for Non-Select Statements,,and it returns Update Count as an int value.

executeQuery() is ment for Select Statements, and it returns ResultSet.

MeenaDeepak

 Profile Answers by MeenaDeepak Questions by MeenaDeepak

• May 21st, 2012

ExecuteQuery() is used for Select statements.
executeUodate() is used for insert,update,delete statements..

Answer Question  Select Best Answer

A) A result set that is TYPE_SCROLL_INSENSITIVE does not reflect changes made while it is still open and one that is TYPE_SCROLL_SENSITIVE does.B) Both types of result sets will make changes visible if they are closed and then reopened.C) You will get a scrollable ResultSet object if you specify one of these ResultSet constants.D) A result set that is TYPE_SCROLL_INSENSITIVE makes the result set read...

vk payne

• Feb 8th, 2013

A,B and D
All the three are correct

vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 8th, 2010

The wrong option and hence the correct answer is (d)

Answer Question  Select Best Answer

A) Type 4 driver, or, "native protocol, pure Java" driver converts JDBC calls into the network protocol used by the database directly.B) A Type 4 driver requires no client software, so it's ideal for deployment to browsers at runtime.C) As Type 4 drivers are 100% Java, use Java sockets to connect to the database, and require no client-side data access code, they are ideal for applets or other download...

Vicky Mehra

• Apr 1st, 2014

A

Farkalit Usman

• Mar 20th, 2006

D is false, since driver is independent of browsers.

Answer Question  Select Best Answer

A) 1,2,3B) 1,3,4C) 1,2,4D) 1,2,3,4

shailesh

• May 12th, 2014

B

milan

• Jan 27th, 2006

Ans: D

Answer Question  Select Best Answer

A) TRANSACTION_READ_UNCOMMITTEDB) TRANSACTION_READ_ COMMITTEDC) TRANSACTION_SERIALIZABLED) TRANSACTION_REPEATABLE_READ.Explanation: A phantom read is where one transaction reads all rows that satisfy a WHERE condition, a second transaction inserts a row that satisfies that WHERE condition, and the first transaction re-reads for the same condition, retrieving the additional 'phantom' row in the second...

sanky

• Jun 3rd, 2014

Charankk, please read question carefully. We need ans for which allows phantom read. We dont need ans for which does not allows. Ans is A,B,D

pradeepkmr18

 Profile Answers by pradeepkmr18 Questions by pradeepkmr18

• Jul 3rd, 2008

These will allow phanthom readRead_uncommitedRead_commitedRepeatable_read

Answer Question  Select Best Answer

A) java.sql.DatabaseMetaData.B) java.sql.resultsetmetadata

Chaithanya

• Oct 27th, 2014

DatabaseMetaData

ruchiverma

 Profile Answers by ruchiverma Questions by ruchiverma

• Oct 11th, 2008

Answer is java.sql.resultsetmetadata

Answer Question  Select Best Answer

A) This problem can be caused by running a JDBC applet in a browser that supports the JDK 1.0.2, such as Netscape Navigator 3.0. The JDK 1.0.2 does not contain the JDBC API, so the DriverManager class typically isn't found by the Java virtual machine runningB) Most of the browsers cannot download java.* because of security reasons. Hence many vendors of all-Java JDBC drivers supply versions of the...

ajay

• Nov 21st, 2014

A

vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 8th, 2010

My understanding says that it should be ==> ( c )

Answer Question  Select Best Answer

Mukesh Luhar

• Dec 5th, 2014

Prepared : use when you plan to use the SQL statement many times.
Callable : use when you want to access database stored procedures.

Nowfaldaan

• Mar 9th, 2007

Statement:  to execute a single query one timepreparedstatement: to execute a single query multiple times(here the statement will be precompiled and will get good performance)Collable statement :...

Answer Question  Select Best Answer

A) A Type 2 driver converts JDBC calls into calls for a specific database.B) This driver is referred to as a "native-API, partly Java driver."C) As with the Type 1 driver, some binary code may be required on the client machine, which means this type of driver is not suitable for downloading over a network to a client.D) All of the above

francis

• Jan 13th, 2015

B

Supriya

• Dec 2nd, 2012

B) This driver is referred to as a "native-API, partly Java driver."

Answer Question  Select Best Answer

A) TrueB) FalseExplanation: Most desktop databases currently require a JDBC solution that uses ODBC underneath. This is because the vendors of these database products haven't implemented all-Java JDBC drivers. The best approach is to use a commercial JDBC driver that supports ODBC and the database you want to use

dfdfd

• Jan 14th, 2015

B

mohangs

 Profile Answers by mohangs Questions by mohangs

• Jan 9th, 2006

False. You can access desktop databases like MS-Access using jdbc-odbc driver

Answer Question  Select Best Answer

A) Open DataBase connectivity

sandeep

• Feb 16th, 2015

Open database connectivity

atulsonkar

• Jun 5th, 2006

Open Database Connectivity

Answer Question  Select Best Answer