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, … Continue reading Create a Simple JPA Query


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 … Continue reading Create a Maven JPA Project

Creating a Simple Postgres Database

Download and install Postgres Download Postgres from the Download Site For the Mac, download the Postgres App Edit the Path Variable On a Mac Open a Terminal Session Add the following line to your .profile export PATH=$PATH:/Applications/ run your .profile . ./.profile Start the Postgres Database by clicking the Postgres app Create a Database psql … Continue reading Creating a Simple Postgres Database