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

From Csaba Nagy
Subject Re: problem to connect to database
Date
Msg-id 1074185825.30548.54.camel@coppola.ecircle.de
Whole thread Raw
In response to Re: problem to connect to database  (Melanie Bergeron <mbergeron_pg@globeecom.com>)
List pgsql-jdbc
It means telnet has a different syntax. Try 'man telnet' if you're on
Unix/Linux. Then do the following:
  - you have to replace 'host' with the DNS name (or IP address) of your
computer running the postgres server;
  - use the syntax:

telnet your.host.address 5432

Than post the result, and hopefully the others can help again :)

HTH,
Csaba

On Thu, 2004-01-15 at 17:38, 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
tocause 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


pgsql-jdbc by date:

Previous
From: Jan de Visser
Date:
Subject: Re: problem to connect to database
Next
From: Paul Thomas
Date:
Subject: Re: SQLSTATE with pg74.1jdbc3.jar