Install PostgreSQL9.1.9 Database Server on Fedora 17

"PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness."  The following are the steps to install PostgreSQL9.1.9 in Fedora17.Step-1: Change to root user[ranga@ranga ~]$ suPassword: [root@ranga ranga]#Step-2: Install PostgreSQL Server[root@ranga ~]# yum install...

Read More

How to reset the MySQL Server admin/root Password

The following are the steps to restore/reset MySQL admin/root password:Step-1: Stop your MySQL serverThere are many ways to do this:service mysql stop  orservice mysqld stop[root@ranga ranga]# service mysqld stopStep-2: Start your MySQL server in safe mode by using following command.mysqld_safe --skip-grant-tables --autocloseIt will start the MySQL server with out asking any passwords. [root@ranga ranga]# mysqld_safe --skip-grant-tables --autocloseStep-3: Connect to MySQL server.[root@ranga ranga]# mysqlWelcome to the MySQL monitor. Commands...

Read More

Hibernate4 example by using PostgreSQL DB.

Prerequisite requirement - Installed and configured Maven, MySQL, Eclipse IDE.- See more at: http://www.developer.am/documentation/hibernate/?page=maven-spring-hibernate-mysql-example#sthash.8UVHMaBr.dpufPrerequisite requirement - Installed and configured Maven, MySQL, Eclipse IDE.- See more at: http://www.developer.am/documentation/hibernate/?page=maven-spring-hibernate-mysql-example#sthash.8UVHMaBr.dpufPrerequisite requirement - Installed and...

Read More

List of Hibernate SQL Dialects (hibernate.dialect)

Purpose: We all know there are different versions of Oracle... Oracle 11g, Oracle 10g, Oracle9i, Oracle8. The driver we would use would be a common for all of these. But the dialect we use is specific to each one of them, which helps Hibernate in generating optimized queries to those specific versions of database. Dialect (hibernate.dialect)  is a property of hibernate, which is used to connect to particular database. Hibernate supports many databases. This property makes Hibernate generates the appropriate SQL for the chosen database. This...

Read More

Hibernate4.X Application example by using Maven

Prerequisite requirement - Installed and configured Maven, MySQL, Eclipse IDE.- See more at: http://www.developer.am/documentation/hibernate/?page=maven-spring-hibernate-mysql-example#sthash.8UVHMaBr.dpufPrerequisite requirement - Installed and configured Maven, MySQL, Eclipse IDE.- See more at: http://www.developer.am/documentation/hibernate/?page=maven-spring-hibernate-mysql-example#sthash.8UVHMaBr.dpufPrerequisite requirement - Installed and configured Maven, MySQL, Eclipse IDE.- See more at: http://www.developer.am/documentation/hibernate/?page=maven-spring-hibernate-mysql-example#sthash.8UVHMaBr.dpu...

Read More