I installed postgres 7.0.2 and the jdk1.2 version of the new jdbc driver
jdbc7.0-1.2.jar in a RH Linux 6.1 system. I am able to add users, create
databases, tables, etc. using the command-line tools and psql. Originally I
set the access rights to local all trust host all 127.0.0.1 255.255.255.255 trust
My first attempt to use the jdbc driver was through the JDBC Explorer in
JBuilder 3.5. I configured the driver and the database URL, but I couldn't
connect because it complained about authentication failure. I had not entered
a password into postgres for the username I was using, so I tried not giving a
username. That produced an exception about an empty username. So, I went back
and added a password for the user, and still nothing. At this point I tried a
simple example in java from the JDBC tutorial, which just opens a database and
inserts a single record. That threw a password authentication exception.
The next thing I tried was specifying password authentication to the JDBC
connect operation, but that also failed. Finally, I went back to pg_hba.conf,
and changed the "trust" settings to "password pg_pwd". I stopped and restarted
the postmaster, and then I could connect, with both the JDBC Explorer and with
my sample application.
Unfortunately, the JDBC Explorer apparently isn't interacting correctly with
the driver. Instead of my tables, what I see in the Explorer is 6 copies of
"SYSTEM INDEX" and one copy of "Procedures". The 6 SYSTEM INDEX entries appear
to be identical when expanded. Although the tables don't show up in the tree
browser pane, if I bring up the "Enter SQL" tab, I can do queries against the
database and get the correct results.
I'm a bit of a newbie in this area, so I may have missed something obvious. I
haven't found much documentation on the jdbc driver itself; when I go to the
www.retep.org.uk site, I see one pdf file with a bit of info about the driver,
and several others that appear to be about postgres itself.
Any pointers would be much appreciated. Thanks in advance.
John Collins
University of Minnesota