title: Fetch primary key generated by sequence using jdbctemplate / jdbc for Hana db
body: <p>We are trying to insert record in hana db so we are currently using jdbc template and key holder to save data and retrieve newly generated column id.This works fine for postgress but not for hana.</p>
  
  <pre><code>query ="SELECT CURRENT_IDENTITY_VALUE() FROM \"HALOSYS\".\"HaloTestDemo\"";  
  resultSet =  stmt.executeQuery(query);
  </code></pre>
  
  <p>Above statement gives current identity value but this doesn't fit into our context where we want to use jdbc template.
  Please give me idea to fix this.
  if we add preparedstatement generated keys i am getting follwing exception</p>
  
  <pre><code>com.sap.db.jdbc.exceptions.jdbc40.SQLFeatureNotSupportedException: Method prepareStatement( String, int )() of Connection is not supported.
  </code></pre>