Problem with connection from win to linux

From: skala(at)gympoh(dot)edu(dot)sk
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Problem with connection from win to linux
Date: 2004-09-13 08:29:19
Message-ID: 1095064159.41455a5f3d88e@www.gympoh.edu.sk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello,

I have problem with connection on Postgres through JDBC driver, from my
windows computer to linux server, where is a Postgres database.
Rexo is a linux server name.

Postmaster is running ok and it accepts tcp/ip connection. I have this tested
through small PHP script, located on my win computer. PHP works well. But JDBC
ends with error:
Connection refused. Check that the hostname and port is correct, and that the
postmaster is running with the -i flag, which enables TCP/IP networking.

I have testet three jdbc driver, but the error remains.

The pg_hba file is OK and I think, the postmaster.conf too, but PHP works.

Can anybody help me ? Thanks.

Michal

Here is servlet source:

/*
* Created on 6.9.2004
*/
package j2src.michal;

import java.io.*;
import java.io.IOException;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class DBTest extends HttpServlet {

protected void doGet(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException
{
PrintWriter out = response.getWriter();
try {
Class.forName("org.postgresql.Driver");
Connection con = DriverManager.getConnection
("jdbc:postgresql://rexo:5432/test", "root", "michal");
PreparedStatement pr = con.prepareStatement("Select * from
t_user");
ResultSet result = pr.executeQuery();
while (result.next()) {
String pole = result.getString("login")+"<br>";
out.println(pole);

}
} catch (SQLException ex) {
out.println(ex.getMessage());
} catch (ClassNotFoundException exnf) {
out.println(exnf.getMessage());
}
}
}

PHP script:

<?
$conn = pg_Connect("host=rexo port=5432 dbname=test user=root
password=michal");
$result = pg_exec("select * from t_user");
$p = pg_NumRows($result);
$i = 0;
while ($i<$p):
echo pg_Result($result, $i, "login") . " " .
pg_Result($result, $i, "email") . "<BR>";
$i++;
endwhile;
pg_Close($conn);
?>

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2004-09-13 11:33:04 Re: the PostgreSQL JDBC driver
Previous Message Kris Jurka 2004-09-13 08:09:50 Re: Race condition in