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:

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:

John,

I had the same problem when I was running 7.0.3 - I may be wrong, but it
seems the driver's presentation of the system catalog is pretty limited,
so that's what you're stuck with.

The newer 7.1 driver does not suffer from this problem, but I am not sure
if it's backwards-compatible with 7.0.3. I am running 7.1RC2 with its
included JDBC driver and it works very nicely for me.

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:

Note: I'm dropping General due to the volume of emails. Please ensure that all
JDBC questions go to the pgsql-jdbc list.

Quoting John Menke <john@eagleinfosystems.com>:

Is anybody able to access Postgresql from the JBuilder4 Explorer?

As JBuilder is used to develop the driver now, yes ;-)

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)

With JBuilder its different. You have to tell it about the driver.

Not sure about the other versions, but for JBuilder 4 Enterprise:

1: Tools -> Configure Libraries

Create a new library, call it PostgreSQL and add the jar file to the library.

2: Tools -> Enterprise Setup

Switch to the Database Drivers tab, click add and select the PostgreSQL library.

You should then see PostgreSQL.config appear.

Click OK, then shutdown and restart JBuilder.

I have also tried just postgresql.Driver as the Driver name.... and I
get the same thing.

No, all post 7.0 drivers have org. prefixing them.

Peter

--
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/

Quoting "Norman J. Clarke" <norman@combimatrix.com>:

John,

I had the same problem when I was running 7.0.3 - I may be wrong, but
it seems the driver's presentation of the system catalog is pretty
limited, so that's what you're stuck with.

Partly the values passed to getTables() defining what are Tables, System tables
etc are not defined in the standard, and also not having access to JBuilder
until recently hampered fixing it.

The newer 7.1 driver does not suffer from this problem, but I am not
sure if it's backwards-compatible with 7.0.3.

No, as the system tables in 7.1 differ to 7.0.x, and the queries behind some of
the MetaData methods are different.

I am running 7.1RC2 with its
included JDBC driver and it works very nicely for me.

Should do as JBuilder4 Enterprise is what I'm using as an IDE now.

Peter

--
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/

The newer 7.1 driver does not suffer from this problem

Can you tell me where to download this driver or post it here? I haven't
received a response to my previous post about where to download the driver
from. There are no links on the following page:

http://jdbc.postgresql.org/download for 7.1 or the beta drivers.

So, if anyone has it, can you send it to me, please, or post it here!! I
have received several emails from other people on this list, wanting it too.

--heather grace
heather@radiovoodoo.com

----- Original Message -----
From: "Peter T Mount" <peter@retep.org.uk>
To: "Norman J. Clarke" <norman@combimatrix.com>
Cc: "John Menke" <john@eagleinfosystems.com>;
<pgsql-general@postgresql.org>; <pgsql-jdbc@postgresql.org>
Sent: Thursday, April 05, 2001 4:45 AM
Subject: [JDBC] RE: [GENERAL] JBuilder4 JDBC Explorer

Quoting "Norman J. Clarke" <norman@combimatrix.com>:

John,

I had the same problem when I was running 7.0.3 - I may be wrong, but
it seems the driver's presentation of the system catalog is pretty
limited, so that's what you're stuck with.

Partly the values passed to getTables() defining what are Tables, System

tables

etc are not defined in the standard, and also not having access to

JBuilder

until recently hampered fixing it.

The newer 7.1 driver does not suffer from this problem, but I am not
sure if it's backwards-compatible with 7.0.3.

No, as the system tables in 7.1 differ to 7.0.x, and the queries behind

some of

Quoting Heather Grace <heather@radiovoodoo.com>:

The newer 7.1 driver does not suffer from this problem

Can you tell me where to download this driver or post it here? I
haven't received a response to my previous post about where to download the
driver from. There are no links on the following page:

I'm slowly going through the mail backlog...

http://jdbc.postgresql.org/download for 7.1 or the beta drivers.

So, if anyone has it, can you send it to me, please, or post it here!!

The lists are not for posting binaries. Please do not post any attachment to
the list!

I
have received several emails from other people on this list, wanting it
too.

I am working on it, but I am having both time problems and problems with the
jdk's at home to produce the 5 different versions of the jar file. I will get
them online by the time 7.1 is released, but it isn't my current priority.

Peter

--heather grace
heather@radiovoodoo.com

----- Original Message -----
From: "Peter T Mount" <peter@retep.org.uk>
To: "Norman J. Clarke" <norman@combimatrix.com>
Cc: "John Menke" <john@eagleinfosystems.com>;
<pgsql-general@postgresql.org>; <pgsql-jdbc@postgresql.org>
Sent: Thursday, April 05, 2001 4:45 AM
Subject: [JDBC] RE: [GENERAL] JBuilder4 JDBC Explorer

Quoting "Norman J. Clarke" <norman@combimatrix.com>:

John,

I had the same problem when I was running 7.0.3 - I may be wrong,

but

it seems the driver's presentation of the system catalog is pretty
limited, so that's what you're stuck with.

Partly the values passed to getTables() defining what are Tables,

System
tables

etc are not defined in the standard, and also not having access to

JBuilder

until recently hampered fixing it.

The newer 7.1 driver does not suffer from this problem, but I am

not

sure if it's backwards-compatible with 7.0.3.

No, as the system tables in 7.1 differ to 7.0.x, and the queries

behind
some of

the MetaData methods are different.

I am running 7.1RC2 with its
included JDBC driver and it works very nicely for me.

Should do as JBuilder4 Enterprise is what I'm using as an IDE now.

Peter

--
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/

---------------------------(end of

broadcast)---------------------------

TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

--
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/