Problem with connection from win to linux - Mailing list pgsql-jdbc

From skala@gympoh.edu.sk
Subject Problem with connection from win to linux
Date
Msg-id 1095064159.41455a5f3d88e@www.gympoh.edu.sk
Whole thread Raw
List 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);
?>

pgsql-jdbc by date:

Previous
From: Antonini Roberto
Date:
Subject: function parameters
Next
From: Kris Jurka
Date:
Subject: Re: function parameters