Hibernate Configuration

Hibernate configuration properties :-

hibernate.dialect : allows Hibernate to generate SQL optimized for a particular relational database.

hibernate.show_sql : Write all SQL statements to console.

hibernate.format_sql : Pretty print the SQL in the log and console.

hibernate.connection.autocommit : Enables autocommit for JDBC pooled connections (it is not recommended)

Hibernate introduction

Hibernate ORM (Hibernate in short) is an object-relational mapping framework for the Java language, providing a framework for mapping an object-oriented domain model to a traditional relational database. Hibernate solves object-relational impedance mismatch problems by replacing direct persistence-related database accesses with high-level object handling functions.

PostgreSQL Basic Queries

SCHEMA

- Create Schema 

CREATE SCHEMA schema_name;

- Rename Schema

ALTER SCHEMA schema_name RENAME to schema_name_new

- Drop Schema

DROP SCHEMA schema_name;