ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Cherkasov <michael.cherka...@gmail.com>
Subject Re: Ignite .NET - Delete statement
Date Mon, 04 Dec 2017 16:07:43 GMT
Hi Jérôme,

Could you please send me a full reproducer? And could you please clarify
which version of Ignite is used?

Thanks,
Mike.

2017-12-04 12:38 GMT+03:00 jerpic <jerome.picard@misterfly.com>:

> Hello, I try to delete some records according to the DELETE statement (see
> below). Unfortunately, I got every time an exception (see the attached
> file). Exception.txt
> <http://apache-ignite-users.70518.x6.nabble.com/file/t1460/Exception.txt>
> Do you have an idea about the origin of this issue ? Here is the code :
>
>  public void deleteOneWayProposals(string _route, DateTime _searchDate, string _provider)
>         {
>             try
>             {
>                 var query = buildSqlDeleteOneWayProposals(_route, _searchDate, _provider);
>
>                 Console.WriteLine("QUERY : " + query);
>
>                 var res = cacheOneWayProposals.QueryFields(query);
>
>
>             } catch (Exception exp)
>             {
>                 Console.WriteLine(exp.Message);
>             }
>         }
>
>  private SqlFieldsQuery buildSqlDeleteOneWayProposals(string _route, DateTime _searchDate,
string _provider)
>         {
>
>             string delete = "DELETE " +
>                 "FROM \"" + ONEWAY_PROPOSALS_CACHE + "\".ONEWAYPROPOSAL as ONEWAY " +
>                 "WHERE " +
>                     "ONEWAY.ROUTE = ? " +
>                 "AND " +
>                     "ONEWAY.SEARCHDEPARTUREDATE = PARSEDATETIME (?,'yyyy-MM-dd') " +
>                 "AND " +
>                     "ONEWAY.PROVIDER = ? ";
>
>
>             var fieldsQuery = new SqlFieldsQuery(delete);
>             fieldsQuery.EnableDistributedJoins = true;
>
>             fieldsQuery.Arguments = new Object[] { _route, _searchDate.ToString("yyyy-MM-dd"),
_provider};
>
>             if (log.IsDebugEnabled)
>             {
>                 log.Debug("QUERY = " + fieldsQuery.ToString());
>             }
>
>             return fieldsQuery;
>         }
>
> Regards, Jérôme.
> ------------------------------
> Sent from the Apache Ignite Users mailing list archive
> <http://apache-ignite-users.70518.x6.nabble.com/> at Nabble.com.
>

Mime
View raw message