title: How to set query parameters with single quotes
body: <p>I'm using a oracle database.I need to run a update query through jpa repository.This is the query I have tried to execute.</p>
  
  <pre><code>            @Transactional(propagation = Propagation.REQUIRES_NEW)
              @Modifying
              @Query(
                  value = "UPDATE transactionlog SET transactionstatus= :ps,startedat = CURRENT_TIMESTAMP, readytoprocessat= (CURRENT_TIMESTAMP+ interval ':to' second)  WHERE logid IN (:li) ",
                  nativeQuery = true)
              public Integer reserve(@Param("ps") short processingStatus, @Param("li") List&lt;Integer&gt; logIdList, @Param("to") int timeOut);
  </code></pre>
  
  <p>But this exception</p>
  
  <pre><code>org.springframework.dao.InvalidDataAccessApiUsageException: Parameter with that name [to] did not exist; nested exception is java.lang.IllegalArgumentException: Parameter with that name [to] did not exist
  </code></pre>
  
  <p>But if i change this method as follows, it works fine.</p>
  
  <pre><code>@Transactional(propagation = Propagation.REQUIRES_NEW)
              @Modifying
              @Query(
                  value = "UPDATE transactionlog SET transactionstatus= :ps,startedat = CURRENT_TIMESTAMP, readytoprocessat= (CURRENT_TIMESTAMP+ interval '5' second)  WHERE logid IN (:li) ",
                  nativeQuery = true)
              public Integer reserve(@Param("ps") short processingStatus, @Param("li") List&lt;Integer&gt; logIdList);
  </code></pre>
  
  <p>Any idea?</p>