Sathish Kandasamy sathish-io

## Eclipse - How to add full name in the @author section
Eclipse/STS uses windows login a/c name as a author name for any new java source file that you create. This is default settings.

Sample author section created when windows login a/c is sathish
/**
 * @author sathish
 *
 */

Its good pracite to show full author name.

## Hibernate Caching
Good article about Hibernate Caching(First-level cache vs Second-level cache)

http://www.javabeat.net/2007/10/introduction-to-hibernate-caching/
http://blog.streamlinelogic.ca/2007/03/nhibernate-cache.html


## Data base design: Naming Conventions
Refer some basic naming conventions while designing data base schema,

http://www.oracle-base.com/articles/misc/naming-conventions.php
http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:6729304326802

## Basic JDBC Test Code
package com.satlabs.helper;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DBConnectionHelper {

## Oracle 11g RAC(SCAN)
Oracle RAC in 11g:-

Single Client Access Name (SCAN)
====================================

JDBC clients to connect to Oracle SCAN should use jdbc url - jdbc:oracle:thin:@sales1-scan:1521/oltp instead of jdbc:oracle:thin:@sales1-scan:1521:oltp

Oracle SCAN documentation for  Developer view:-

http://www.oracle.com/technetwork/products/clustering/overview/scan-129069.pdf

## REST,Jersey - Content negotiation via URI extensions
If you have REST service that wanted to return both JSON & XML type, then one way is to set media type in the REST HTTP request header in "Accept" field

Setting media type in HTTP header:

GET /books/123
Accept:  application/json (or application/xml)

Other way is to set the return type in URI extensions as,

GET /books/123.json   - to return json format

## Linux:Count occurrences of text
fgrep -o SATHISH  file.txt | wc -l

Here, SATHISH is the text to count

## Add Jetty plugin to maven project
Add below under <plugins></plugins> section in the pom file


  <plugin>
    <groupId>org.mortbay.jetty</groupId>
    <artifactId>maven-jetty-plugin</artifactId>
  </plugin>


## wget command - to access web page in console
To print the html page content in the console, instead of creating in file, use
wget  -qO-  www.google.com

## Enterprise Spring Best Practices
Enterprise Spring Best Practices

http://gordondickens.com/wordpress/2012/07/03/enterprise-spring-best-practices-part-1-project-config/
	Eclipse/STS uses windows login a/c name as a author name for any new java source file that you create. This is default settings.

	Sample author section created when windows login a/c is sathish
	/**
	* @author sathish
	*
	*/

	Its good pracite to show full author name.
	Good article about Hibernate Caching(First-level cache vs Second-level cache)

	http://www.javabeat.net/2007/10/introduction-to-hibernate-caching/
	http://blog.streamlinelogic.ca/2007/03/nhibernate-cache.html
	Refer some basic naming conventions while designing data base schema,

	http://www.oracle-base.com/articles/misc/naming-conventions.php
	http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:6729304326802
	package com.satlabs.helper;

	import java.sql.Connection;
	import java.sql.DriverManager;
	import java.sql.PreparedStatement;
	import java.sql.ResultSet;
	import java.sql.SQLException;

	public class DBConnectionHelper {
	Oracle RAC in 11g:-

	Single Client Access Name (SCAN)
	====================================

	JDBC clients to connect to Oracle SCAN should use jdbc url - jdbc:oracle:thin:@sales1-scan:1521/oltp instead of jdbc:oracle:thin:@sales1-scan:1521:oltp

	Oracle SCAN documentation for Developer view:-

	http://www.oracle.com/technetwork/products/clustering/overview/scan-129069.pdf
	If you have REST service that wanted to return both JSON & XML type, then one way is to set media type in the REST HTTP request header in "Accept" field

	Setting media type in HTTP header:

	GET /books/123
	Accept: application/json (or application/xml)

	Other way is to set the return type in URI extensions as,

	GET /books/123.json - to return json format
	fgrep -o SATHISH file.txt \| wc -l

	Here, SATHISH is the text to count
	Add below under <plugins></plugins> section in the pom file


	<plugin>
	<groupId>org.mortbay.jetty</groupId>
	<artifactId>maven-jetty-plugin</artifactId>
	</plugin>
	To print the html page content in the console, instead of creating in file, use
	wget -qO- www.google.com
	Enterprise Spring Best Practices

	http://gordondickens.com/wordpress/2012/07/03/enterprise-spring-best-practices-part-1-project-config/