Explain working of Java Virtual Machine (JVM)
Explain the working cycle of the JDBC-ODBC connectivity?

Ashwinshenoy7

 Profile Answers by Ashwinshenoy7 Questions by Ashwinshenoy7

• May 9th, 2011

As the question says JVM and JDBC, let me tell you what JVM is initially,JVM is java virtual machine which is platform dependent but Java is platform independent and its source code can be executed on...

Answer Question  Select Best Answer

chandrika soni

• Apr 2nd, 2012

Java Native Interface (JNI)

Answer Question  Select Best Answer

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

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

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

The JDBC Driver interface provides vendor-specific implementations of the abstract classes provided by the JDBC API. Each vendors driver must provide implementations of the java.sql.Connection,Statement,PreparedStatement, CallableStatement, ResultSet and Driver.

pavan

• Feb 3rd, 2006

As has been mentioned above, the implementations are provided by the database vendors like for example, the classes12.jar of oracle which has the implementations.

Ravi

• Aug 23rd, 2005

In jdbc connecion is a interface , we are using the methods in that interface but we didnt provide any implementation where is the implementation? 

Answer Question  Select Best Answer

Create an instance of a JDBC driver or load JDBC drivers through jdbc.driversRegister a driverSpecify a databaseOpen a database connectionSubmit a queryReceive results

srilatha

• Jan 22nd, 2006

import java.sql.*;class Type1 { public static void main(String[] args)throws Exception {  Connection c=null;  try  {    Driver d=new Driver("sun....

Jayachandran

• Jan 3rd, 2006

Please Can any post the sample code for this set of operations. How do we register ?. Through DirverManager or what else ?

Answer Question  Select Best Answer

A URL string -->getConnection-->DriverManager-->Driver-->Connection-->Statement-->executeQuery-->ResultSet.

kalyan789

 Profile Answers by kalyan789 Questions by kalyan789

• Apr 23rd, 2009

I guess, order is like this1) load driver2) register driver to driver manager3) get connection from driver manager4) get statement object from connection5) create queries and execute them6) close connection

Suresh Pendyala

• May 8th, 2005

1). Register the Driver 2) load the Driver 3)get the connection 4) create the statement 5) Execute the query 6) fetch the results with ResultSet

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

Another new feature in the JDBC 2.0 API is the ability to update rows in a result set using methods in the Java programming language rather than having to send an SQL command. But before you can take advantage of this capability, you need to create a ResultSet object that is updatable. In order to do this, you supply the ResultSet constant CONCUR_UPDATABLE to the createStatement method.E.g.Connection...

kalyan789

 Profile Answers by kalyan789 Questions by kalyan789

• Apr 23rd, 2009

Following above answer, we can iterate through result set using, next() method and set corresponding column values for each row, using setInt/String/Float etc methods specifying column index or column name and value.Thankskalyan

Ashwini

• Oct 26th, 2005

New Features of JDBC2.0To make a updateble resultset use,Resultset.CONCUR_UPDATABLE 

Answer Question  Select Best Answer

Antariksh Kar

• Aug 31st, 2007

Go to admin console and create a JDBC Adapter connection by providing various driver parameters. Go back to the developer and create a new adapter service and then create an adapter notification. Write the SQLs using the templates provided by the adapter.

ramana

• Mar 17th, 2006

It is used in web service.

Answer Question  Select Best Answer

A) Use of the JDBC-ODBC bridge from an untrusted applet running in a browser, such as Netscape Navigator, isn't allowed.B) It is possible to use the JDBC-ODBC bridge with applets that will be run in appletviewer since appletviewer assumes that applets are trusted.C) It is not possible to use the JDBC-ODBC bridge with applets that are run in the HotJavaTM browser (available from Java Software), since...

taramesquita

 Profile Answers by taramesquita Questions by taramesquita

• May 22nd, 2008

It is not possible to use the JDBC-ODBC bridge with applets that are run in the HotJavaTM browser (available from Java Software), since HotJava provides an option to turn off applet security.

rajagopal

• Mar 10th, 2006

Answer is D

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) A workaround is to explicitly call the method DriverManager.registerDriver(new YourDriverClass).B) The problem is due to race condition in the class loader.C) The race condition prevents the static section of code in the driver class from executing and registering the driver with the DriverManager.D) All the above.

vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 8th, 2010

(D) all of the above  is the correct answer

s.sivashankar

 Profile Answers by s.sivashankar Questions by s.sivashankar

• Feb 13th, 2006

D

Answer Question  Select Best Answer

A) TrueB) FalseExplanation: The ResultSet.getXXX methods are the only way to retrieve data from a ResultSet object, which means that you have to make a method call for each column of a row. It is unlikely that this is the cause of a performance problem, however, because it is difficult to see how a column could be fetched without at least the cost of a function call in any scenario.

vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 8th, 2010

We can update the Row with the values of the result set via updateRow() but we can't fetch it and hence the answer is "NO" or falseThanks,Vinay

Praveen

• May 17th, 2006

we cannot retrieve a whole row of data at once.In JDBC getXXX() are the methods which are used to get the data from ResultSet by columnwise.

Answer Question  Select Best Answer

A) TrueB) FalseExplanation: The JDBC-ODBC Bridge uses synchronized methods to serialize all of the calls that it makes to ODBC. Multi-threaded Java programs may use the Bridge, but they won't get the advantages of multi-threading

ZUBED

• Aug 5th, 2015

FALSE

s.sivashankar

 Profile Answers by s.sivashankar Questions by s.sivashankar

• Feb 13th, 2006

A

Answer Question  Select Best Answer

A) TrueB) FalseExplanation: You can open only one Statement object per connection when you are using the JDBC-ODBC Bridge.

kuldip2004

 Profile Answers by kuldip2004 Questions by kuldip2004

• Jan 23rd, 2009

No. You can open only one Statement object per connection when you are using the JDBC-ODBC Bridge.

virendra maurya

• May 29th, 2006

A

Answer Question  Select Best Answer

A) A middle tier is introduced in this model.B) Collection of SQL statements from the client and handing it over to the database.C) Maintaining control over accessing and updating of receiving results from database to the client.D) All of the above.

bhargavareddy

 Profile Answers by bhargavareddy Questions by bhargavareddy

• Oct 12th, 2010

Answer is option D

satheesh kumar. sriramaneni

• May 4th, 2006

A is the correct one.

Answer Question  Select Best Answer