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)
