Create a Simple JPA Query

Create a simple PostgreSQL Database Table psql mydb mydb=#¬†create user john with password ‘secret’; CREATE ROLE mydb=# create table person( personid serial, name varchar(30), age integer, height decimal (4,2) ); NOTICE: CREATE TABLE will create implicit sequence “person_personid_seq” for serial column “person.personid” CREATE TABLE mydb=# grant all on person to john; GRANT mydb=# GRANT USAGE,…

Create a Maven JPA Project

These instructions are for Eclipse or Spring Tool Suite (STS) 1. Make Certain you have a Database Connection Window -> Show View -> Other -> Database Management -> Database Explorer Database Connections -> New -> PostgreSQL -> Next New Driver Definition -> Jar List -> Add Jar Zip select your downloaded PostgreSQL JDBC Jar OK…