You should either call "connection.commit()" after executing the statement or set auto commit "ON" on the connection.
Anirudha On Mon, Dec 29, 2014 at 7:48 PM, Kunal Gupta <[email protected]> wrote: > Please see the attached file of code and let me know where can i change so > that it start working > > Thanks , Kunal > > > On Mon, Dec 29, 2014 at 7:47 PM, Kunal Gupta <[email protected]> > wrote: > >> Please see the attached file of code and let me know where can i change >> so that it start working >> >> Thanks , Kunal >> >> >> On Mon, Dec 29, 2014 at 1:14 AM, Ravi Kiran <[email protected]> >> wrote: >> >>> Hi Kunal, >>> Appreciate if you can show the code you have written to help you in >>> the problems you are facing(if any). If you have setup Phoenix and Hadoop >>> and HBase correctly , upserting values into a table is simple using the >>> standard jdbc code. >>> >>> You can have a look at this *toy code* here >>> https://gist.github.com/mravi/501fa00b942764eb0dca#file-stocksampledatagenerator-java. >>> >>> >>> Regards >>> Ravi >>> >>> On Sun, Dec 28, 2014 at 11:31 AM, Kunal Gupta <[email protected]> >>> wrote: >>> >>>> Hello >>>> >>>> I am doing MTech From IIIT-DELHI. Recently i am working on your >>>> project(Apache Phoenix) and successful in Integrating Apache Phoenix on >>>> Apache HBase under Hadoop File system in Pseudo Distributed. >>>> >>>> I want to implemet some algorithm in 2 tier way , where one tier is a >>>> JAVA application and another is your Apache phoenix connected to HBase. By >>>> help of JAVA application i am successful in making connection with phoenix >>>> using JDBC Driver and tried to run all DML and DDL statement after creating >>>> connection but when i ran UPSERT STATEMENT query in executeUpdate() >>>> function of PhoenixStatement class then without giving error it runs but >>>> when i check whether the value is inserted or not then it shows me 0 rows >>>> affected in table and when i ran CREATE TABLE query statement in same >>>> executeUpdate() function of PhoenixStatement class then it created the >>>> table in HBase. >>>> >>>> So please can you help me , how can i UPSERT the values into table by >>>> java application. >>>> >>>> Please help me how can i fix it to insert all values into table through >>>> JAVA APPLICATION. >>>> >>>> Thanks , Kunal >>>> >>>> >>> >> >
