Denis Magda created IGNITE-5620: ----------------------------------- Summary: Meaningful error codes and types of exceptions for SQL operations Key: IGNITE-5620 URL: https://issues.apache.org/jira/browse/IGNITE-5620 Project: Ignite Issue Type: Task Reporter: Denis Magda Assignee: Alexander Paschenko
Presently, SQL engine throws a generic type of exception with custom text in case of an operation failure. In result, Ignite ODBC driver returns a similar error code (2000) for different kind of failures. For example, error code 2000 is returned for the following {code} Duplicate key during INSERT [key=CorpcontactcountKey [idHash=1412656257, hash=2004096461, mdn=919200000000]] {code} {code} Failed to parse query: INSERT INTO "DG".Corpcontactcount (mdn,contactcount,lastupdatetime) values(?,?,?,?) {code} {code} Wrong value has been set [typeName=Pocsubscrinfo, fieldName=vocoderid, fieldType=short, assignedValueType=byte] Error Code: 2000 {code} The following has to be done: * Create unique types of exceptions for Java whenever applicable. * Add {{errorCode}} parameter and method to a generic SQL exception. * ODBC and JDBC drivers have to return unique codes based on the exception code or type. * All the codes have to be documented on readme.io. -- This message was sent by Atlassian JIRA (v6.4.14#64029)