Programming Tutorials

JDBC Tutorials

21. Creating Database Connection Pool in Tomcat 5.0 and Tomcat 5.5 for MySQL and Java

By: Emiley J : 2007-10-12

Description: This tutorial gives you a close look at Jakarta Commons Database Connection Pool (DBCP) in Tomcat 5.0 and Tomcat 5.5. DBCP is the database connection pooling technology built into the popular open-source Tomcat servlet engine. Because it's included with Tomcat, you don't need to download or install any files or libraries.


22. Using Transactions in JDBC

By: Ramlak : 2007-04-06

Description: By default, JDBC classes operate in auto-commit mode. This means that each SQL statement executed is considered a separate transaction ( a singleton transaction) and a commit is made at the completion of the statement. In order to group a set of transactions together, this autocommit mode must be disabled using the connection class setAutoCommit method and passing the method boolean false value.


23. What is the ACID principal?

By: Ramlak : 2007-04-06

Description: The ACID principal is the foundation which has guided the implementation of transactions in relational databases. This acronym stands for the following:


24. Using JDBC to extract data from a database and output to an XML document

By: Nicholas Chase : 2007-04-05

Description: The goal of this tutorial is to show how to create an XML document out of data from


25. How connection pooling works in Java and JDBC

By: Ramlak : 2007-04-04

Description: Connection pooling has become the standard for middleware database drivers. The process of creating a connection, always an expensive, time-consuming operation, is multiplied in these environments where a large number of users are accessing the database in short, unconnected operations. Creating connections over and over in these environments is simply too expensive.


26. A simple JDBC application sample code

By: Ramlak : 2007-04-04

Description: The basic process for a single data retrieval operation using JDBC would be as follows


27. The Structure of JDBC

By: Ramlak : 2007-04-04

Description: JDBC is composed of a number of interfaces and classes that are implemented by driver developers. There are four different types of JDBC drivers that have been implemented as listed in the table below.


28. JDBC Architecture

By: Sunitha : 2007-03-15

Description: The JDBC API supports both two-tier and three-tier processing models for database access.


29. JDBC Components

By: Sunitha : 2007-03-15

Description: JDBC includes four components: The JDBC API, JDBC Driver Manager, JDBC Test Suite, JDBC-ODBC Bridge


30. What is JDBC?

By: Sun : 2007-03-15

Description: The JDBC API is a Java API that can access any kind of tabular data, especially data stored in a Relational Database.