ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexis Midon" <mi...@intalio.com>
Subject Re: Changing the mysql db schema
Date Fri, 30 May 2008 15:37:24 GMT
oups, my bad.
I've encountered it only on databases so far.
rule #33: You shall read the full stack trace. :)

On Fri, May 30, 2008 at 7:47 AM, Alex Boisvert <boisvert@intalio.com> wrote:

> Actually, this exception is not related to the database but more on the
> HTTP
> connection side.  Maybe the client timed out already?   This stacktrace
> fragment doesn't tell me when the exception happened (within the
> process/activity)
>
> If you have large messages, the response time is often affected because of
> the additional latency involved in shipping and persisting the data to the
> persistence layer.
>
> alex
>
>
> On Fri, May 30, 2008 at 12:18 AM, Håkon Sagehaug <hsagehaug@gmail.com>
> 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 <boisvert@intalio.com>:
> >
> > > 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 <hsagehaug@gmail.com>
> > > 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)
> >
>
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message