There's no clear answer to that problem. It might happen in several cases, but all are related to TCP/IP timeouts. You may have to investigate on your own.
One quite common case is that a db connection gets timed out by the DB server, then is reused by jdbc. http://techpitcher.com/blog/?p=14 http://forums.mysql.com/search.php?39,search=Broken+Pipe,author=,page=1,match_type=ALL,match_dates=365,match_forum=ALL,match_threads= On Fri, May 30, 2008 at 12:18 AM, Håkon Sagehaug <[EMAIL PROTECTED]> wrote: > Hi > > I got rid of the exception regarding the datatype, but got another this one > > Caused by: 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 > > org.apache.coyote.http11.InternalOutputBuffer.realWriteBytes(InternalOutputBuffer.java:747) > at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:432) > at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:347) > at > > org.apache.coyote.http11.InternalOutputBuffer$OutputStreamOutputBuffer.doWrite(InternalOutputBuffer.java:770) > at > > org.apache.coyote.http11.filters.ChunkedOutputFilter.doWrite(ChunkedOutputFilter.java:126) > at > > org.apache.coyote.http11.InternalOutputBuffer.doWrite(InternalOutputBuffer.java:580) > at org.apache.coyote.Response.doWrite(Response.java:560) > at > > org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:361) > > What I can see this has something to do with mysql, not sure though. Do you > know how to sove this, is there something to set in the server.xml file or > something to be set on the mysql server? > > cheers, Håkon > > 2008/5/29 Alex Boisvert <[EMAIL PROTECTED]>: > > > Yes, increasing the size of the text datatype should work. The code > makes > > no assumption on the exact size (within reasonable limits, of course) > > > > alex > > > > > > On Thu, May 29, 2008 at 6:58 AM, Håkon Sagehaug <[EMAIL PROTECTED]> > > wrote: > > > > > Hi > > > > > > I'm developing a bpel process to call a bioinformatics web service, > that > > > returns a large message which I get this error when I run the process > in > > > ode > > > > > > org.apache.openjpa.persistence.PersistenceException: Data truncation: > > Data > > > too long for column 'DATA' at row 1 {prepstmnt 19062963 INSERT INTO > > > ODE_MESSAGE (MESSAGE_ID, DATA, TYPE, MESSAGE_EXCHANGE_ID) VALUES (?, ?, > > ?, > > > ?) > > > > > > Can I change the datatype in the schema from text to medium text or > large > > > text without it having any effect on other processes and table? Or is > it > > > some other way of solving this issue. I can call the service fine but > > when > > > the message is inserted into the db the exception is thrown > > > > > > cheers, Håkon > > > > > > -- > > > Håkon Sagehaug, Software Developer > > > Parallab, Bergen Center for Computational Science (BCCS) > > > UNIFOB AS (University of Bergen Research Company) > > > > > > > > > -- > Håkon Sagehaug, Software Developer > Parallab, Bergen Center for Computational Science (BCCS) > UNIFOB AS (University of Bergen Research Company) >
