slow jdbc postgres connection

From: Stefan Zweig <stefanzweig1881(at)web(dot)de>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: slow jdbc postgres connection
Date: 2007-04-26 09:19:30
Message-ID: 58958572@web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

hi i have the following problem:

when i execute the following query via pgAdminIII i get a result within 31ms

Select version()
result: PostgreSQL 8.1

if try to execute the same query using the jdbc-interface from a java-application the same query needs horrible 4756ms.
my jdbc driver is 8.1-409 JDBC 3
my postgres version is 8.1.8
my JRE-Version: 1.5.0_07

Connection pgconnection = null;

// Load the pgSQL JDBC driver
String pgdriverName = "org.postgresql.Driver";
Class.forName(pgdriverName);

// Create a connection to the "test" database
String pgserverName = "10.100.6.245";
String pgdatabase = "test";
String url = "jdbc:postgresql://" + pgserverName + "/" + pgdatabase + "?characterEncoding=UTF8&useUnicode=true";
String username = "user";
String password = "password";

pgconnection = DriverManager.getConnection(url, username, password);

ResultSet pgresultSet;
Statement pgstatement;
pgstatement = pgconnection.createStatement();

String pgquery;
pgquery="SELECT version()";

long start=System.currentTimeMillis();//start time measurement

pgresultSet = pgstatement.executeQuery(pgquery);

long time=System.currentTimeMillis()-start;//end time measurement

//time =4756ms

pgconnection.close();

if i do the similar query on our mysql database, which is on the same local server, i get quick results, so the reason probably cannot be a slow intranet-connection

any help would be appriciated.

regards. stefan
_______________________________________________________________
SMS schreiben mit WEB.DE FreeMail - einfach, schnell und
kostenguenstig. Jetzt gleich testen! http://f.web.de/?mc=021192

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Stefan Zweig 2007-04-26 09:43:59 Re: slow jdbc postgres connection
Previous Message Kris Jurka 2007-04-25 19:37:58 Re: Question for the XAConnections default autocommit state