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 <[email protected]>: > 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. >
