org.postgresql.util.PSQLException: An I/O error occured while sending to the backend

Поиск
Список
Период
Сортировка
От Albretch Mueller
Тема org.postgresql.util.PSQLException: An I/O error occured while sending to the backend
Дата
Msg-id 9ef66fac0805061916y5cf117a1m561235b0e5c1dcbe@mail.gmail.com
обсуждение исходный текст
Ответы Re: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend  ("Albretch Mueller" <lbrtchx@gmail.com>)
Re: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend  ("Albe Laurenz *EXTERN*" <laurenz.albe@wien.gv.at>)
Список pgsql-jdbc
 Hi,
~
 I am having a problem with PG I don't quite understand. I know the
server is running but I am getting exceptions as it is not. The
exception is thrown exactly after setting the parameters of a
preparedStatement, when I try to execute the query
~
    ResultSet RS = PSt.executeQuery();
~
org.postgresql.util.PSQLException: An I/O error occured while sending
to the backend.
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:218)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
        at JDBCPrepStSelWhr06.getRx(JDBCPrepStSelWhr06.java:223)
        at JDBCPrepStSelWhr06Test.main(JDBCPrepStSelWhr06Test.java:72)
Caused by: java.io.IOException: Stream closed
        at sun.nio.cs.StreamEncoder.ensureOpen(StreamEncoder.java:26)
        at sun.nio.cs.StreamEncoder.flush(StreamEncoder.java:121)
        at java.io.OutputStreamWriter.flush(OutputStreamWriter.java:212)
        at org.postgresql.core.PGStream.flush(PGStream.java:507)
        at org.postgresql.core.v3.QueryExecutorImpl.sendSync(QueryExecutorImpl.java:676)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
        ... 5 more
~
 I do know PG is running in my box:
~
sh-3.1# telnet localhost 5432
Trying 127.0.0.1...
Connected to Knoppix.
Escape character is '^]'.
~
pgtest@Knoppix:~/bin$ ./pgpostmaster.sh
pgtest@Knoppix:~/bin$ psql -l
       List of databases
   Name    | Owner  | Encoding
-----------+--------+-----------
 postgres  | pgtest | SQL_ASCII
 template0 | pgtest | SQL_ASCII
 template1 | pgtest | SQL_ASCII
 testdb    | pgtest | SQL_ASCII
(4 rows)

pgtest@Knoppix:~/bin$ select current_timestamp;
> ;
bash: syntax error near unexpected token `;'
pgtest@Knoppix:~/bin$ psql testdb;
Welcome to psql 8.3.1, 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

testdb=# select current_timestamp;
              now
-------------------------------
 2008-05-06 21:50:52.618359-04
(1 row)

testdb=# select * from testtbl;
 testid |  usr  |  pw  |  usrid  |      ctm      |     laxtm
--------+-------+------+---------+---------------+---------------
      1 | usr00 | pw00 | usrpw00 | 1068457566818 | 1068457579818
      2 | usr02 | pw02 | usrpw02 | 1068455566818 | 1068455566999
      3 | usr04 | pw04 | usrpw04 | 1068447566818 | 1068447566865
(3 rows)

testdb=#
~

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: JDBC and GSSAPI/Krb5 with uDig
Следующее
От: "Albretch Mueller"
Дата:
Сообщение: Re: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend