GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  J2EE  >  JDBC
Go To First  |  Previous Question  |  Next Question 
 JDBC  |  Question 16 of 138    Print  
What packages are used by JDBC?
There are 8 packages: java.sql.Driver, Connection,Statement, PreparedStatement, CallableStatement, ResultSet, ResultSetMetaData, DatabaseMetaData.



  
Total Answers and Comments: 2 Last Update: October 04, 2005   
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: geetha
 

Packages are

java.sql and javax.sql only..

Those mentioned in the previous lists are the classes & interfaces in those packages.



Above answer was rated as good by the following members:
pradeepkmr18
July 16, 2005 21:04:45   
Jaime        

RE: What packages are used by JDBC?
java.sql.BatchUpdatException Provides information about errors that occurred during batch operations

java.sql.Blob Provides access to and manipulation of Binary Large Object data

java.sql.CallableStatement Provides access to and manipulation of Stored Procedures

java.sql.Clob Provides access to and manipulation of Character Large Object data

java.sql.Connection Constructs and manages the connection to the database Provides metadata information about the database

java.sql.DatabaseMetaData Provides meta data about the database.

java.sql.Driver Provides information about and manages the JDBC driver

java.sql.ParameterMetaData Provides the number type and properties of parameters to prepared statements.

java.sql.PreparedStatement Manages dynamic SQL statements

java.sql. ResultSet Provides metadata information about the result set

java.sql.ResultSetMetaData Manages result set metadata information

java.sql.Statement Manages static SQL statements
javax.sql.ConnectionPoolDataSource Supports caching and reusing of physical connections which improves application performance and scalability

javax.sql.DataSource Provides access to JDBC drivers and manages data sources.

javax.sql.PooledConnection Represents a physical connection to a data source.

javax.sql.RowSet Encapsulates a set of rows that have been retrieved from a tabular data source.

javax.sql.RowSetMetaData Manages row set meta data information.

javax.sql.XAConnection A XAConnection object is a Pooled Connection object that can participate in a distributed transaction.

javax.sql.XADataSource Provides connections that can participate in a distributed transaction.

 
Is this answer useful? Yes | No
October 04, 2005 03:27:05   
geetha        

RE: What packages are used by JDBC?

Packages are

java.sql and javax.sql only..

Those mentioned in the previous lists are the classes & interfaces in those packages.


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    

 Related Questions

Answered by Jey on 2005-05-10 05:53:50: 1.Statement which is used to run simple sql statements like select and update 2. PrepareStatment is used to run Pre compiled sql.  3. CallableStatement 
Latest Answer : class.forname() , will help you create the class dynamically. ...

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 
Latest Answer : 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 . ...

Latest Answer : Also JDBC2.0 provides extended support for transactions that includes batch updates and savepoints ...

JDBC is a layer of abstraction that allows users to choose between databases. It allows you to change to a different database engine and to write to a single API. JDBC allows you to write database applications 
Latest Answer : JDBC is a core API of Java 1.1 and later which provides a standard set of interfaces to SQL-compliant databases. ...

One implementation interface for database manufacturers, the other implementation interface for application and applet writers. 
Latest Answer : JDBC has four major components:1.The JDBC API2.The JDBC Driver Manager3.The JDBC Test Suite4.The JDBC-ODBC Bridge      The first two components of JDBC,the JDBC API and the JDBC Driver Managermanages to connect to the database ...

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, 
Latest Answer : 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. ...

Create an instance of a JDBC driver or load JDBC drivers through jdbc.driversRegister a driverSpecify a databaseOpen a database connectionSubmit a queryReceive results 
Latest Answer : import java.sql.*;class Type1 { public static void main(String[] args)throws Exception {  Connection c=null;  try  {    Driver d=new Driver("sun.jdbc.odbc.JdbcOdbc");     //or  ...

There are 8 packages: java.sql.Driver, Connection,Statement, PreparedStatement, CallableStatement, ResultSet, ResultSetMetaData, DatabaseMetaData. 
Latest Answer : Packages arejava.sql and javax.sql only..Those mentioned in the previous lists are the classes & interfaces in those packages. ...

A URL string -->getConnection-->DriverManager-->Driver-->Connection-->Statement-->executeQuery-->ResultSet. 
Latest Answer : 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 ...

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 
Latest Answer : 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. ...


 Sponsored Links

 
Related Articles

The Interview Snafu

How to turn someone else’s mistake to your advantage Your dream job is about to become reality. A recruiter gave you the heads up about the perfect position at Humungous Conglomerate, Inc. You went through five interviews as well as a battery of psychological tests mandated by their HR de
 

Winning a Job Interview with a Winning Resume

Does your resume unlock your potential, take your skills to the highest level and win you the interview and the job you want now? The job market today is highly competitive and even if you think you have what it takes to get an interview you won’t get over the line without a polished, prof
 

Importance of Proper English during Job Interview

Importance of Proper English during Job Interview Your job interview is crucially important and it will determine whether or not you will get the job Depending on the type of job you re going for it is very important for you to use proper English In most cases jobs which offer higher salaries will h
 

HR Interview - HR Interview Mistakes You Will Want To Avoid

HR Interview Mistakes You Will Want To Avoid The job interview can be a stressful process This is especially true for those who are going after a competitive position Your nonverbal communication combined with the answers you give during the interview will determine if you are hired mosgoogle While
 

HR Interview - Behavioral HR Interviews

Behavioral HR Interviews As the name implies a behavioral interview is an interview that is held by a human resources department to determine if an applicant has the behaviors that are appropriate for a job The company must know how an applicant will behave in a certain situations mosgoogle The logi
 

HR Interview - How To Prepare For Your HR Interview

How To Prepare For Your HR Interview Before you begin thinking about how you are going to dress for the interview it is important to do your research first You should learn everything you can about the company you wish to work for When you have detailed information about your employer you will conve
 

HR Interview - Telephone Interview Etiquette

Telephone Interview Etiquette When you conduct a telephone interview for a job it is important to show the proper etiquette Not only is it important it is critical is you wish to be hired by the company There are a number of things you will want to do and other things should never be done mosgoogle
 

HR Interview - How To Succeed At HR Interviews

How To Succeed At HR Interviews There are a number of things you will need to do in order to make sure you pass the interview process Your appearance is something that you will want to pay close attention to Even if you feel that your appearance shouldn t be a factor in whether or not you re highere
 

HR Interview - Do's and Dont's in a HR Interview

Do s and Dont s in a HR Interview There are a number of things that you will want to avoid during the HR interview process While some of these things are directed at the interviewer the other things are directed at the applicant If interviewers fail to follow the proper procedures throughout the int
 

HR Interview - HR Interview Tips

HR Interview Tips It has become more challenging for companies to find the right employees because of the market When you hold an interview for a potential employee there are a number of things you will want to keep in mind mosgoogle The goal of a company should be to hire an employee who can perfor
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2010 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape