pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
SLOWNESS ON JDBC INTERFACE
3+ messages / 2 participants
[nested] [flat]

* SLOWNESS ON JDBC INTERFACE
@ 1998-09-25 03:45  Debbie and Mike Meyer <mwmeyer@omeganet.es>
  0 siblings, 1 reply; 3+ messages in thread

From: Debbie and Mike Meyer @ 1998-09-25 03:45 UTC (permalink / raw)
  To: pgsql-interfaces

I've been installing and learning the jdbc driver with 6.3.2.  
The example programs in the ../postgresql/src/interface/jdbc
directory run fine -- except everyone takes a good two
minutes to execute.  

Running in debug, the hangup is on this line:

[Loaded java/net/InetAddressImpl.class from
/usr/lib/jdk-1.1.5/lib/classes.zip]

It halts there for a couple of minutes then makes the connection
quickly.

It's jdk-1.1.5 from the Redhat RPM.  Redhat 5.0 upgraded
to kernel 2.0.35.  postmaster is running with tcpip ( -i option)
The connection is from localhost (127.0.0.1) and the pg_hba.conf is
left at default (with localhost permissions wide open).

It's only a P-75 on a hobby machine, but I think it shud
be more responsive.  Normal commands from within
psql work fine.

Anyone seen this problem or at least have some ideas
how to approach troubleshooting it?

Tks much for any help,

Mike Meyer



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [INTERFACES] SLOWNESS ON JDBC INTERFACE
@ 1998-09-26 10:32  Peter T Mount <peter@retep.org.uk>
  parent: Debbie and Mike Meyer <mwmeyer@omeganet.es>
  0 siblings, 0 replies; 3+ messages in thread

From: Peter T Mount @ 1998-09-26 10:32 UTC (permalink / raw)
  To: Debbie and Mike Meyer <mwmeyer@omeganet.es>; +Cc: pgsql-interfaces

On Fri, 25 Sep 1998, Debbie and Mike Meyer wrote:

> I've been installing and learning the jdbc driver with 6.3.2.  
> The example programs in the ../postgresql/src/interface/jdbc
> directory run fine -- except everyone takes a good two
> minutes to execute.  
> 
> Running in debug, the hangup is on this line:
> 
> [Loaded java/net/InetAddressImpl.class from
> /usr/lib/jdk-1.1.5/lib/classes.zip]
> 
> It halts there for a couple of minutes then makes the connection
> quickly.
> 
> It's jdk-1.1.5 from the Redhat RPM.  Redhat 5.0 upgraded
> to kernel 2.0.35.  postmaster is running with tcpip ( -i option)
> The connection is from localhost (127.0.0.1) and the pg_hba.conf is
> left at default (with localhost permissions wide open).

I assume you mean the "host all 127.0.0.1" line is uncommented...

> It's only a P-75 on a hobby machine, but I think it shud
> be more responsive.  Normal commands from within
> psql work fine.

Even then it should be more responsive than that.

> 
> Anyone seen this problem or at least have some ideas
> how to approach troubleshooting it?

All of the examples are written on a P133 Linux box, and they show no
problems of this nature.

I have seen this symptom on other systems (nothing to do with postgresql
or java), and it's either been caused by a routing or host lookup failure.

For example: At work, I have a large corporate unix machine. If a PC is
not in that machines /etc/hosts file, then there is a delay of 60-120
seconds before a connection is made.

PS: JDK 1.1.5 is ok for pre v6.4 versions of the driver. In 1.1.6, Sun
fixed a bug in the java.util.Date class, and v6.4 now handles dates how
they should be, so it can break on 1.1.5 or earlier. The earlier drivers
had to add a day when storing them in PreparedStatement.setDate()

Peter

-- 
       Peter T Mount peter@retep.org.uk
      Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
 Java PDF Generator: http://www.retep.org.uk/pdf




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [INTERFACES] SLOWNESS ON JDBC INTERFACE
@ 1998-09-26 19:23  Debbie and Mike Meyer <mwmeyer@omeganet.es>
  0 siblings, 0 replies; 3+ messages in thread

From: Debbie and Mike Meyer @ 1998-09-26 19:23 UTC (permalink / raw)
  To: Peter T Mount <peter@retep.org.uk>; +Cc: pgsql-interfaces

Tks for the clue ..... I had a bogus resolv.conf file and
it wasn't doing lookups correctly.

Appreciate the help.

Mike Meyer


----------
> From: Peter T Mount <peter@retep.org.uk>
> To: Debbie and Mike Meyer <mwmeyer@omeganet.es>
> Cc: pgsql-interfaces@postgreSQL.org
> Subject: Re: [INTERFACES] SLOWNESS ON JDBC INTERFACE
> Date: Saturday, September 26, 1998 12:32 PM
> 
> On Fri, 25 Sep 1998, Debbie and Mike Meyer wrote:
> 
> > I've been installing and learning the jdbc driver with 6.3.2.  
> > The example programs in the ../postgresql/src/interface/jdbc
> > directory run fine -- except everyone takes a good two
> > minutes to execute.  
> > 
> > Running in debug, the hangup is on this line:
> > 
> > [Loaded java/net/InetAddressImpl.class from
> > /usr/lib/jdk-1.1.5/lib/classes.zip]
> > 
> > It halts there for a couple of minutes then makes the connection
> > quickly.
> > 
> > It's jdk-1.1.5 from the Redhat RPM.  Redhat 5.0 upgraded
> > to kernel 2.0.35.  postmaster is running with tcpip ( -i option)
> > The connection is from localhost (127.0.0.1) and the pg_hba.conf is
> > left at default (with localhost permissions wide open).
> 
> I assume you mean the "host all 127.0.0.1" line is uncommented...
> 
> > It's only a P-75 on a hobby machine, but I think it shud
> > be more responsive.  Normal commands from within
> > psql work fine.
> 
> Even then it should be more responsive than that.
> 
> > 
> > Anyone seen this problem or at least have some ideas
> > how to approach troubleshooting it?
> 
> All of the examples are written on a P133 Linux box, and they show no
> problems of this nature.
> 
> I have seen this symptom on other systems (nothing to do with postgresql
> or java), and it's either been caused by a routing or host lookup
failure.
> 
> For example: At work, I have a large corporate unix machine. If a PC is
> not in that machines /etc/hosts file, then there is a delay of 60-120
> seconds before a connection is made.
> 
> PS: JDK 1.1.5 is ok for pre v6.4 versions of the driver. In 1.1.6, Sun
> fixed a bug in the java.util.Date class, and v6.4 now handles dates how
> they should be, so it can break on 1.1.5 or earlier. The earlier drivers
> had to add a day when storing them in PreparedStatement.setDate()
> 
> Peter
> 
> -- 
>        Peter T Mount peter@retep.org.uk
>       Main Homepage: http://www.retep.org.uk
> PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
>  Java PDF Generator: http://www.retep.org.uk/pdf



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~1998-09-26 19:23 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-09-25 03:45 SLOWNESS ON JDBC INTERFACE Debbie and Mike Meyer <mwmeyer@omeganet.es>
1998-09-26 10:32 ` Peter T Mount <peter@retep.org.uk>
1998-09-26 19:23 Re: [INTERFACES] SLOWNESS ON JDBC INTERFACE Debbie and Mike Meyer <mwmeyer@omeganet.es>

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