vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 8th, 2010

Per my understanding and knowledge over the years, its the Native [java specific] protocol that is used in type4 drivers !!!Thanks,Vinay

Spoorthi

• Sep 13th, 2006

   jdbc:oracle:thin:@localhost:1521: our GlobalDatabasename

Answer Question  Select Best Answer

vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 8th, 2010

Yes it possible.... Please see public static Enumeration getDrivers() method in java.sql.DriverManager.DriverManager class which gives the complete list of Drivers available for use as an Enumeration.Thanks,Vinay

Supriya Ahire

• Feb 2nd, 2007

Hello, Yes , U can use two Class.forName() as Drivermanager keeps array internally to store the Drivernames so whichever come first will we loaded & used.Regards, Ms.Supriya Ahire

Answer Question  Select Best Answer

vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 8th, 2010

Database transactions => A group of SQL queries which should either all be executed or none should be executed will comprise of a tracnsaction.Maintain transactions using JDBC => We can do ...

trcdutt

 Profile Answers by trcdutt Questions by trcdutt

• Feb 15th, 2008

Here is a skeleton of code for implementing a transaction.import java.sql.Connection;public class Test {public void AllTransactionStatements() {    Connection con = getCon();  &nbs...

Answer Question  Select Best Answer

madhu

• Sep 5th, 2011

Always you should close connection. In some cases exception is thrown. When more processes get active in the same.

anand chaubey

• Aug 7th, 2011

If you don't close the connection,your application will eat up all your connection and your application will run out of connection and server will give error as no active connection and your application won't work.

Answer Question  Select Best Answer

When would you use a JDBC-ODBC Bridge?

vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 7th, 2010

We use JDBC-ODBC bridge only when pure JDBC drivers are not available [say for connecting to a database] otherwise pure Java drivers are a good optoion.The use of JDBC-ODBC drivers isn't recommended v...

hsavinash2001

 Profile Answers by hsavinash2001 Questions by hsavinash2001

• May 26th, 2010

It is not recommended to use because of the dependency on native language (This is implemented in C++)

Answer Question  Select Best Answer

A) ODBC can be directly used with Java because it uses a C interfaceB) ODBC makes uses of pointers which has been totally removed from JAVAC) ODBC is from Microsoft while JDBC is from java applicationsD) ODBC requires manual installation of the ODBC driver manager and driver on all client machines. While for JDBC driver are written in Java and JDBC code is automatically installable, secure and portable...

Suhas Lonarkar

• Jun 10th, 2006

Because ODBC being a c based interface cannot be directly used with java

palavarapu sravankumar

• Apr 19th, 2006

Iguess answer is A  because it uses a interfaces

Answer Question  Select Best Answer

A) Regular Statement (use createStatement method)B) Prepared statement (use prepareStatement method)C) Callable statement (use prepareCall).D) Interim statement (use jdbcCall).

maneesh.ce.2007

 Profile Answers by maneesh.ce.2007 Questions by maneesh.ce.2007

• Dec 29th, 2008

D is false

ramasomepalli

 Profile Answers by ramasomepalli Questions by ramasomepalli

• Dec 27th, 2008

D) Interim Statement

Answer Question  Select Best Answer

A) When a connection is created, it is in auto-commit mode.B) If the value is true each individual SQL statement is treated as a transaction and will be automatically committed right after it is executed.C) once auto-commit mode is disabled, no SQL statements will be committed until you call the method commit explicitlyD) By default the JDBC call is in auto-commit mode.Explanation: by default the JDBC...

Harish

• Apr 10th, 2018

Answer is : D

vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 8th, 2010

The answer is (b) per my understanding

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) 1,2B) 2,3C) 1,3D) 1,2,3

Jerry Sam

• Jul 10th, 2015

D

meenakshi

• Apr 1st, 2013

1,2,3

Answer Question  Select Best Answer

siva kumar reddy

• Aug 7th, 2006

hi ,Class.forName("srting");when ever execute the above statement first chesks that class is loaded before or not .if not loaded it loads the class.Class.forName("oracle.jdbc.driver.OracleDriver");In this case driver manager loads the all drivers in the class.cheerssivaa

Jayant Dhargawe

• Jun 6th, 2006

