GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  J2EE  >  JDBC
Go To First  |  Previous Question  |  Next Question 
 JDBC  |  Question 121 of 135    Print  
If you dont close a connection in a Web Application, What will happen?

  
Total Answers and Comments: 1 Last Update: September 07, 2007     Asked by: surbhi jain 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
September 07, 2007 00:57:57   #1  
adaiyurnethaji Member Since: September 2007   Contribution: 1    

RE: If you dont close a connection in a Web Applicatio...
In Web Application if a connection is not closed,it will keep on adding.
At one point error will be dispalyed that maximum number of connections reached.
Only DBA's can kill the connection at that time.
It is always better to close the connection and make it to null in the finally block.

 
Is this answer useful? Yes | No

 Related Questions

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 :          The Connection Creation section described when connections are created. It described how several context instances can share the same connection. In this type of sharing, operations from the different context ...

Latest Answer : 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 properties first and the jndi name that u r defining in //weblogic ...

Answered by Jey Ramasamy on 2005-05-10 05:50:07: Class.forName() is used to load the Driver class which is used to connect the application with Database. Here Driver class is a Java class provided by Database 
Latest Answer : Class.forName is used to create an instance of the driver and register with the DriverManager. ...

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

This involves two steps: (1) loading the driver and (2) making the connection. 
Latest Answer : Steps to follow establish a connection1.import required(sql) package.import java.sql.*;import javax.sql.*;javax.sql-----------------------1Data source 2Connection pooling 3Distributed transactions 5Rowsets 2.Load and register the driver(by using class.forName())Java ...


 Sponsored Links

 
Related Articles

Application Development in .NET

ASP NET 2 0 Tutorials Application development in NET Client Side Application Development Client applications are applications that run on the client system or the desktop of the user They are closest to the traditional windows based applications and they display forms or windows on the desktop enabl
 

N-Tier Application Partitioning

N Tier Application Partitioning Application partitioning is a vital process as it provides one with the opportunity to clearly define an even distribution of an application s presentation process and key data components without which you may find yourself feeling quite lost The components may be dis
 

N-Tier Application Manageability

N Tier Application Manageability While it is a fact that N Tier applications tend to provide almost limitless scalability the desire to change or add new forms of functionality can present a challenge in more than one arena Growth on a large scale can make capacity planning quite hard When available
 

Application Frameworks in SQL Server 2005

The new application framework of SQL called the Service Broker is a distributed application framework that provides relable asynchronous messaging at the database to database level. It allows internal and external processes to exchange streams of reliable asynchronous messages using extensions of T-
 

Rapid Application Development

What is RAD? One of the conveniences of developing software is that it is not a physical tool that can be lost once it gets developed or manufactured. Codes are used to implement the software and it does not disappear together with the product. We can re-use the code all over again in another softw
 

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
 

Effective Controls for Attaining Continuous Application Security

Effective Controls for Attaining Continuous Application Security Throughout the Web Application Development Life Cycle Given the choice, every organization would want secure Web sites and applications from the Web application development phase all the way through the software development life cycle.
 

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
 

Web Application Vulnerability Assessment Essentials

Your First Step to a Highly Secure Web Site If an organization taking a systematic and proactive approach to web security, and to running a web application vulnerability assessment in particular, then that organization defended against the most rapidly increasing class of attacks. &nb
 

Top 10 Application Security Vulnerabilities in Web.config Files - Part One

These days, the biggest threat to an network security comes from its public Web site and the Web-based applications found there. Unlike internal-only network services such as databases-which can be sealed off from the outside via firewalls-a public Web site is generally accessible to anyone who wan
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape