Read Timeout

Поиск
Список
Период
Сортировка
Искать
От
Michael Mangeng
Тема
Read Timeout
Дата
Msg-id
0E6282E6-7F84-480A-906D-FE0C56F0DB5F@automationnext.com
Список
Дерево обсуждения
Read Timeout Michael Mangeng <michael.mangeng@automationnext.com>
Re: Read Timeout Sadanori Ito <sadanori.ito@gmail.com>
Hello all!

I've got an issue with the call to preparedStatement.executeBatch. The  
performing thread is locked in a productive system for some hours in  
SocketInputStream.read, as you can see in the stacktrace below. The  
database server is currently reachable but it's possible that it had  
been off for a few seconds (we're logging over the internet connection  
to another building).

My question is weather there is a possibility to define a read timeout  
interval somewhere to avoid this. (e.g. In the JDBC url. Somthing like  
loginTimout?)

Stacktrace is below.

Thanks a lot and greetings,
Michael

  java.net.SocketInputStream.socketRead0(null:-2)
  java.net.SocketInputStream.read(null:-1)
  org.postgresql.core.VisibleBufferedInputStream.readMore 
(VisibleBufferedInputStream.java:135)
  org.postgresql.core.VisibleBufferedInputStream.ensureBytes 
(VisibleBufferedInputStream.java:104)
  org.postgresql.core.VisibleBufferedInputStream.read 
(VisibleBufferedInputStream.java:73)
  org.postgresql.core.PGStream.ReceiveChar(PGStream.java:259)
  org.postgresql.core.v3.QueryExecutorImpl.processResults 
(QueryExecutorImpl.java:1166)
  org.postgresql.core.v3.QueryExecutorImpl.execute 
(QueryExecutorImpl.java:351)
  org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch 
(AbstractJdbc2Statement.java:2674)
  org.apache.commons.dbcp.DelegatingStatement.executeBatch 
(DelegatingStatement.java:297)
   
com.v8tech.pneuma.eventlogger.internal.NodeprocessingDataEntriesoggerImpl.commitBatch 
(NodeEventLoggerImpl.java:462)
   
com.v8tech.pneuma.eventlogger.internal.NodeEventLoggerImpl.processDataEntries 
(NodeEventLoggerImpl.java:378)
  com.v8tech.pneuma.eventlogger.internal.NodeEventLoggerImpl.tick 
(NodeEventLoggerImpl.java:502)
  com.v8tech.components.ticker.Ticker$TickerRunnable$1.run(Ticker.java: 
206)
  java.util.concurrent.ThreadPoolExecutor$Worker.runTask(null:-1)
  java.util.concurrent.ThreadPoolExecutor$Worker.run(null:-1)
  java.lang.Thread.run(null:-1)



В списке pgsql-jdbc по дате отправления
От: cholid
Дата:
От: Sadanori Ito
Дата:
Сообщение: Re: Read Timeout
FAQ