java - Getting SQLiteException: no such column - 


public class mydbhandler extends sqliteopenhelper {      private static final int database_version = 1;     private static final string database_name = "winkelskortrijk.db";     private static final string table_users = "users";     private static final string table_favourites = "favorieten";      public static final string column_id = "id";     public static final string column_username = "username";     public static final string column_password = "password";      public static final string column_id2 = "id2";     public static final string column_name = "naam";     public static final string column_straat = "straat";     public static final string column_huisnr = "nr";     public static final string column_postcode = "postcode";     public static final string column_deelgemeente = "deelgemeente";     public static final string column_gemeente = "gemeente";     public static final string column_adres = "adres";      public mydbhandler(context context, string name,                        sqlitedatabase.cursorfactory factory, int version) {         super(context, database_name, factory, database_version);     }      @override     public void oncreate(sqlitedatabase db) {          string create_users_table = "create table " +                 table_users + "("                 + column_id + " integer primary key autoincrement,"                 + column_username + " text,"                 + column_password + " text"                 + ")";         db.execsql(create_users_table);          string create_favourites_table = "create table " +                 table_favourites + "("                 + column_id2 + " integer primary key,"                 + column_name + " text,"                 + column_straat + " text,"                 + column_huisnr + " integer,"                 + column_postcode + " integer,"                 + column_deelgemeente + " text,"                 + column_gemeente + " text,"                 + column_adres + " text,"                 + column_id + " int, "                 + "foreign key(" + column_id + ") references "                 + table_users + "(id) " + ")";         db.execsql(create_favourites_table);      }      @override     public void onupgrade(sqlitedatabase db, int oldversion,                           int newversion) {      }       public user finduser(user user) {          string selectquery = "select  * " + table_users + " "                 + column_username + " = " + user.getusername();          sqlitedatabase db = this.getwritabledatabase();          cursor cursor = db.rawquery(selectquery, null);          user finduser = new user();          if (cursor.movetofirst()) {             cursor.movetofirst();             finduser.setusername(cursor.getstring(1));             finduser.setpassword(cursor.getstring(2));             cursor.close();         } else {             finduser = null;         }         db.close();         return finduser;      }  }

when try run finduser(user user) method, sqlexception no such column: gebruikersnaam (note: gebruikersnaam variable in user.getusername(), want function return user if found or null when isn't.

what doing wrong , there better way use queries?

crash log:

07-25 15:22:42.345 32264-32264/com.example.hoofdgebruiker.winkelskortrijk e/androidruntime: fatal exception: main process: com.example.hoofdgebruiker.winkelskortrijk, pid: 32264 android.database.sqlite.sqliteexception: no such column: gebruikersnaam (code 1): , while compiling: select * users username = gebruikersnaam @ android.database.sqlite.sqliteconnection.nativepreparestatement(native method) @ android.database.sqlite.sqliteconnection.acquirepreparedstatement(sqliteconnection.java:887) @ android.database.sqlite.sqliteconnection.prepare(sqliteconnection.java:498) @ android.database.sqlite.sqlitesession.prepare(sqlitesession.java:588) @ android.database.sqlite.sqliteprogram.(sqliteprogram.java:58) @ android.database.sqlite.sqlitequery.(sqlitequery.java:37) @ android.database.sqlite.sqlitedirectcursordriver.query(sqlitedirectcursordriver.java:44) @ android.database.sqlite.sqlitedatabase.rawquerywithfactory(sqlitedatabase.java:1316) @ android.database.sqlite.sqlitedatabase.rawquery(sqlitedatabase.java:1255) @ com.example.hoofdgebruiker.winkelskortrijk.database.mydbhandler.finduser(mydbhandler.java:78) @ com.example.hoofdgebruiker.winkelskortrijk.homepage.mainactivity.register(mainactivity.java:49) @ com.example.hoofdgebruiker.winkelskortrijk.homepage.register$1.onclick(register.java:47) @ android.view.view.performclick(view.java:5198) @ android.view.view$performclick.run(view.java:21147) @ android.os.handler.handlecallback(handler.java:739) @ android.os.handler.dispatchmessage(handler.java:95) @ android.os.looper.loop(looper.java:148) @ android.app.activitythread.main(activitythread.java:5417) @ java.lang.reflect.method.invoke(native method) @ com.android.internal.os.zygoteinit$methodandargscaller.run(zygoteinit.java:726) @ com.android.internal.os.zygoteinit.main(zygoteinit.java:616)

just update query

string selectquery = "select  * " + table_users + " "             + column_username + " = " + user.getusername();

to 

string selectquery = "select  * " + table_users + " "             + column_username + " = '" + user.getusername()+"'";

enclose user.getusername() value single quotes because define column_username text. if string contain quotes not work. before adding user.getusername() query remove quotes username below

user.getusername().replace("\'","''");


Comments

Post a Comment

Popular posts from this blog

jOOQ update returning clause with Oracle -

according http://www.jooq.org/doc/3.8/manual/sql-building/sql-statements/update-statement/ jooq doesn't support returning clause in update statements databases except firebird , postgres. does know, still correct oracle jooq? according oracle's documentation, oracle db supports returning clase delete, insert, or update statements. incorrect manual you're right - manual wrong , should fixed: https://github.com/jooq/jooq/issues/5470 single row update returning jooq 3.8 added support single row update .. returning statements. internally, uses callablestatement , pl/sql block of form: begin update "my_table" set "my_table"."column" = 'xyz' "my_table"."id" = 1 returning "my_table"."id", "my_table"."column" ?, ?; ? := sql%rowcount; end; the relevant issue is: https://github.com/jooq/jooq/issues/5190 multi row update returning a...
Read more

java - Warning equals/hashCode on @Data annotation lombok with inheritance -

i have entity inherits other. on other hand, i'm using lombok project reduce boilerplate code, put @data annotation. annotation @data inheritance produces next warning: generating equals/hashcode implementation without call superclass, though class not extend java.lang.object. if intentional, add '@equalsandhashcode(callsuper=false)' type. is advisable add annotation @equalsandhashcode (callsuper = true) or @equalsandhashcode (callsuper = false) ? if not added, 1 callsuper=false or callsuper=true ? the default value false . 1 if don't specify , ignore warning. yes, recommended add @equalsandhashcode annotation on @data annotated classes extend else object. cannot tell if need true or false , depends on class hierarchy, , need examined on case-by-case basis. however, project or package, can configure in lombok.config call super methods if not direct subclass of object. lombok.equalsandhashcode.callsuper = call for configuration system ...
Read more

java - BasicPathUsageException: Cannot join to attribute of basic type -

i using java 8 jpa (hibernate 5.2.1). have clause works perfectly, until introduce clause make use foreign key table values too. i getting following error: basicpathusageexception: cannot join attribute of basic type i think problem related fact have join table, , not sure how create join using join table. employee - employee_category - category model (employee.java): @manytomany(cascade = cascadetype.all, fetch=fetchtype.eager) @jointable ( name="employee_category", joincolumns={ @joincolumn(name="emp_id", referencedcolumnname="id") }, inversejoincolumns={ @joincolumn(name="cat_id", referencedcolumnname="id") } ) private set<category> categories; model (category.java): @id private string id; jpa when introduce following code, fails error above (i think problem new piece of code): join<t, category> category = from.join("id"); predicates.add(criteriabuilder.like(category....
Read more