Skip to main content

Liquibase Incremental Database Changes


LiquiBase is used for managing, tracking and applying database changes. It uses XML file for storing incremental changes to data base.These xml file stores both
Database structures(DDL) and codes.LiquiBase is an open source (LGPL) Library

The following are some of the features which attract LiquiBase a lot

1) It is Open Source
2) It is Database independent
3) Supports rolling back changes
4) Supports merging of changes from multiple developers


The XML file which contains input to Liquibase is called databaseChangeLog File.

The following is a example of a empty databaseChangeLog file

<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.8"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.8
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.8.xsd">
</databaseChangeLog>



The following fragment is a changeset, the following changeset defines a table called USERS with three columns.
  <changeSet author="Sidd" id="1.01">
    <comment>Users</comment>
          <createTable tableName="Users" >
            <column name="UsersID" type="BIGINT">
                    <constraints nullable="false" primaryKey="true" primaryKeyName="PK_Users"/>
             </column>
             <column name="USERNAME" type="VARCHAR(20)">
                    <constraints nullable="false"/>
             </column>
         <column name="USEREMAIL" type="VARCHAR(20)">
                <constraints nullable="false"/>
            </column>
    </createTable>
  </changeSet>



Liquibase can take this database changelog and create table automatically.



Getting started with LiquiBase takes four steps:

  1. Create a database change log file.
  2. Create a change set inside the change log file.
  3. Run the change set against a database via the command line or a build script.
  4. Verify the change in the database.

We can run Liquibase in two ways One is by firing commands from the console , or we can Use  Ant Tasks provided by Liquibase and call those task from Ant Build.
In the next post I will write how to work with Ant and Liquibase , probably with a example.

Comments

Post a Comment

Popular posts from this blog

Masking Credit Card number in Java

Sometimes we need to mask crucial information like Credit Card Numbers, CVV numbers etc before storing  or logging the information. This example mask Credit Card Number (Except last 4 Digit) from a Text which contains information along with Credit Card Number.

The following example demonstrates how we can easily mask the credit card with Matcher and Pattern Classes. This Sample Code uses Matcher and Pattern.
Pattern Used in this sample is not optimized for Credit Card Numbers, this pattern will get any numerical numbers in the String Content.  Based on the Credit Card Type a more efficient and Strict RegEx can be used to mask the Credit Card.
/**Mask the Credit card number but last four digit value **/   Pattern PATTERN = Pattern.compile("[0-9]+"); String message = content; Matcher matcher = PATTERN.matcher(message); String maskingChar = "*"; StringBuilder finalMask = new StringBuilder(maskingChar); while …

Converting Java Map to String

Java Collections framework, String manipulation etc is something that we often encounter in Development process.
For processing collections (like checking null/empty, Intersection, Disjunction) We do have some of the very use full libraries.

Some of the Collection related libraries are Apche Commons Collections and Google  Collections(Guava).

Problem Use Case

This article explains how to convert a Java Map to String(and vice versa) using different libraries and technique.

One way is to use StringBuilder(Or String) and loop though the Map and build the String by applying some sort of separator ( for key:value and entry). Here we have to take care of the null value etc.

Without Any Library
If we want to convert the map to a String with key value separator and also individual entry seperator in the resulting String, we have to write code for that. For a simple Map, we have to iterate though the map, take care of the null values etc. Following is a sample to get String built out from Map C…

Invoking EJB deployed on a remote machine

Invoking EJB deployed on a remote machineIn case we are calling remote ejb( ejb deployed on remote machines),The JNDI lookup might lookup like,Properties env = new Properties();env.put(Context.INITIAL_CONTEXT_FACTORY, "org.jnp.interfaces.NamingContextFactory");env.put(Context.PROVIDER_URL, "XX.XXX.XX.XX:1099");env.put("java.naming.factory.url.pkgs", "org.jboss.naming:org.jnp.interfaces"); Context ctx = new InitialContext(env);If we are calling local ejb then we can simply create InitialContext without any parameters.Like,Context ctx = new InitialContext();