title: Error return object Rest API JSON Springboot with a database Oracle : Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
body: <p>I use springboot to return a json object from a database oracle , whene I call the API <strong>http://localhost:8074/signal/all</strong>  I have the error below</p>
  <blockquote>
  <p>java.lang.IllegalArgumentException: Timestamp format must be
  yyyy-mm-dd hh:mm:ss[.fffffffff]   at java.sql.Timestamp.valueOf(Unknown
  Source) ~[na:1.8.0_261]</p>
  </blockquote>
  <p>Type Date in my database oracle is <strong>Date</strong>  (example : <strong>15/10/2020</strong>)</p>
  <p><strong>- Entity</strong></p>
  <pre><code>@Entity
  @Table(name = &quot;SIGNAL&quot;)
  public class Signal implements Serializable {
  
      private static final long serialVersionUID = 1L;
      
      @Id
      @GeneratedValue(strategy = GenerationType.AUTO)
      @Column(name = &quot;SIG_MATR&quot;)
      private String sigMatr;
      private String sigSitu;
      private String sigSexe;
      @JsonIgnore
      @DateTimeFormat(style = &quot;yyyy-MM-dd hh:mm:ss.SSS&quot;)
      private Date sigDate;
  </code></pre>
  <p>I tested to use annotation <strong>@Temporal(TemporalType.TIMESTAMP)</strong> , and I have use <strong>@JsonIgnore</strong> ti ignore the return of this column , but is not resolve the problem</p>
  <p><strong>- Controller</strong></p>
  <pre><code>@RestController
  @RequestMapping(&quot;/signal&quot;)
  public class SignalController {
      
      @Autowired
      private SignalRepository dao;
  
  
      @GetMapping(&quot;/all&quot;)
      public Iterable&lt;Signal&gt; allCollab() {
          return dao.findAll();
      }
      
  </code></pre>