Thursday, 18 February 2016

Unit testing in database driven projects

DbUnit is a JUnit extension (also usable with Ant) targeted at database-driven projects that, among other things, puts your database into a known state between test runs. This is an excellent way to avoid the myriad of problems that can occur when one test case corrupts the database and causes subsequent tests to fail or exacerbate the damage.

Managing project dependencies while using Ant

Ivy (The agile dependency manager) - Ivy is a tool for managing (recording, tracking, resolving and reporting) project dependencies. It is characterized by the following:
  1. flexibility and configurability - Ivy is essentially process agnostic and is not tied to any methodology or structure. Instead it provides the necessary flexibility and configurability to be adapted to a broad range of dependency management and build processes.
  2. tight integration with Apache Ant - while available as a standalone tool, Ivy works particularly well with Apache Ant providing a number of powerful Ant tasks ranging from dependency resolution to dependency reporting and publication.
Ivy is open source and released under a very permissive Apache License.

Ivy has a lot of powerful Features, the most popular and useful being its flexibility, integration with ant, and its strong transitive dependencies management engine.

The transitive dependencies management is a feature which lets you get dependencies of your dependencies, transitively. In order to address this general problem, ivy needs to find metadata about your modules, usually in an ivy file. To find the metadata and your dependencies' artifacts (usually jars), Ivy can be configured to use a lot of different repositories.

Open source API

Joda Time - Java date and time API -

Joda-Time provides a quality replacement for the Java date and time classes. The design allows for multiple calendar systems, while still providing a simple API. The 'default' calendar is the ISO8601 standard which is used by XML. The Gregorian, Julian, Buddhist, Coptic, Ethiopic and Islamic systems are also included, and we welcome further additions. Supporting classes include time zone, duration, format and parsing.

Guidelines & Best practices

Refactoring -

CSS Best Practices -

Implement Continuous Integration (Build and Deployment)

Other best practices
  1. Use javadoc tags to imrpove internal documentation quality
  2. Check the software aging signs are not existing
  3. Exception object creation is slow so should be used carefully 
  4. Jenkins best practices
  5. Jenkins configuration backup plugin

Buying a wireless router

Router with best WiFi range -
802.11n Info -
Cable Vs DSL Modem -
Setting up cable modem and Router -
Setting up DSL modem and Router -
Setting up Only Router -
Installing only DSL Router -


maven dependency -

Quartz sample
Tutorial -
Example -

Tutorial -
Quartz cook book -
Documentation  -
Other Module dependencies -
Quartz inside web app-
Quartz available jobs -
API Doc-

Salil's Bookmarks

Way to improve English vocabulary and grammer


Search Engine Optimisation of Blog

Optimizing the site -
Title Optimization -

Improving content and design quality - 
Nicely aligned & formatted code -

<pre  style="border:1px dashed #CCCCCC;width:99%;height:auto;overflow:auto;text-align:left;line-height:20px;"><code style="word-wrap:normal;">

-- Your code goes here


Java vs Groovy

Software design principals

Java interview Preparation

Dependency Injection design pattern -
Intercepting filter -
J2EE Filter Example -
Spring IOC-
Immutable Objects -
Filter life cycle -
Servlet life cycle -
JSP life cycle -
Request Dispatcher -
Star  interview technique -
Understanding reference types -
Implementing a Least-Recently-Used(LRU) Cache -
Object identify and importance of understanding -

Multithreading interview questions

Common Java interview questions urls -

Design Principals -

Scenario Based Questions -
File upload -

Hibernate -

Information for debugging Sybase issue

Business object Basics

Performance tuning of web application

Liquibase - Open source library for tracking managing and applying changes

Tuning the Data Access and Data Layer

There are multiple tweaks if performed on data access and data layer,significant improvement would be visible in the application. List of some such tweaks is as mentioned below -

Tuning Data Layer
  1. Use materialized view, (if suitable) in place of very time consuming queries or views
  2. Use query re-write
  3. Use parallel execution of queries 
  4. Use PARALLEL_DEGREE_LIMIT to control parallization on database level
  5. Partition big tables 
  6. Choosing the right isolation level
  7. Use sql trace and explain plan both to analyze query for tuning
  8. Loading data very fast using partition exchange
  9. Types of index and correct one to choose from

Tuning dataaccess Layer
  1. Identify and resolve select n+1 problem in hibernate
  2. Use in clause in hibernate only if options inside in clause are few  
  3. Avoid using explicit getSession in spring-orm
  4. Use jdbc batch while firing multiple query using jdbc 
  5. Prefer batch operation in hibernate while executing multiple queries 
  6. Prefer ordered collection over sorted collection in hibertnate
  7. Prefer parametrized SQL over completed sql created at run time
  8. For batch operations prefer 11g version driver for better performance

jQuery - javascript library

Oracle Pl/SQL programming

JavaScript Fundamentals

Improving Application Performance

Compressing files on Apache with mod_deflate  -

Apache mod deflate -

Minify Javascript and CSS with YUI Compressor -

Force reload of updated CSS and Javascript files with unique filenames -

Mod index -
mod_expires -
Dynamic loading images - Performance of various java Script frameworks -

Spelling Correction

Wrong Spelling
Right Spelling


connive Secretly allow (something considered immoral, illegal, wrong, or harmful) to occur you have it in your power to connive at my escape
vie contend for superiority Congress vies for more LS seats
rejig to rearrange, alter, or manipulate, sometimes in a slightly unscrupulous way Under fire for letting Pak off hook,govt to rejig position
quash to make void, annul, or set aside (a law, indictment, decision, etc.) HC quashes four-year police case against teenage volunteer
satiated satisfied, as one's appetite or desire, to the point of boredom. Defence min eats his words, BJP satiated
turn turtle to overturn; upset Actor's car turns turtle at Oshiwara on way back from friend's party
mayhem random or deliberate violence or damage "There was mayhem in Kishtwar town for over 8 hours. This situation should have been brought under control immediately," Arun Jaitley said in Rajya Sabha
indigenous inherent; natural;originating in and characteristic of a particular region or country; Indigenous aircraft carrier INS Vikrant launched
Spar to bandy words; dispute. Manmohan, Subbarao spar over RBI's policies

Jenkins Concepts