Home » Archives for Andres Cespedes » Page 2

Author Archives: Andres Cespedes

Avatar photo
Andres is a Java Software Craftsman from Medellin Colombia, who strongly develops on DevOps practices, RESTful Web Services, Continuous integration and delivery. Andres is working to improve software process and modernizing software culture on Colombia.

JDBC DatabaseMetaData Example

Bipartite Graph

In this example will talk about how to get the Database’s Metadata and what is the usefulness of that information for our development, through the Java API JDBC java.sql.DatabaseMetaData . 1. What is the Metadata ? The Database’s Metadata is information about the data, what? Yes, is data about data, of which are two types of data, structural metadata about ...

Read More »

org.apache.commons.dbcp2.PoolableConnection Example

In this post we learn how to use a connection’s pool using the apache commons dbcp2 framework. A connection pool is an object that maintains a pool of opened connections so the application can simply grab one when it needs to, use it, and then hand it back, eliminating much of the long wait of the creation of connections. 1. ...

Read More »

JDBC Transaction Rollback Example

Bipartite Graph

In this example will talk about how to perform rollback in JDBC transactions. When we are making changes in the database through a java.sql.Connection, it’s necessary prevent it form going to an inconsistent state, in case of an exception for example. So how do we do that? There are some key steps. Manage manually the changes with transactions, disabling the auto ...

Read More »

JDBC Transaction Management Example

Bipartite Graph

In this post, we want to talk about JDBC Transactions and how we can manage the operations in a database. The most popular DBMS like MySQL and Oracle have by default the option autocommit enabled, it means immediately after any DML Operation saves the changes and makes them visible to all users. To use transactions must set the database parameter ...

Read More »