Re: Postgresql 7.4.1 and jdbc errors

[Dave Cramer <pg(at)fastcrypt(dot)com>]

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