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

[ https://issues.jboss.org/browse/TEIID-3619?page=com.atlassian.jira.plugin... ] Juraj Duráni commented on TEIID-3619: ------------------------------------- Yes, the HBase has autoCommit to false by default. As I wrote in my first comment, the simplest and probably the best solution is to set "phoenix.connection.autoCommit" to true. Autocommit is set to false from some reason and we should not change this behavior in the Teiid. Autocommit can be set to true very easily [1]. Please, find other details below [2]. I am running the HBase in standalone mode on localhost (see version in the "Environment"). You can use some SQL client, e.g. squirrel, to connect to the VDB. [1] {code:xml} <datasource jndi-name="java:/localHBase" pool-name="localHBase" enabled="true"> <connection-url>jdbc:phoenix:localhost</connection-url> <connection-property name="phoenix.connection.autoCommit"> true </connection-property> <driver>phoenix</driver> </datasource> {code} [2] *VDB:* {code:xml} <vdb name="hbase" version="1"> <model name="hbase"> <source name="local" translator-name="hbase" connection-jndi-name="java:/localHBase" /> <metadata type="DDL"><![CDATA[ CREATE FOREIGN TABLE SmallA (IntKey integer PRIMARY KEY OPTIONS (nameinsource 'intkey'), StringKey string OPTIONS (nameinsource 'stringkey')) OPTIONS (CARDINALITY 50, UPDATABLE 'TRUE', nameinsource 'smalla'); ]]> </metadata> </model> </vdb> {code} *Phoenix table:* the table was created via Phoenix driver. The table previously did not exist in the HBase. {code:sql} CREATE TABLE smalla(intkey integer primary key,stringkey varchar(10)); UPSERT INTO smalla VALUES(1, '1'); UPSERT INTO smalla VALUES(3, '3'); UPSERT INTO smalla VALUES(5, '5'); UPSERT INTO smalla VALUES(7, '7'); {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)