Re: problem to connect to database

Поиск
Список
Период
Сортировка
Искать
От
Melanie Bergeron
Тема
Re: problem to connect to database
Дата
Msg-id
4006DDBE.9000602@globeecom.com
Ответ на
Список
Дерево обсуждения
problem to connect to database Melanie Bergeron <mbergeron_pg@globeecom.com>
Re: problem to connect to database Dave Cramer <pg@fastcrypt.com>
Re: problem to connect to database Melanie Bergeron <mbergeron_pg@globeecom.com>
Re: problem to connect to database Csaba Nagy <nagy@ecircle-ag.com>
Re: problem to connect to database Jan de Visser <jdevisser@digitalfairway.com>
Re: problem to connect to database Melanie Bergeron <mbergeron_pg@globeecom.com>
Re: problem to connect to database Jan de Visser <jdevisser@digitalfairway.com>
Re: problem to connect to database Erwan Arzur <earzur@netratings.com>
Re: problem to connect to database Melanie Bergeron <mbergeron_pg@globeecom.com>
Re: problem to connect to database Dave Cramer <pg@fastcrypt.com>
Re: problem to connect to database Melanie Bergeron <mbergeron_pg@globeecom.com>
Re: problem to connect to database Erwan Arzur <erwan@free.fr>
Re: problem to connect to database Melanie Bergeron <mbergeron_pg@globeecom.com>
Re: problem to connect to database Arne Stoelck <arne@web.de>
Re: problem to connect to database Paul Thomas <paul@tmsl.demon.co.uk>
Re: problem to connect to database Erwan Arzur <erwan@free.fr>
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("
Error loading driver " + cnfe + "
"); >>> } >>> /* 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("
Error establishing the connection : " + e + >>> "
"); >>> } >>> >>> >>> >>> >>> ---------------------------(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 по дате отправления
От: Paul Thomas
Дата:
От: Jan de Visser
Дата:
FAQ