title: How to insert on conflict if id is autogenerated in sprinframework jdbc
body: <p>I'm trying to insert or update data into spring jdbc query with on conflict query. id is generated automatically by spring so that id will be null if not exists in database. </p>
  
  <p>How can i solve an insert into on conflict update with autogenerated id?  </p>
  
  <p><code>@Query("INSERT INTO XXX (id, name, year) VALUES(NULL, John, 2019) ON CONFLICT (id) DO UPDATE SET name = :name")</code></p>
  
  <p>I expect the output to insert if there's no id (or id is NULL) and update name if id is in database table</p>