Subject: Re: Incorrect integer value: 'null' for column 'idt_diagnostico' at row 1
- Next message: Carlos Buil Aranda: "problem when creating my own OGSA_DAI resource"
- Previous message: Mario Antonioletti: "OGSA-DQP 3.2.1"
- In reply to: Mike Jackson: "Re: Incorrect integer value: 'null' for column 'idt_diagnostico' at row 1"
From: Ally Hume (a.hume@epcc.ed.ac.uk)
Date: Aug 08, 2008 17:32
Hi Mathias,
You are right it that the string needs to be NULL in capitals. If you
look at the documentation of the CSVToTuples activitivity [1] it has
an optional input called nullDataString that can be used to specify
what string is used to represent null values. The default is "NULL",
if you wish to use "null" you could this optional input to specify
"null".
[1] CSVToTuple activity documentation,
http://www.ogsadai.org.uk/documentation/ogsadai3.0/ogsadai3.0-axis/ActivitiesAppendix.html#CSVToTupleRef)
Regards,
Ally Hume
OGSA-DAI development team
2008/8/8 Mike Jackson <michaelj@epcc.ed.ac.uk>:
>
> 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.
>
-- ---------------------------------------------------------- Ally Hume Software Architect EPCC, The University of Edinburgh Tel: +44 131 651 3397 The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336.