From: marc+pljava at milestonerdl.com (marc+pljava at milestonerdl.com)
Date: Wed, 20 Aug 2008 13:38:48 GMT
Subject: [Pljava-dev] java.net.SocketException: Invalid argument
Message-ID: <200808201338.m7KDcmQI023875@tandem.milestonerdl.com>


Trying to get PL/Java running on 64 bit Postgresql 8.3.

Ran into this:

java org.postgresql.pljava.deploy.Deployer -install
org.postgresql.util.PSQLException: The connection attempt failed.
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(Conne
ctionFactoryImpl.java:137)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactor
y.java:66)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Conn
ection.java:124)
        at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Conn
ection.java:30)
        at org.postgresql.jdbc3g.Jdbc3gConnection.<init>(Jdbc3gConnection.java:2
4)
        at org.postgresql.Driver.makeConnection(Driver.java:386)
        at org.postgresql.Driver.connect(Driver.java:260)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:252)
Caused by: java.net.SocketException: Invalid argument
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
        at java.net.Socket.connect(Socket.java:520)
        at java.net.Socket.connect(Socket.java:470)
        at java.net.Socket.<init>(Socket.java:367)
        at java.net.Socket.<init>(Socket.java:180)
        at org.postgresql.core.PGStream.<init>(PGStream.java:62)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(Conne
ctionFactoryImpl.java:77)
        ... 9 more

And some other bits of data:
 
 
$ env
USER=pgsql
MAIL=/var/mail/pgsql
LD_LIBRARY_PATH=/usr/local/jdk1.5.0/jre/lib/amd64:/usr/local/jdk1.5.0/jre/lib/am
d64/server
HOME=/usr/local/pgsql
PGLIB=/usr/local/lib:/usr/local/lib/postgresql
BLOCKSIZE=K
TERM=xterm
PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/games:/usr/local/sbin:/usr/local/bin:/us
r/local/pgsql/bin
SHELL=/bin/sh
CLASSPATH=/usr/local/share/java/classes/postgresql.jar:/usr/local/lib/postgresql
/pljava.jar:/usr/local/pljava/deploy.jar
JAVA_HOME=/usr/local/jdk1.5.0
PWD=/usr/local/pgsql
PGDATA=/usr/local/pgsql/data
FTP_PASSIVE_MODE=YES
$ psql template1
Welcome to psql 8.3.3, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

template1=# \l
      List of databases
   Name    | Owner | Encoding
-----------+-------+----------
 postgres  | pgsql | UTF8
 template0 | pgsql | UTF8
 template1 | pgsql | UTF8
(3 rows)

template1=# \q