home list archives users mailing list
 

Subject: Re: Incorrect integer value: 'null' for column 'idt_diagnostico' at row 1

Date view Thread view Subject view Author view Attachment view

From: Mike Jackson (michaelj@epcc.ed.ac.uk)
Date: Aug 08, 2008 15:16

Hi Mathias,

I assume you're submitting the parameters initially from the client?
Please could you send me the client (or the appropriate part of the
client that builds your workflow) so we can try and replicate your problem
and see what's going on.

Thanks,

mike

On Wed, 6 Aug 2008, Mathias Brito wrote:

> Did i found the solution?! i should use NULL insteand of null right? the
> string is case sensitive, and the default value is NULL, all uppercase. Am i
> right?
>
> Cheers,
> Mathias
>
> 2008/8/6 Mathias Brito <mathiasbrito@gmail.com>
>
>> Hi folks, i had a problem when trying to execute an SQLParameterisedQuery,
>> i intercepted the messages an got the information sent, everything looks
>> ok.. but i receive the error
>>
>> Incorrect integer value: 'null' for column 'idt_diagnostico' at row 1
>>
>> So the parameters sent with the parameterised query looks this (it is
>> trucated)...
>>
>> [truncated] <![CDATA[null,443,Mathias,M,... [truncated]
>>
>> The parameters are in CSV format. There is more parameters, and the number
>> of it matches with the number of '?' in the query....
>> the first null you see is the column 'idt_diagnostico'. Looks like ogsa-dai
>> is making null a regular string!
>> So the question is, how do i represent the null value?
>> Or, am i doing something wrong?
>>
>> Thanks,
>> Mathias
>>
>

-------------------------------------------------------------------
Dr. Michael (Mike) Jackson Tel: +(44)-0131-650-5141
E-mail: m.jackson@epcc.ed.ac.uk Fax: +(44)-0131-650-6555
EPCC OGSA-DAI Project
WWW: http://www.epcc.ed.ac.uk WWW: http://www.ogsadai.org.uk

The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.

Date view Thread view Subject view Author view Attachment view