title: Java JOOQ parse query to ArrayList with object
body: <p>I have a problem. I am using JOOQ, with that I created the following query:</p>
  <pre><code>create.select(
          DSL.field(&quot;Mainkey&quot;),
          DSL.field(&quot;Market&quot;),
          DSL.field(&quot;Coin&quot;),
          DSL.field(&quot;Period&quot;),
          DSL.field(&quot;DateTimeGMT0&quot;),
          DSL.field(&quot;DateTimeLocal&quot;),
          DSL.field(&quot;Close&quot;))
          .from(DSL.table(&quot;vwCD_All_Selection_&quot; + market + &quot;_&quot; + coin + &quot;_1m_Order_DateTime_DESC&quot;))
          .where(DSL.field(&quot;DateTimeLocal&quot;).greaterOrEqual(startDateTime.minusMinutes(1))).fetch();
  </code></pre>
  <p>Now I also have the following class:</p>
  <pre><code>public class Candlestick implements Comparable&lt;Candlestick&gt; {
  
      private long MainKey;
      private LocalDateTime DateTimeGMT0;
      private LocalDateTime DateTimeLocal;
      private String Market;
      private String Coin;
      private String Period;
      public Double Close;
  
  }
  </code></pre>
  <p>Now I want the result of the query to be parsed to an <code>ArrayList&lt;Candlestick&gt;</code>. I found this page: <a href="https://www.jooq.org/doc/3.0/manual/sql-execution/fetching/arrays-maps-and-lists/" rel="nofollow noreferrer">https://www.jooq.org/doc/3.0/manual/sql-execution/fetching/arrays-maps-and-lists/</a> that shows how to parse the result to a List, bu that is for a specific column of the select. I want to parse the entire object.</p>
  <p>How can I achieve this?</p>