Hi,Class is also class in java.lang package, it has a method getName(String arg) which take Driver Class u have supply libery in classpath lib directory. Its search given argrument and loading particular class into JVM. and use further process for getting connection from database.

Answer Question  Select Best Answer

damu

• Apr 8th, 2006

I ihave learnt the answer in very easy way for the  question what is the need of BatchUpdates? i have lot of doubts regarding j2ee and xml will u pls slove my problems

GVRaju

• Mar 29th, 2006

It will reduce the no. of calls making from front end to backend.usually when we want to insert 3 records to db from frontend, instead of making 3 request calls to db, add all the three request to batch and make only one request, so that all the 3 records will be inserted.

Answer Question  Select Best Answer

This involves two steps: (1) loading the driver and (2) making the connection.

shekarGeek

 Profile Answers by shekarGeek Questions by shekarGeek

• Jul 25th, 2007

Steps to follow establish a connection1.import required(sql) package.import java.sql.*;import javax.sql.*;javax.sql-----------------------1Data source 2Connection pooling 3Distributed transactions 5Ro...

rameshvdnv

 Profile Answers by rameshvdnv Questions by rameshvdnv

• Apr 25th, 2007

1)Register the driver with the drivermanagerDriver drv=new oracle.jdbc.driver.OracleDriver();Drivermanager.registerDriver(drv);Connection con=Drivermanager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","scott","tiger");

Answer Question  Select Best Answer

Loading the driver or drivers you want to use is very simple and involves just one line of code. If, for example, you want to use the JDBC-ODBC Bridge driver, the following code will load it:Eg.Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");Your driver documentation will give you the class name to use. For instance, if the class name is jdbc.DriverXYZ , you would load the driver with the following line...

sudhakar

• Sep 9th, 2007

by using:Class.forName("oracle.jdbc.driver.OracleDriver");Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","scott","tiger");in the above way we can load the drivers.

shekarGeek

 Profile Answers by shekarGeek Questions by shekarGeek

• Jul 25th, 2007

There are 2 ways to load the dirvers1.By usiing Class.forName();Ex- Class.forName("jdbc.odbc.OracleDriver");2.By using DriverManager.Driver thind=new Driver("jdbc:odbc:OracleDriver");DriverManager.registerDriver(thind);

Answer Question  Select Best Answer

pradeepkmr18

 Profile Answers by pradeepkmr18 Questions by pradeepkmr18

• Jul 3rd, 2008

We have to select the driver based on reqirement .

arun kumar

• Dec 7th, 2005

Hi, there, the order in which the drivers can be used is 4213, :) bye

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) 1,2,3,4B) 1,3,4,2C) 1,4,2,3D) 4,1,2,3

virender

• Dec 16th, 2017

1,3,4,2

nandhini

• Aug 8th, 2017

B) 1,3,4,2

Answer Question  Select Best Answer

A) A Type 1 driver is a JDBC-ODBC bridge driverB) This type of driver enables a client to connect to an ODBC database via Java calls and JDBCC) Both the database and middle tier need to be Java compliant.D) ODBC binary code must be installed on each client machine that uses this driver.Explanation: Neither the database nor the middle tier needs to be java compliant.

abhi

• Dec 15th, 2006

C is the ans

virendra maurya

• May 29th, 2006

C is the wrong one

Answer Question  Select Best Answer

sambasiva

• Dec 11th, 2006

 hi jaisankar In fact, it is the responsible of driver vendor to provide implemention class for connection interface. Collection of these type classes called as drivers. ...

Jaishankar

• Nov 10th, 2006

hi,  can you be clear about this answer.  is it that connection interface is being implemented by the vendor in the jar Files they provide.If so wht class it will be.Thanks in advanceRegardsJaishankar

Answer Question  Select Best Answer

Supriya Ahire

• Feb 2nd, 2007

Hello All, Types of Resultsets are 1)TYPE_FORWARD_ONLY 2) TYPE_SCROLL_INSENSITIVE 3)TYPE_SCROLL_SENSITIVE DEFAULT Type of resultset is TYPE_FORWARD_ONLY. Regards, Ms.Supriya Ahire

Supraja

• Dec 10th, 2006

TYPE_FORWARD_ONLY The result set is nonscrollable; its cursor moves forward only, from top to bottom. The view of the data in the result set depends on whether the DBMS materializes result...

Answer Question  Select Best Answer