1)In hbm i code the type "type = "java.sql.timestamp"" but in java pojo it is java.util.Date. Is it correct?

/**
* @hibernate.property
* column = "created_date"
* type = "java.sql.timestamp"
* not-null = "false"
*
*/
public Date getCreatedDate() {
return this.createdDate;
}

2)In the hbm the type is java.util.Date but how about in DB. Is it sure all the database also is timestamp.

3) type = "java.sql.timestamp" VS type = "java.util.Date". How it will affect the DB.

You're mixing up class and type: it's very common. I see many mapping files containing type="java.lang.String", which I find quite amusing.

Hibernate types are defined in org.hibernate.type; you can add to them using your own user types. Those types are named using the class type of the user type; that's usually a long and cumbersome string, so use the <typedef> tag to create an alias for it.

Anyway, to answer your question: you want type="date". Have a look in org.hibernate.type.DateType: you'll see that it converts between java.sql.Date and java.util.Date for you.