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

Re: Postgresql 7.4.1 and jdbc errors

From: "Vijay Kiran Kamuju" <infyquest(at)gmail(dot)com>
To: "Dave Cramer" <pg(at)fastcrypt(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Postgresql 7.4.1 and jdbc errors
Date: 2006-06-28 22:37:38
Message-ID: 36bf289b0606281537x6f679cf5yc7d530d9ea2d595b@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
The port i am using for postgresql is 52008, why port 5432
Can you provide the exact url.

On 6/28/06, Dave Cramer <pg(at)fastcrypt(dot)com> wrote:
> Vijay,
>
> This is pretty self-explanatory. Can you telnet to port 5432 on the
> machine you are trying to connect to ?
>
> If so check http://jdbc.postgresql.org for instructions on how to
> connect.
>
> Dave
> On 28-Jun-06, at 2:48 PM, Vijay Kiran Kamuju wrote:
>
> > Hi,
> >
> > I am using Postgresql 7.4.1 and pg74.214.jdbc3.jar.
> > Postgresql is started under port 52008.
> > I am using a java program to connect to the database.
> > I am using java1.4.2_07_b05 on solaris.
> >
> > I am getting the following error.
> >
> > org.postgresql.util.PSQLException: The connection attempt failed
> > because Exception: java.net.NoRouteToHostException: Cannot assign
> > requested address
> > Stack Trace:
> >
> > java.net.NoRouteToHostException: Cannot assign requested address
> >       at java.net.PlainSocketImpl.socketConnect(Native Method)
> >       at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
> >       at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:
> > 171)
> >       at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
> >       at java.net.Socket.connect(Socket.java:452)
> >       at java.net.Socket.connect(Socket.java:402)
> >       at java.net.Socket.<init>(Socket.java:309)
> >       at java.net.Socket.<init>(Socket.java:124)
> >       at org.postgresql.core.PGStream.<init>(PGStream.java:47)
> >       at org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection
> > (AbstractJdbc1Connection.java:197)
> >       at org.postgresql.Driver.connect(Driver.java:139)
> >       at java.sql.DriverManager.getConnection(DriverManager.java:512)
> >       at java.sql.DriverManager.getConnection(DriverManager.java:171)
> >
> > Please help me with this.
> >
> > Thanks,
> > Vj
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 9: In versions below 8.0, the planner will ignore your desire to
> >       choose an index scan if your joining column's datatypes do not
> >       match
> >
>
>

In response to

pgsql-jdbc by date

Next:From: j.random.programmerDate: 2006-06-28 22:46:05
Subject: Possible to say: [setObject("123")] to insert into int column type ?
Previous:From: Luis Vilar FloresDate: 2006-06-28 22:10:16
Subject: Re: bytea memory improvement

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