Re: Postgresql 7.4.1 and jdbc errors

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
>