Ran across
Project Phobos the other day. It looks like a promising platform for rapid web application development. In a short while and after some input from the mailing list, I modified the JPA example to use PostgreSQL as the data store. Turned out to be a very easy switch from the builtin Netbeans JAVA DB to Pg.
To alter the JPA example to use PostgreSQL.
File/New Project/Scripting/Samples/Java Persistence APIs (JPA)
sample
Right click on libraries under jpaExample and add the
PostgreSQL JDBC library
Replace the current persistence properties with
( right click image to open in a new window )
verify that the pg_userid and pg_userpasswd can connect to the db
via psql on the command line
right click on jpaexamplesrc and clean and build the project
right click on jpaExample and run project.
I don't think I missed noting anything.
The web page( right click image to open in a new window ):
-------------------------------------------------------------
The correlating terminal capture from Pg.
jake@endpoint:~$ psql test
Welcome to psql 8.2.5, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
test=# \d
List of relations
Schema | Name | Type | Owner
--------+----------------------+----------+-------
public | author | table | jake
public | author_author_id_seq | sequence | jake
public | book | table | jake
(3 rows)
test=# \d author
Table "public.author"
Column | Type | Modifiers
--------------+------------------------+------------------------------------------------------------
author_id | integer | not null default nextval('author_author_id_seq'::regclass)
organisation | character varying(255) |
name | character varying(255) |
Indexes:
"author_pkey" PRIMARY KEY, btree (author_id)
test=# \d book
Table "public.book"
Column | Type | Modifiers
---------------+------------------------+-----------
book_id | integer | not null
isbn | character varying(255) |
authorid | integer |
publisheddate | date |
title | character varying(255) |
Indexes:
"book_pkey" PRIMARY KEY, btree (book_id)
test=# select * from author;
author_id | organisation | name
-----------+----------------+-----------------
1 | jMaki | Greg Murray
2 | Sun US | Ludo Champenois
3 | Java Inc | James Gosling
4 | Wrox Press Inc | Paul Wilton
5 | O'Reilly | Danny Goodman
6 | JPA Press Inc | Pramod Gopinath
(6 rows)
test=# select * from book;
book_id | isbn | authorid | publisheddate | title
---------+------+----------+---------------+-------
(0 rows)
