Thank you Paul, the error message disappeared, but SQL does not update the
linkset (very curiously because it does from console), will dig further.
Anyway, thank you very much indeed for your help.
Regards,
Sergei
On Friday, May 1, 2015 at 6:34:40 PM UTC+3, Paul Scott wrote:
>
> Sorry, on mobile and typing is hard (I'm a big dude with big thumbs)
>
> graph.command(
> new OCommandSQL("UPDATE...."));
>
> If you follow the source to OCommandSQL() you will see that there are 2
> query types, one for idempotent and another for non idempotent queries.
>
> -- Paul
>
> On Fri, 01 May 2015, 17:20 <[email protected] <javascript:>> wrote:
>
>> Sorry, what do you mean? Could you provide an example, please? Thank you.
>>
>>
>>
>> On Friday, May 1, 2015 at 4:48:30 PM UTC+3, Paul Scott wrote:
>>
>>> Use the Raw sql query. Update is idempotent.
>>>
>>> -- Paul
>>>
>>> On Fri, 01 May 2015, 15:45 <[email protected]> wrote:
>>>
>> Hi,
>>>>
>>>> I am just starting to explore the usage of orient database.
>>>>
>>>> In the query
>>>>
>>>> db.command(new OSQLSynchQuery[ODocument]("update (select
>>>> expand(milli[2]) from Second)" +
>>>> " add request = ?")).execute(reqdoc3)
>>>>
>>>> I got - Cannot execute non idempotent command, while running the same
>>>> query from console -
>>>>
>>>> update (select expand(milli[2]) from Second) add request = #13:2
>>>>
>>>> everything is ok. Where is my mistake? Thank you.
>>>>
>>>>
>>>> --
>>>>
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "OrientDB" group.
>>>>
>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to [email protected].
>>>
>>>
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>> --
>>
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "OrientDB" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected] <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
