You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tephra.apache.org by "vishal (JIRA)" <ji...@apache.org> on 2017/07/07 04:44:02 UTC
[jira] [Updated] (TEPHRA-237) How to use Auto-Commit and
transactions in Phoenix ??
[ 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)