Re:Ignite .NET - Delete statement

[Martin]

I am using java driver, and also i am seeing this problem. if delete statement 
delete only one row data, there is no errors. and if the delete statement 
delete multi-row data, the below exception occurs.
cloud you please take a look at this ASAP?




thanks,
Martin





At 2017-12-04 17:38:00, "jerpic" <jerome.pic...@misterfly.com> wrote:
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 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 at Nabble.com.