ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alex Boisvert" <boisv...@intalio.com>
Subject Re: Changing the mysql db schema
Date Thu, 29 May 2008 15:40:05 GMT
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)
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message