How to setup a new PostgreSQL-database in pgAdmin and Glassfish embedded within NetBeans?

In order to get a working Glassfish enviroment with a database to work with, we have to setup a new database first.

Open pgAdmin, and make a new database via this way:

After We’ve done that, we setup glassfish:

If you want to debug via a socket port, apply these two steps:

An instance of Glassfish has been created now. Let’s add the database to it:

Advertisement

I want to develop a java-ee-maven-wicket-postgresql application on Windows!

What you’ll need:
– A windows environment ( WinXP or Win7 are recommended )
– A ‘recently enough’ version of JDK of Java. ( 6u29 )
– A ‘recently enough’ version of PostgreSQL ( 9.1.0-1 )
– A ‘recently enough’ version of  Netbeans ( 7.0.1 )
– A ‘recently enough’ version of Maven 2, Standalone installer(because accessing the build-in maven of netbeans via cmd is surprisingly hard ). ( 3.0.3 )
– A ‘recently enough’ version of Wicket ( 1.5.3 )

Begin with installing the JDK, I’m using version 1.6u29, since I’ve read rumours about that version 7 isn’t stable enough yet. Time will tell. I didn’t tried to install Java EE SDK including Glassfish, because NetBeans has an embedded Glassfish instance at its own.

Please note that you don’t have to install pgAdmin ( the admin tool for your PostgreSQL DB ), it’s already included in the PostgreSQL installer.

Note that you’ve to unpack Maven by yourself, and don’t forget to add it to your (system) path of your system environment, create also two new system environment variables: JAVA_HOME ( preferably  C:\Program Files\Java\jre6\ WITHOUT quotes ) and CLASSPATH ( .;%JAVA_HOME%\lib ).