Skip site navigation (1) Skip section navigation (2)

Re: problem to connect to database

From: Melanie Bergeron <mbergeron_pg(at)globeecom(dot)com>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: problem to connect to database
Date: 2004-01-15 16:38:14
Message-ID: 4006C1F6.1000909@globeecom.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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(at)postgresql(dot)org
>>
>>    
>>



In response to

Responses

pgsql-jdbc by date

Next:From: Jan de VisserDate: 2004-01-15 16:49:26
Subject: Re: problem to connect to database
Previous:From: Melanie BergeronDate: 2004-01-15 16:33:31
Subject: problem starting postmaster as a service

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group