[teiid-issues] [JBoss JIRA] (TEIID-3619) HBase translator - INSERT and UPDATE statements have no effect

[Juraj Duráni (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3619?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13097249#comment-13097249 ] 

Juraj Duráni edited comment on TEIID-3619 at 8/11/15 9:38 AM:
--------------------------------------------------------------

Probably the simplest workaround is to set 'autocommit' for every new connection (driver's property phoenix.connection.autoCommit).
And probably it is the best solution. So I suggest to add a note to the documentation.


was (Author: jdurani):
Probably the simplest workaround is to set 'autocommit' for every new connection (driver's property phoenix.connection.autoCommit).

> HBase translator - INSERT and UPDATE statements have no effect
> --------------------------------------------------------------
>
>                 Key: TEIID-3619
>                 URL: https://issues.jboss.org/browse/TEIID-3619
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 8.7.1.6_2
>         Environment: Hbase: 1.1.1
> Phoenix: 4.5.0-HBase-1.1
>            Reporter: Juraj Duráni
>            Assignee: Kylin Soong
>
> Teiid's INSERT and UPDATE statement have no effect [1]. Both statements are translated as UPSERT which needs Connection.commit() to take effect [2].
> [1]
> *select intkey, stringkey from hbase.smalla where intkey = 5*
> |intkey|stringkey|
> |5|5|
> *update hbase.smalla set stringkey = '1000' where intkey = 5*
> no exception here
> *select intkey, stringkey from hbase.smalla where intkey = 5*
> |intkey|stringkey|
> |5|5|
> [2]
> http://phoenix.apache.org/faq.html#I_want_to_get_started_Is_there_a_Phoenix_Hello_World section "2. Using java"



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)