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)
>
