Postgres Pro
Downloads
Home   >   mailing lists

Thread: Connection Time

Connection Time

From
Martin Jung
Date:
Hi,

using postgres for a long time I noticed an incompatibility after an upgrade
to a newer version of java.
I wrote a small test class (test.java, see attachment) to try my local
database installation.
This is what I got using the latest jdk:
jung@daherrim:~/tmp/test> java -version
java version "1.4.1_02"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.1_02-b06)
Java HotSpot(TM) Client VM (build 1.4.1_02-b06, mixed mode)
jung@daherrim:~/tmp/test> time java -cp .:/usr/share/pgsql/pg73b1jdbc3.jar
Test
Exception in thread "main" java.sql.SQLException: ERROR:  Relation 'test'
already exists

        at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:126)
        at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:451)
        at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:281)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
        at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:200)
        at Test.main(Test.java:7)

real    3m9.731s
user    0m0.654s
sys     0m0.045s

This is what I get using an older jdk version:
jung@daherrim:~/tmp/test> java -version
java version "1.3.1_02"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1_02-b02)
Java HotSpot(TM) Client VM (build 1.3.1_02-b02, mixed mode)
jung@daherrim:~/tmp/test> time java -cp .:/usr/share/pgsql/pg73b1jdbc3.jar
Test
Exception in thread "main" java.sql.SQLException: ERROR:  Relation 'test'
already exists

        at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:126)
        at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:451)
        at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:281)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
        at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:200)
        at Test.main(Test.java:7)

real    0m0.522s
user    0m0.387s
sys     0m0.066s

The version of pgsql is:
jung@daherrim:~/tmp/test> psql --version
psql (PostgreSQL) 7.3.4

Operating system is SuSE Linux 9.0 on an i568 machine.
Is this a known problem? Can I solve this by using some upgrade? I would like
to continue using postgres, but I and my customers need the latest version of
java. The three minute delay in connecting is hardly tolerable.

Thank you for your answer.

Sincereley,
Martin Jung

--
Martin Jung
Bussardstrasse 44, 91088 Bubenreuth
Tel. : +49-9131-932166
Fax. : +49-9131-828699
PGP public key ID: 0x3F2D0402. http://www.keyserver.net

Re: Connection Time

From
Kris Jurka
Date:

On Tue, 6 Jan 2004, Martin Jung wrote:

> Hi,
>
> using postgres for a long time I noticed an incompatibility after an upgrade
> to a newer version of java.
> I wrote a small test class (test.java, see attachment) to try my local
> database installation.

You have not actually attached your test.  I don't expect to find anything
terribly interesting in there, but it would be good to rule that out as
the source of the problem.

> Operating system is SuSE Linux 9.0 on an i568 machine.
> Is this a known problem? Can I solve this by using some upgrade? I would like
> to continue using postgres, but I and my customers need the latest version of
> java. The three minute delay in connecting is hardly tolerable.
>

I find it hard to believe that this is a pg problem as I regularly use the
1.4 jvm as do many others on the list.  Long connnection times are often
the result of a misconfigured dns setup.

Kris Jurka