[
https://issues.apache.org/jira/browse/IGNITE-5620?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16145534#comment-16145534
]
ASF GitHub Bot commented on IGNITE-5620:
----------------------------------------
GitHub user alexpaschenko opened a pull request:
https://github.com/apache/ignite/pull/2541
IGNITE-5620
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/gridgain/apache-ignite ignite-5620
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/ignite/pull/2541.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #2541
----
commit 5c0874281e1daecf72dbe7f3eb62221515e5d566
Author: Alexander Paschenko <[email protected]>
Date: 2017-08-28T17:18:29Z
IGNITE-5620 Began sorting out errors.
commit 71c3bb261ad9c80948fc797865dfe3583cee372e
Author: Alexander Paschenko <[email protected]>
Date: 2017-08-29T15:57:34Z
IGNITE-5620 contd
----
> 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
> Components: sql
> Affects Versions: 2.0
> Reporter: Denis Magda
> Assignee: Alexander Paschenko
> Fix For: 2.3
>
>
> 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)
