ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin <ghx02...@126.com>
Subject Re:Ignite .NET - Delete statement
Date Wed, 13 Dec 2017 07:54:20 GMT


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.picard@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.
Mime
View raw message