Thanks , it worked for me ..... :) Thanks , Kunal
On Mon, Dec 29, 2014 at 10:03 PM, Anirudha Khanna <[email protected] > wrote: > 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 >>>>> >>>>> >>>> >>> >> >
