pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Using jdbc with JBuilder 3.5 2+ messages / 2 participants [nested] [flat]
* Using jdbc with JBuilder 3.5 @ 2000-08-11 17:16 John Collins <jcollins@cs.umn.edu> 0 siblings, 0 replies; 2+ messages in thread From: John Collins @ 2000-08-11 17:16 UTC (permalink / raw) To: pgsql-interfaces@hub.org 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* RE: Using jdbc with JBuilder 3.5 @ 2000-08-14 06:48 Peter Mount <petermount@it.maidstone.gov.uk> 0 siblings, 0 replies; 2+ messages in thread From: Peter Mount @ 2000-08-14 06:48 UTC (permalink / raw) To: 'John Collins' <jcollins@cs.umn.edu>; pgsql-interfaces@hub.org 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 components). 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 -- 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@cs.umn.edu] Sent: Friday, August 11, 2000 6:16 PM To: pgsql-interfaces@hub.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 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-08-14 06:48 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2000-08-11 17:16 Using jdbc with JBuilder 3.5 John Collins <jcollins@cs.umn.edu> 2000-08-14 06:48 RE: Using jdbc with JBuilder 3.5 Peter Mount <petermount@it.maidstone.gov.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox