Problem in executing query using ormlite in android

Question

I'm using the program found on this programming blog for using pre-populated sqlite table. I am trying to insert any row in the table but it is giving always SQLException:

Problems executing Android query: SELECT * FROM `user` WHERE `username`='Shadow'

This is the method where I'm getting this error:

public User getByUsername(String username) {        
    try {
        QueryBuilder<User, String> qb = userDao.queryBuilder(); 
        qb.where().eq("username", username);    
        PreparedQuery<User> pq = qb.prepare();
        return userDao.queryForFirst(pq);
    } catch (SQLException e) {
        e.printStackTrace();
        return null;
    }
}

Looking for help...

Can you please post the entire exception?

Gray
– Gray

2011-08-19 14:24:50 +00:00
Commented Aug 19, 2011 at 14:24 — Gray
– Gray, Commented Aug 19, 2011 at 14:24

Gray · Accepted Answer · 2011-09-06 12:47:50Z

5

Without more information about the specific error you are getting (please add the full exception to your question), we can't really help you @deepak

I will say that your code looks well formed and appropriate. I like to define the fields that I use in queries like the following:

@DatabaseTable(tableName = "users")
public class User @{
    public static final String USERNAME_FIELD_NAME = "username"; 

    ...
    @DatabaseField(columnName = USERNAME_FIELD_NAME)
    private String userName;
    ...

Then your code can be something like the following. This solves problems with queries and database schemas not matching:

qb.where().eq(User.USERNAME_FIELD_NAME, username);

If you post your exception, I'll edit my answer with more help.

answered Sep 6, 2011 at 12:47

Gray

117k24 gold badges305 silver badges360 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Deepak Goel Over a year ago

Thanks for your response,But this is also occuring when i'm executing the daoObject.queryForAll() method and it is giving the same SQLEXCEPTION Problems executing Android query: SELECT * FROM user .

Gray Over a year ago

Can you please post the entire exception to your question?

Deepak Goel Over a year ago

I debug my source code and i found that query method of StatementExecuter class is throwing SQL Exception but i'm not gettind what is the reason behind it.

Deepak Goel Over a year ago

Thanks dude with your approach i debug again and found that the error was due to wrong column name.Any way your idea for posting entire exception give a clue to me and i attached the source code of the ormlite and found the solution thanks once again

Yousef khan · Accepted Answer · 2014-10-28 06:01:40Z

0

Dont forget to write the default constructor of your Entity Class. In my case i forgot to write the constructor and was getting the same exception.

public User(){

}

answered Oct 28, 2014 at 6:01

Yousef khan

3,2443 gold badges17 silver badges18 bronze badges

Collectives™ on Stack Overflow

Problem in executing query using ormlite in android

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related