RE: JBuilder4 JDBC Explorer

Norman, I have JBuilder connecting to Postgres with the JDBC Explorer, but
all I can't see my tables... all I see are 6 system tables and a procedure
table.  Can you see all your tables?  What Ir really want to do is use the
EntityBean mapper with Postgres but this produces similar problems in that
it connects but cannot see any tables.  Am I using the wrong driver? I am
using  (jdbc7.0-1.1.jar) I have also tried (jdbc7.0-1.2.jar) and have the
same problem.



-----Original Message-----
From: Norman J. Clarke [mailto:norman@combimatrix.com]
Sent: Wednesday, April 04, 2001 9:13 PM
To: John Menke
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] JBuilder4 JDBC Explorer


I had a devil of an annoying time getting JBuilder to do this. Part of my
problem was that I had installed JBuilder in /usr/local (I run it on
Linux) owned by root, and for some operations it needs to be owned by the
person running it. I could get JDBC Explorer to run only when I ran
JBuilder as root.

I ended up reinstalling JBuilder into my /home directory, and then made a
library for the postgres JDBC driver in "User Home" by going to Tools ->
Configure Libraries. It then worked.

If all else fails try copying your jdbc driver jar file into

JAVA_HOME/jre/lib/ext

Then it will be available automatically to all apps without needing to put
it in a claspath, either at the command line or in your JBuilder
configuration.

Hope this helps!

Norm

--------------------------------------
Norman Clarke
Combimatrix Corp Software Development
Harbour Pointe Tech Center
6500 Harbour Heights Pkwy, Suite 301
Mukilteo, WA 98275

tel: 425.493.2240
fax: 425.493.2010
--------------------------------------

On Wed, 4 Apr 2001, John Menke wrote:

> Is anybody able to access Postgresql from the JBuilder4 Explorer?  I have
> the following settings
>
> Driver: org.postgresql.Driver
> URL:   jdbc:postgresql://localhost:5432/databasename
>
> It says:
>
> The driver:  org.postgresql.Driver could not be loaded. This could be a
> problem with the driver itself or that the driver is not on the classpath.
>
>
> I have confirmed that I have included the most recent .jar file on my
> classpath (jdbc7.0-1.1.jar)
>
> I have also tried just postgresql.Driver as the Driver name.... and I get
> the same thing.
>
> What could be the problem?
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>