Обсуждение: Postgresql 7.4.1 and jdbc errors
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
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 >
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 > > > >