title: Passing POJO values to database in Mule ESB
body: <p>I'm trying to pass a List to Postgresql using Mule ESB.</p>
  
  <p>A simplfied version of my pojo looks like:</p>
  
  <pre><code>    public class NewEntry {
      private String positionReference;
      private String productID;
  
  @XmlElement(required=true, name="PositionReference")
  public String getPositionReference() {
      return positionReference;
  }
  public void setPositionReference(String positionReference) {
      this.positionReference = positionReference;
  }
  @XmlElement(required=true, name="ProductID")
  public String getProductID() {
      return productID;
  }
  public void setProductID(String productID) {
      this.productID = productID;
      }
  
      }
  </code></pre>
  
  <p>This is passed in via a soap webservice as 
  List</p>
  
  <p>until now i've had it simply being transformed into JSON and pumped it out to a file now I would like to insert it into a database, so in my database step I've put a in insert query in along the lines of:</p>
  
  <pre><code>&lt;jdbc:query key="insertrecord" value="INSERT INTO f_intraday_rt(version) VALUES (#[message:productDescription]);"/&gt;
  </code></pre>
  
  <p>Anyway no matter what message evaluation I use in the VALUES section, I can't get it to insert a value, just errors or blank rows.</p>
  
  <p>How do I unbundle the loop and insert a row per list item?</p>
  
  <p>Thanks</p>
  
  <p>Tom</p>