> 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?
I'd suggest to read the Java Tutorial by Sun:
and after you got the basics, move on to the JDBC trail of the tutorial:
> 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.
A sample attached. Save it to a file called JdbcTest.java, modify the
server address, database name, table name etc. to suite your needs, and
compile with "javac JdbcTest.java". To run, add postgresql.jar to your
classpath. For example:
java -cp path/to/postgresql.jar JdbcTest
In response to
pgsql-jdbc by date
|Next:||From: Heikki Linnakangas||Date: 2006-11-21 10:30:13|
|Subject: Re: exception with a temporary table|
|Previous:||From: Ido M. Tamir||Date: 2006-11-21 09:35:40|
|Subject: Re: Hello World|