title: Facing an issue for querying error as "HSQL Database : Unexpected token: END in statement"
body: <p>I have created an activeobject query as below:</p>
  
  <pre><code>ao.find(IP.class, Query.select().where("user=? AND start&gt;=? AND end&lt;=?",u,datefieldl,datefieldl))
  </code></pre>
  
  <p>but it gives me below error:</p>
  
  <blockquote>
    <p>There was a SQL exception thrown by the Active Objects library:
    Database: - name:HSQL Database Engine - version:1.8.0 - minor
    version:8 - major version:1 Driver: - name:HSQL Database Engine Driver
    - version:1.8.0 java.sql.SQLException: Unexpected token: END in statement [SELECT * FROM PUBLIC.AO_0371A8_IP WHERE user=? AND start>=?
    AND end&lt;=?]</p>
  </blockquote>
  
  <p>create entity stuff is as below:</p>
  
  <pre><code> IP pi = ao.executeInTransaction(new TransactionCallback() // (1)            
      {   
           @Override
           public IP doInTransaction()
           {
              logger.info("before ao.create");
              IP pi = ao.create(enclass);
                                  ....
  
              pi.save();                              
              return pi;          
           }
      });
  </code></pre>
  
  <p>My entity is looks as below:</p>
  
  <pre><code>@Table("IP")
  @Preload
      public interface IP extends Entity {
  
      @Accessor("issues")
      String getIssues();
  
  @Mutator("issues")
  void setIssues(String issues);
  
  @Accessor("planStartTime")
  Date getPlanStartTime();
  
  @Mutator("planStartTime")
  void setPlanStartTime(Date planStartTime);
  
  @Accessor("planEndTime")
  Date getPlanEndTime();
  
  @Mutator("planEndTime")
  void setPlanEndTime(Date planEndTime);
  
  @Accessor("user")
  String getUser();
  
  @Mutator("user")
  void setUser(String user);
  }
  </code></pre>
  
  <p>any idea?</p>