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.

Comments:

I can assure you, the steps in the tutorial will work perfectly fine with PostgreSQL as well.

I currently use PostgreSQL in one of my NBP applications, though through SQL directly (Spring JdbcTemplate).

Posted by Christian Michelsen on November 17, 2012 at 08:06 AM PST #

Hi Geertjan

For managing Postgresql you may find pgadmin 3. Helpful and a useful tool. You Should be able to find this in the Ubuntu Software Centre.

David

Posted by David on November 18, 2012 at 04:18 AM PST #

Hi David and Christian, thanks both for the comments. Christian, have you blogged about your NBP applications somewhere? And, yes, David, I've used pgadmin3, cool tool. I've found that the Database Management tools in NetBeans work just as well for the same purpose, i.e., for creating and inspecting databases for PostgreSQL.

Posted by Geertjan on November 18, 2012 at 02:53 PM PST #

Post a Comment:
  • HTML Syntax: NOT allowed
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
« April 2014
SunMonTueWedThuFriSat
  
12
13
14
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today