Phoenix - JDBCTemplate update

Question

I have problem with upserting values in apache phoenix via Spring JdbcTemplate. Query works fine, so i connect correctly with Phoenix. Also when i make update via straight JDBC it works.

Only when i use update method it does not produce any effect in database. There is no errors or warns. My code:

String sql = "upsert into fanpages(ID,NAME,CATEGORY) VALUES (7, 'new', 'new')";
jdbcTemplateObject.update(sql);

Console:

DEBUG: org.springframework.jdbc.core.JdbcTemplate - Executing SQL update [upsert into fanpages(ID,NAME,CATEGORY) VALUES (7, 'new', 'new')]
DEBUG: org.springframework.jdbc.core.JdbcTemplate - SQL update affected 1 rows

Did i miss something? Why it does not work?

make sure there is primary key in your query. Is ID your primary key? — Kishore, Mar 04 '15 at 14:50

score 1 · Answer 1 · answered Sep 15 '15 at 00:22

1

Have you tried invoking commit? I used jaydebeapi, which is a python module, to upsert into a phoenix table. Only when I called commit can the value be truly be upserted into the table.

answered Sep 15 '15 at 00:22

Tao Xiao

31
1
6

Phoenix - JDBCTemplate update

1 Answers1