Facing an issue for querying and error as “HSQL Database : ..java.sql.SQLException: Column not found: .. in statement

[dhaval soni]

I have created an activeobject query as below:

ao.find(IP.class, Query.select().where("user=? AND planStartTime >=? AND planEndTime<=?",u,datefieldl,datefieldl))

It gives me below error:

" Column not found: PLANSTARTTIME in statement [SELECT * FROM PUBLIC.AO_0371A8_IP WHERE user=? AND planStartTime>=? AND planEndTime<=?]"

My entity is look as below:

My entity is looks as below:

@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);
}

I able to create entity and retrieve all entity (ao.find(..) without any 'where' condition) But it did not work when i give 'where' condition as shown in above stuff.. and gives me column not found error.

[Timothy · Accepted solution]

The best way to check this is to open up the DB itself and check what is the column name (https://confluence.atlassian.com/display/JIRA/Running+SQL+commands+in+a+HSQL+database).