Friday Nov 16, 2012

Hibernate, PostgreSQL, Ubuntu, NetBeans IDE (Part 1)

While setting up PostgreSQL from scratch, with the aim to use it in NetBeans IDE together with Hibernate, I found the following resources helpful:

http://railskey.wordpress.com/2012/05/19/postgresql-installation-in-ubuntu-12-04/

http://ohdevon.wordpress.com/2011/09/17/postgresql-to-netbeans-1/

http://ohdevon.wordpress.com/2011/09/19/postgresql-to-netbeans-2/

For quite a while I had problems relating to  "/var/run/postgresql/.s.PGSQL.5432", which had something to do with "postmaster.pid", which I somehow solved via a link I can't find anymore, and which may not have been a problem to begin with.

A key moment was this one, which was useful for setting the password of a new user I'd created:

http://stackoverflow.com/questions/7695962/postgresql-password-authentication-failed-for-user-postgres

This was useful for setting up a table in my database, which I did by pasting in the below into NetBeans after I made the connection there:

http://use-the-index-luke.com/sql/example-schema/postgresql/where-clause

Now I have a database set up with all permissions everywhere (which turned out to be the hard part) correct:

The next step will be to create a NetBeans Platform application based on this database. I'm assuming it shouldn't be any different to what's described in the NetBeans Platform CRUD Tutorial. But I'll be using Hibernate, instead of EclipseLink.

About

Geertjan Wielenga (@geertjanw) is a Principal Product Manager in the Oracle Developer Tools group living & working in Amsterdam. He is a Java technology enthusiast, evangelist, trainer, speaker, and writer. He blogs here daily.

The focus of this blog is mostly on NetBeans (a development tool primarily for Java programmers), with an occasional reference to NetBeans, and sometimes diverging to topics relating to NetBeans. And then there are days when NetBeans is mentioned, just for a change.

Search

Archives
« November 2012 »
SunMonTueWedThuFriSat
    
11
13
14
15
24
25
 
       
Today