Blog Archives

Checkstyle & Maven Tutorial

Step 1: The pom.xml with the checkstyle plugin and properties.

Step 2: The checkstyle files that define the rules.



Step 3: Running via mvn command.

Read more ›

Findbugs and Maven tutorial

Findbugs is an open source project for a static analysis of the Java bytecode to identify potential software bugs.


Step 1: The pom.xml with the findbug & site reporting plugins and properties.

Step 2: Exclude certain classes with an exclude filter


Step 3: Running mvn command to spot bugs

Step 4: Running mvn command to report bugs

this creates the file “findbugs.html”

Read more ›

Maven and Cobertura Tutorial

Cobertura is a free code coverage tool, which calculates the percentage of Java code accessed by unit tests.

Step 1: The pom.xml file with the relevant reporting plugins. The properties also shown to set the coverage percentage and to skip code coverage or not.

Read more ›

Notepad++ beginner tutorial

You can download Notepad++ from It is a very handy productivity boosting tools. Q. Why is Notepad++ is a very handy tool? A.  Notepad++ is a very handy developer tool. Here are some of the productivity benefits of Notepad++. … Read more ›...

Notepad++ productivity tips with SQL trigger code example

One of the traits of good developers is that being lazy and this laziness leads to finding productive ways to perform a task. Recently, I had to create a number of triggers to a few existing tables. It is quite a repetitive task, hence I decided to use notepad++ regex...

Notepad++ to construct SQL where clause

Lets take a tutorial like scenario to demonstrate power of Notepad++ as a  developer productivity tool. Q. How will you extract rule_name values from a tabular data shown below and convert it to an SQL query as shown below as well? This data could com from an excel spread sheet,…...

Notepad++ with the power of regex for productivity tutorial

This post is based on a industrial example where you have a CSV file where you want to add quotes (i.e. “) around it. For example

Convert text like:


Another reason you might want to do this in Java is to construct a String array or list as shown below.

Read more ›

Power of Excel spreadsheet to dynamically generate SQL

When you have some data in tabular (e.g. Excel spreadsheet) format and would like to insert into a database table, you need to write an SQL insert query. Manually writing SQL query for multiple records can be cumbersome. This is where Excel spreadsheet comes in handy as demonstrated below. A single SQL query can be copied down where the formulas get copied with incrementing column numbers.

Read more ›

Power of SQL as a productivity tool

There are times where you need to generate “INSERT” SQL statements from existing data. For example, you may have a production release ready “Delete” SQL statement as shown below to remove some existing records. For this script, you need to have a rollback script to insert the values back in....

800+ Java Q&As & tutorials