Re: Hello World

Andreas,
I was in a similar situation about two years ago and have, slowly, learned a bit about Java. Java itself is deceptively simple but to use it effectively, you will want to use one of the IDE platforms. I chose Eclipse over the others because it allows native access to SWT and JFace, and because it is open-source and free (like PostgreSQL). Eclipse has a pretty steep learning curve, but being a stubborn German, I stuck with it and now am able to do most things fairly easily. For the beginner, I would recommend investing in the Designer or RCP builder plug-in from Instantiations.

Working on my application, I realized that I could start by writing a basic, generic UI and then add custom features specific to my application later. I made the generic UI available at PgFoundry (the Komo project). It includes database access (password and other settings), as well as general utilities (back up, restore, vacuum). The code isn't perfect, but it works. Hopefully, this will serve as the "Hello World" application you are looking for. Here's the link http://pgfoundry.org/projects/komo-client/<http://pgfoundry.org/projects/komo-client/>

Michael Schmidt

----- Original Message -----
From: Andreas<mailto:maps(dot)on(at)gmx(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org<mailto:pgsql-jdbc(at)postgresql(dot)org>
Sent: Monday, November 20, 2006 11:00 PM
Subject: [JDBC] Hello World

Hi,

first of all I'll have to confess I don't know next to nothing at all
about JAVA, yet.
On the other hand I'm not exactly new to programming nor PostgreSQL either.

Is there a "Hello World" level sample for jdbc with PG?

Lets suppose I allready have a running PG with a db db_test that has a
few tables among which there is tbl_test in schema s.
The db-server might be 192.168.0.100.
User could be "user1" with password "pw1".

What would be minimally needed to connect to db_test and read the
content of tbl_test to the console and logg off from PG.

I'd prefer a complete sample code that could be dumped through javac.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq<http://www.postgresql.org/docs/faq>