Mailing-List: contact dev-help@tephra.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@tephra.incubator.apache.org
Date: Fri, 7 Jul 2017 04:44:02 +0000 (UTC)
From: "vishal (JIRA)" <jira@apache.org>
To: dev@tephra.incubator.apache.org
Message-ID: <JIRA.13084797.1499253778000.190893.1499402642627@Atlassian.JIRA>
In-Reply-To: <JIRA.13084797.1499253778000@Atlassian.JIRA>
References: <JIRA.13084797.1499253778000@Atlassian.JIRA> <JIRA.13084797.1499253778377@jira-lw-us.apache.org>
Subject: [jira] [Updated] (TEPHRA-237) How to use Auto-Commit and
 transactions in Phoenix ??
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Fri, 07 Jul 2017 04:44:11 -0000


     [ https://issues.apache.org/jira/browse/TEPHRA-237?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

vishal updated TEPHRA-237:
--------------------------
    Summary: How to use Auto-Commit and transactions in Phoenix ??  (was: Unable to discover tx service)

> How to use Auto-Commit and transactions in Phoenix ??
> -----------------------------------------------------
>
>                 Key: TEPHRA-237
>                 URL: https://issues.apache.org/jira/browse/TEPHRA-237
>             Project: Tephra
>          Issue Type: Bug
>         Environment: Hbase Version : 1.2.6
> Phoenix Version : 4.10.0-Hbase-1.2 
>            Reporter: vishal
>            Assignee: Poorna Chandra
>
> My Java prog is:
> {code:java}
> Properties connectionProps = new Properties();
> connectionProps.put("phoenix.schema.isNamespaceMappingEnabled", "true");//client+server
> connectionProps.put("phoenix.schema.mapSystemTablesToNamespace","true");//client+server
> connectionProps.put("phoenix.connection.autoCommit", "true");//client
> connectionProps.put("phoenix.transactions.enabled", "true");//client+server
> Connection connection = DriverManager.getConnection("jdbc:phoenix:localhost:2181",connectionProps);
> Statement st = connection.createStatement();
> st.executeUpdate("CREATE TABLE MYTEST1.MYTAB (employee_id integer not null primary key, name varchar) TRANSACTIONAL=true");
> System.out.println("table is created");
> {code}
> hbase-site.xml file
> ------------
> {code:java}
> <configuration>
> <property>
>     <name>hbase.rootdir</name>
>     <value>file:/Users/sai/projects/vishal/software/hbase-data</value>
> </property>
>  
> <property>
>     <name>hbase.zookeeper.property.dataDir</name>
>     <value>/Users/sai/projects/vishal/software/zookeeper-data</value>
> </property>
> <property>
>     <name>phoenix.schema.isNamespaceMappingEnabled</name>
>     <value>true</value>
> </property>
> <property>
>     <name>phoenix.schema.mapSystemTablesToNamespace</name>
>     <value>true</value>
> </property>
> <property>
>     <name>phoenix.transactions.enabled</name>
>     <value>true</value>
> </property>
> <property>
>     <name>data.tx.snapshot.dir</name>
>     <value>/Users/sai/projects/vishal/software/tephra/snapshots</value>
> </property>
> </configuration>
> {code}
> But I am getting above error??
> What else i need to do ??


--
This message was sent by Atlassian JIRA
(v6.4.14#64029)