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@fastcrypt.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
> >
>
>
