answersLogoWhite
Master of Computer Applications MCA
General Educational Development (GED)

What happens if connection is not closed in a jdbc program?

123

Top Answer
User Avatar
Wiki User
2013-03-05 10:53:00
2013-03-05 10:53:00

if we don't close the connection , it wil lead to connection memory leakage.unless until application server/web server is shut down ,connection wil remain activate even though the user logs out .

1

Related Questions

User Avatar

JDBC stands for Java Database Connectivity. A JDBC connection is required for every java program that wants to connect to a database for data

User Avatar

General JDBC Architecture consist of two layers: JDBC API - this provides the application to JDBC manager connection. JDBC driver API - this supports the JDBC manager to driver connection.

User Avatar

-Loading the Driver -Establish a Connection -Execute Statements -Get Resultset -Close the database connection

User Avatar

JDBC Driver Manager is a class that manages a list of database drivers. It matches connection requests from the java application with the proper database driver using communication sub protocol.

User Avatar

JDBC is short for java database connectivity. There are 4 type of JDBC drivers : 1) JDBC-ODBC 2) Native-API 3) JDBC-Net 4) Native-Protocol.

User Avatar

Ans:Loading a class in JDBC For getting connection to database and to query database for INSERT,UPDATE,DELETE and to do some operations on database through java programs you need to load the jdbc driver class for a particular database provided by the database provider for that you use class.forName() Method this method will load the class which are necessary for database operations

User Avatar

JDBC mean Java Database Connectivity. In java, using JDBC drivers, we can connect to database. Steps to connect to JDBC. 1) Load the driver, using Class.forName(DriverName); 2) Get the connection object, Connection con = Driver.getConnection(loaded driver name); 3) Create a SQL statement, Statement s = con.createStatement(); 4) Create Resultset object using the statement created above, ResultSet rs = s.executeQuery("sql statement"); Iterate the result set to get all the values from the database. Finally don't miss this 5) s.close(); 6) con.close() ;

User Avatar

JDBC driver is an interface enabling a java application to interact with a database. To connect with individual database, JDBC requires drivers for each database.

User Avatar

TO connect database two things are require: 1) JDBC driver 2) ognl.jar Using these two we can create a database connection.

User Avatar

Yes. In Java this is done through the JDBC classes.Yes. In Java this is done through the JDBC classes.Yes. In Java this is done through the JDBC classes.Yes. In Java this is done through the JDBC classes.

User Avatar

JDBC is java database API, while JNDI is java native directory API. The main thing in here is that in a JNDI directory you're actually storing a JDBC DataSource, so, you're simply using JDBC and obtain a Connection via JNDI lookup. In short words: JDBC is Database realm, JNDI lets you store Objects in a virtual context (the Directory) that can be local, remote (Implementation details usually don't matters). You access this context via names, obtaining stored objects, is good to share things among different modules. Application Servers usually have a JNDI Context for sharing global objects amon different application, Connection Poolers happen to be one of the most clear example of why sharing via JNDI is good. (Define 1 connection pooler, share between several webapps)

User Avatar

JDBC ODBC BridgeNative API Partly Java DriverNet Protocol full Java driverare some types of jdbc drivers

User Avatar

JDBC comes as part of the standard JDK & JRE set up.

User Avatar

When we create a website or a project in programming language we need to use a database for storing the data . A database connection used to establish a connection between the server and the client. For this jdbc jar is added in the project in case of java .

User Avatar

JDBC stands for Java Database connectivity which is a standard java API for database. It is for database connectivity with project.

User Avatar

There are four types of JDBC driver:JDBC - ODBC bridgeNative-API driverNetwork-Protocol DriverNative-Protocol DriverSee related link for more information.

User Avatar

JDBC which is short for java database connectivity is used to connect database to a java project . To make connectivity a database driver is required to establish the connection.

User Avatar

Use the JDBC functionality to open a connection to SQL Server. You can read up on how here: http://java.sun.com/javase/technologies/database/

User Avatar

Connectivity in database management system is done using is done by making a connection object and using JDBC driver API. For database connectivity ognl.jar should be included in the project.

User Avatar

By using JDBC/hibernet

User Avatar

There are more than one JDBC drivers for Microsoft SQL Server. Each one has a different driver name.

User Avatar

JDBC stands for Java Data Base Connectivity. As the name suggests the package is reposnisble for database connectivity. It is a standard API defined for database access.

User Avatar

JDBC stands for Java Database Connectivity . It was developed by Java soft and is a part of Java Enterprise API. JDBC is the first standardized API that allows the users to develop database front ends without continously rewriting their code. JDBC provides the ability to create robust, platform-independent application and wev-based applets, wihich can acces any database through a DBS-independent mechanism. The interaction between these application and applets with SQL data sources is done through a set of relational database objects and methods defined is the JDBC API.


Copyright © 2020 Multiply Media, LLC. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Multiply.