This is a great little tutorial on how to access an Apache Derby Database using Hibernate and JPA. Also includes Maven, Tomcat, and JUnit test cases. Hibernate, JPA Tutorial
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 …
