Re: problem to connect to database - Mailing list pgsql-jdbc

I can't use telnet.  If I try [telnet localhost:5432] it always return
the same error message "Connecting To host:5432...Could not open a
connection to host on port 23 : Connect failed" but if I do [netstat
-an], it returns :
...
  TCP    0.0.0.0:5432           0.0.0.0:0              LISTENING
...

Any idea?

Melanie Bergeron wrote:

> No, I can't :
> Connecting To host:5432...Could not open a connection to host on port
> 23 : Connect failed
>
> What does that mean?
>
> Melanie
>
> Dave Cramer wrote:
>
>> Melanie,
>>
>> Can you telnet into the connection ?
>>
>> telnet host:5432
>>
>> Dave
>> On Thu, 2004-01-15 at 10:49, Melanie Bergeron wrote:
>>
>>
>>> Hi all!
>>>
>>> I really need your help for this.  I installed the JDBC driver on my
>>> machine by copying the jar file in C:\Program Files\Apache Software
>>> Foundation\Tomcat 5.0\common\lib\pg73jdbc3.jar and set environment
>>> variable CLASSPATH to this path.  I  create a JSP page (code
>>> below).  The first time I launched this JSP page, all was ok.  I
>>> don't use it since last week but when I try to launched it
>>> yesterday, I got an error to connecting database :
>>>
>>> Error establishing the connection : Something unusual has occured to
>>> cause the driver to fail. Please report this exception: Exception: {0}
>>>
>>> So, I don't think the error come from my code because it already
>>> work with the same code but I don't know what I do to cause this
>>> error now.  Any help will be greatly appreciated.
>>>
>>> Melanie
>>>
>>>
>>> -------code for jsp page---------
>>> <%
>>>  /* Load the JDBC Driver */
>>>  try {
>>>    Class.forName("org.postgresql.Driver");
>>>  }catch(ClassNotFoundException cnfe) {
>>>    out.println("<BR>Error loading driver " + cnfe + "<BR>");
>>>  }
>>>  /* Define the connection URL */
>>>  String dbName = "gec_test";
>>>  String host = "localhost";
>>>  String postgresqlUrl = "jdbc:postgresql://" + host + "/" + dbName;
>>>  /* Establish the connection */
>>>  String username = "bergeron.melanie";
>>>  String password = "*****";
>>>  try{
>>>    Connection connection =
>>> DriverManager.getConnection(postgresqlUrl, username, password);
>>>    ...
>>>    }
>>>    connection.close();
>>>  }catch(SQLException e){
>>>    out.println("<BR>Error establishing the connection : " + e +
>>> "<BR>");
>>>  }
>>>
>>>
>>>
>>>
>>> ---------------------------(end of
>>> broadcast)---------------------------
>>> TIP 1: subscribe and unsubscribe commands go to
>>> majordomo@postgresql.org
>>>
>>>
>>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
> .
>