Answered by Jey on 2005-05-10 06:01:10: Here are the steps.  Using DriverManager: 1. Load the driver class using class.forName(driverclass) and class.forName() loads the driver class and passes the control to DriverManager class 2.DriverManager.getConnection() creates the connection to the databse  Using DataSource. DataSource is used instead of DriverManager in Distributed...

safiya

• Oct 18th, 2005

First we register the connection and after that we connect the database, in that we give to which database is connecting giving that  ipaddress ,port number,username and password .

sudhakar

• Oct 15th, 2005

it has two steps:1.load the class by using class.forName2.register the driver by using DriverManager class

Answer Question  Select Best Answer

tgnanakumar

 Profile Answers by tgnanakumar Questions by tgnanakumar

• Apr 23rd, 2010

By using the J2EE servers like WebLogic, WebSphere, jBoss, Tomcat.  We have to configure the data source object and connection pool object and supply the values as part of connection pool configu...

G.kirankumar

• Oct 6th, 2005

code for connecting the connection poolingInitalContext ic=new InitialContext();Hashtable ht=new Hashtable();ht.put("Context.INITIAL_PROVIDER",weblogic.jndi.InitialCla) //u have to set weblogic proper...

Answer Question  Select Best Answer

A Statement object is what sends your SQL statement to the DBMS. You simply create a Statement object and then execute it, supplying the appropriate execute method with the SQL statement you want to send. For a SELECT statement, the method to use is executeQuery. For statements that create or modify tables, the method to use is executeUpdate. E.g. It takes an instance of an active connection to create...

trinadh gantla

• May 3rd, 2007

Using Statement interface we can create JDBC statements as follows  Statement stmt=con.createStatement();here con is the connection object reference Different types of statements are Prepa...

rameshvdnv

 Profile Answers by rameshvdnv Questions by rameshvdnv

• Apr 25th, 2007

Class.forName("oracle.jdbc.driver.OracleDriver");Connection con;con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","scott","tiger");Statement stmt=con.createStatement();

Answer Question  Select Best Answer

Naim Kazi

• Feb 14th, 2006

But guys prepared statement has one disadvantage that it holds the data in the database. So when you execute a prepared statement for the first time, it will save the data in the database so that for ...

Anurjay Pradhan

• Nov 22nd, 2005

Prepared Statement is Pre-compiled class , but Statement is not.So in PreparedStatement the execution will be faster.

Answer Question  Select Best Answer

pavani

• Nov 14th, 2005

A single application can have one or more connections with a single database, or it can have connections with many different databases.A user can get information about a Connection object's datab...

Mamatha

• Oct 23rd, 2005

Meta Data- is information that describes about structure and properties of our data. When we define a table we specify each columns name, type of data it holds and restrictions imposed (Constraints) ...

Answer Question  Select Best Answer

A) Type - 1B) Type - 2C) Type - 3D) Type – 4

Hema chandra Reddy

• May 15th, 2006

Hi Type -4  is the best use

ak40732

 Profile Answers by ak40732 Questions by ak40732

• Mar 21st, 2006

As we know that applets has many restrictions on the remote machine on which they are executed.But they can make connections to the server from which they have been originated.As the database obviousl...

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

which of the following methods eliminates the need to call wasNull() method to handle null database fields?a)getObject()b)getInt()c)getString()d)getFloat()e)getNull()

vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 8th, 2010

To my understanding, the question  isn't framed properly. The answers given by two fellows above are ways to go around this situation but none eliminates the need to call wasNull().Other views are appreciated !!!

kittupeddi

 Profile Answers by kittupeddi Questions by kittupeddi

• Apr 10th, 2008

Two Ways:1> Use the wasNull() method on the ResultSet.2> Use the getObject() method on the ResultSet and do the Comparision.

Answer Question  Select Best Answer

A user leaves an online shopping cart without checking out.Which of the following interfaces will notify to rollback the transaction?a)HttpSessionb)HttpSessionBindingListenerc)HttpServletd)SingleThreadModele)FtpSession

vinaymudgil007

 Profile Answers by vinaymudgil007 Questions by vinaymudgil007

• Jun 8th, 2010

(b)HttpSessionBindingListener is the correct answervalueBound() and valueUnbound() are the methods that should be over-ridden to get this implemented.Thanks.Vinay

phanikhk

 Profile Answers by phanikhk Questions by phanikhk

• Apr 9th, 2008

Any class can implement HttpSessionBindingListener interface. This interface includes two methods, valueBound() and valueUnbound(), that are called whenever the object that implements the interfa...

Answer Question  Select Best Answer

What is the purpose of creating ODBC data source in establishing a connection between Java application & database?

sindhumsc

 Profile Answers by sindhumsc Questions by sindhumsc

• Aug 24th, 2010

ODBC stands for open database connectivity which helps us to connect then link from Java to database..so if we want to connect from Java to any database one way is to use ODBC which helps to connect Java to any database (like Oracle, MySQL..).

vana_mlk

 Profile Answers by vana_mlk Questions by vana_mlk

• Jul 2nd, 2010

Shine pattern has JConnection for connecting to any database.

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