Re: JDBC problem

Hi,

>...I'm getting error like this from the java side and the
>application stops working (and wont come back unless I restart...

How is the "application" invoked? Is it a "service" (servlet instance, RMI
object-mediated, etc.), i.e. does a core-component run forever and spawn
helpers to handle requests?

I'd guess that you are slurping output from an external process'
STDOUT/STDERR and the process-control API noticed that one or both sides of
the conversation broke the underlying conduit (the pipe) between the
processes.

Carl <|};-)>

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Reynir Þór Hübner
Sent: Tuesday, May 11, 2004 3:37 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] JDBC problem

I'm running an engine with 15 databases, with fair amount of load. Every
4-5 days I'm getting error like this from the java side and the
application stops working (and wont come back unless I restart) :

java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:66)
at java.io.BufferedOutputStream.write(BufferedOutputStream.java:110)
at java.io.FilterOutputStream.write(FilterOutputStream.java:80)
at org.postgresql.PG_Stream.Send(PG_Stream.java:87)
at org.postgresql.core.QueryExecutor.sendQuery(QueryExecutor.java:184)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:71)
at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection
.java:505)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.j
ava:360)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava:48)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statem
ent.java:176)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statem
ent.java:163)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement
.java:162)
at
com.eplica.model.persistence.JDBCPersistenceHelper.findByUniqueSql(JDBCPersi
stenceHelper.java:704)

Does anyone know what this is about ?
I'm using Red hat Enterprise, and all the correct JDBC drivers etc.

thanx
-reynir

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster