Mailing-List: contact dev-help@tephra.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@tephra.incubator.apache.org
Date: Thu, 6 Jul 2017 20:17:00 +0000 (UTC)
From: "James Taylor (JIRA)" <jira@apache.org>
To: dev@tephra.incubator.apache.org
Message-ID: <JIRA.13084797.1499253778000.188245.1499372220356@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] [Commented] (TEPHRA-237) Unable to discover tx service
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Thu, 06 Jul 2017 20:17:05 -0000


    [ https://issues.apache.org/jira/browse/TEPHRA-237?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16077150#comment-16077150 ] 

James Taylor commented on TEPHRA-237:
-------------------------------------

FYI, DDL statements are not transactional. I'd recommend using a different connection for those rather than mix those with your DML as DDL statements do an implicit rollback before they operate.

> Unable to discover tx service
> -----------------------------
>
>                 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)