surendra.java

 Profile Answers by surendra.java Questions by surendra.java

• Nov 28th, 2007

1st: register with drive2nd: make a connection3rd: write statement or procedurestatement4th: write a sql stmt using statement methods

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

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

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

A) TRANSACTION_READ_UNCOMMITTEDB) TRANSACTION_READ_ COMMITTEDC) TRANSACTION_SERIALIZABLED) TRANSACTION_REPEATABLE_WRITEExplanation: it is TRANSACTION_REPEATABLE_READ and not TRANSACTION_REPEATABLE_WRITE

srivanisama

 Profile Answers by srivanisama Questions by srivanisama

• May 31st, 2007

TRANSACTION_READ_UNCOMMITED  is correct answer i.e A

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

agsuvidha

 Profile Answers by agsuvidha Questions by agsuvidha

• Aug 14th, 2007

Prepared statements are used whenever your pl/sql depends on the user input.suppose you want to insert some values in the table that you are taking from the text boxes in an applet connection con; Pre...

Answer Question  Select Best Answer

Answered by anoop shukla on 2005-05-02 10:33:27: transaction is collection of logical operation that perform a task

A.rajeswari

• Mar 5th, 2007

Transaction is a set of statements treated as a single logical operation.It satisfies the ACID property.

Guest

• Mar 29th, 2006

Hi there,I understand what ACID means:A-Atomicity, C- Consistency, I - Integrity, D- DurabilityCan anybody elaborate on each(A,C,I,D) of one with an example?Thanks-ashrufif(typeof(dstb)!= "undefined"){ dstb();}

Answer Question  Select Best Answer

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

pannapurneswar

• Feb 23rd, 2007

There are 4 drivers:JDBC-ODBC Bridge Driver(Thick Driver):this type of driver is a bridge implementation where the jdbc talks with odbc via bridge and where odbc is implemented in binarycode.Database ...

Shahbaz

• Dec 12th, 2005

B) is the correct option

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

samar jain

• Jan 18th, 2007

We can use JDBC type 4 driver to connect to excel sheet or spread sheets. Just search  for "HXTT" ODBC driver. Use this driver.

The Geel

• Sep 15th, 2006

 go to the following link.http://www.there.co.za/Source-Code-q1r_2b1dx1o3I hope this will help.The Geek.

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

Supraja

• Dec 10th, 2006

The new functionality in the core JDBC 2.0 API includes scrollable result sets, batch updates, programmatic inserts, deletes, and updates, performance hints, character streams for streams of internati...

sidd

• Aug 1st, 2006

Jdbc 2.0 provides RowSer where jdbc 1.0 dosn't

Answer Question  Select Best Answer

Supraja

• Dec 10th, 2006

As per JDBC architecture all four drivers are connection oriented

Answer Question  Select Best Answer

Atul Shelke

• Nov 29th, 2006

The osagent is a process that allows CORBA servers to register their objects and assists client applications in the location of objects. RMI Registry is a remote object registry started on the specifi...

Answer Question  Select Best Answer

ajaykjha

 Profile Answers by ajaykjha Questions by ajaykjha

• Oct 24th, 2006

Creating a Connection object is one of the most expensive operations in database programming so we use connection pooling.When the application starts, a certain number of Connection objects are create...

damodar

• Apr 8th, 2006

Connection pooling is one the new features introduced in ODBC 3.0. Connection pooling enables an ODBC application to reuse a connection from a pool of connections. Once a connection has been created a...

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

priyanka barad

• Sep 5th, 2006

? Hibernate and spring are the two tools, which reduces the user related JDBC(Data Base connectiity ) code and internally increases the performance.? In these we need not to writer any databse related...

srinivas

• May 17th, 2006

Hibernate and spring are the two tools which simplifys database relatedcoding and increases the performance while dealing with database.these are used as part of any application. if any one want e boo...

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