Skip site navigation (1) Skip section navigation (2)

RE: Using jdbc with JBuilder 3.5

From: Peter Mount <petermount(at)it(dot)maidstone(dot)gov(dot)uk>
To: "'John Collins'" <jcollins(at)cs(dot)umn(dot)edu>, pgsql-interfaces(at)hub(dot)org
Subject: RE: Using jdbc with JBuilder 3.5
Date: 2000-08-14 06:48:51
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
I've been trying to get JBuilder to work with the driver for ages (actually
a couple of years now). However, the main problem I've had is that I haven't
got JBuilder to hand (well I have, but not the important Database

What we need to get it to work, is to know what JBuilder is passing to the
getTables() and getColumns() methods in DatabaseMetaData. If we knew that,
then we could get the driver to respond correspondingly.


Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council

-----Original Message-----
From: John Collins [mailto:jcollins(at)cs(dot)umn(dot)edu]
Sent: Friday, August 11, 2000 6:16 PM
To: pgsql-interfaces(at)hub(dot)org
Subject: [INTERFACES] Using jdbc with JBuilder 3.5

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 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
a password into postgres for the username I was using, so I tried not giving
username.  That produced an exception about an empty username.  So, I went
and added a password for the user, and still nothing.  At this point I tried
simple example in java from the JDBC tutorial, which just opens a database
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
and changed the "trust" settings to "password pg_pwd".  I stopped and
the postmaster, and then I could connect, with both the JDBC Explorer and
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
to be identical when expanded.  Although the tables don't show up in the
browser pane, if I bring up the "Enter SQL" tab, I can do queries against
database and get the correct results.

I'm a bit of a newbie in this area, so I may have missed something obvious.
haven't found much documentation on the jdbc driver itself; when I go to the site, I see one pdf file with a bit of info about the
and several others that appear to be about postgres itself.

Any pointers would be much appreciated.  Thanks in advance.

John Collins
University of Minnesota

pgsql-interfaces by date

Next:From: Peter MountDate: 2000-08-14 07:13:06
Subject: RE: Large objects with JDBC
Previous:From: Peter MountDate: 2000-08-14 06:45:29
Subject: RE: JDBC2 support

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group