java - MySQLSyntaxErrorException: Error in SQL Syntax -

-

please have @ following code

 public int insert(int index, string hashword)     {         string str="";         int result=0;         int returnresult=0;          try         {             con.setautocommit(false);             preparedstatement ps = con.preparestatement("insert key_word (key,hashed_word) values(?,?)");             ps.setint(1, index);             ps.setstring(2, hashword);              result = ps.executeupdate();             con.commit();              if(result>0)             {                 returnresult = 1;             }             else             {                 returnresult = -1;                 system.out.println( index+" failed update");             }           }         catch(sqlexception s)         {             returnresult = -1;             s.printstacktrace();             try {                 con.rollback();                 system.out.println(index+" exception occured. update failed");              } catch (sqlexception ex) {                 ex.printstacktrace();                 str = index+" exception occured. update failed. rollback failed";             }         }          return returnresult;     }

when run code, gives below error.

com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerrorexception: have error in sql syntax; check manual corresponds mysql server version right syntax use near 'key,hashed_word) values(0,'001')' @ line 1 0 exception occured. update failed     @ sun.reflect.nativeconstructoraccessorimpl.newinstance0(native method) operation broke completed     @ sun.reflect.nativeconstructoraccessorimpl.newinstance(nativeconstructoraccessorimpl.java:57)     @ sun.reflect.delegatingconstructoraccessorimpl.newinstance(delegatingconstructoraccessorimpl.java:45)     @ java.lang.reflect.constructor.newinstance(constructor.java:525)     @ com.mysql.jdbc.util.handlenewinstance(util.java:411)     @ com.mysql.jdbc.util.getinstance(util.java:386)     @ com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:1054)     @ com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:4237)     @ com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:4169)     @ com.mysql.jdbc.mysqlio.sendcommand(mysqlio.java:2617)     @ com.mysql.jdbc.mysqlio.sqlquerydirect(mysqlio.java:2778)     @ com.mysql.jdbc.connectionimpl.execsql(connectionimpl.java:2834)     @ com.mysql.jdbc.preparedstatement.executeinternal(preparedstatement.java:2156)     @ com.mysql.jdbc.preparedstatement.executeupdate(preparedstatement.java:2441)     @ com.mysql.jdbc.preparedstatement.executeupdate(preparedstatement.java:2366)     @ com.mysql.jdbc.preparedstatement.executeupdate(preparedstatement.java:2350)     @ inglesrapido.databasehandler.insert(databasehandler.java:64)     @ inglesrapido.keywordtablecreator.readandupdate(keywordtablecreator.java:53)     @ inglesrapido.keywordtablecreator.<init>(keywordtablecreator.java:25)     @ inglesrapido.main.main(main.java:26)

below mysql table

enter image description here

what wrong here?

key reserved word, needs escape used in queries, in:

insert key_word (`key`,hashed_word) values(?,?)

it better choose column name, doesn't clash sql keyword.


Comments

Post a Comment

Popular posts from this blog

git - Initial Commit: "fatal: could not create leading directories of ..." -

-
i trying make initial commit git repository on github unity project. followed along this guide am. note: reason or another, couldn't set unity's asset serialization mode force text, settled on mixed (which believe should work). when call git clone --bare . , error. note not creator of repository , contributor (though making initial commit). here's in terminal (i'm using git bash): welcome git (version 1.8.4-preview20130916) run 'git git' display index. run 'git <command>' display specific commands. cheddar@cheddar-pc ~ $ cd documents/ics168swarch/ cheddar@cheddar-pc ~/documents/ics168swarch $ git init initialized empty git repository in c:/users/cheddar/documents/ics168swarch/.git / cheddar@cheddar-pc ~/documents/ics168swarch (master) $ git add . warning: lf replaced crlf in assets/prefabs.meta. file have original line endings in working directory. warning: lf replaced crlf in assets/prefabs/pellet.prefab.meta. file have original ...
Read more

multithreading - OPAL (Open Phone Abstraction Library) Transport not terminated when reattaching thread? -

-
i in process of writing application using opal makes h323 calls. have looked online number of working examples , have managed put resembles should like, @ present able call external ip via application when accept call craps out , dies. leaving me with: 0:12.949 setupcall:8752 sert.cxx(259) assertion fail: transport not terminated when reattaching thread , file d:\voip\software\opal\src\opal\transports.cxx, line 1021 passertfunc(0xde3f88, 0xffffffffd228226f, 0, 0) + 0x82 passertfunc(0x10d6e5f8, 0x3fd, 0, 0x10d6eb98) + 0x15b opaltransport::attachthread(0xde5870, 0xffffffffd22fc76b, 0, 0) + 0x96 h323connection::setupconnection(0xffffffffd22fc713, 0, 0, 0xde6ea8) + 0x196 asynchcallsetup(0x10d3572c, 0, 0, 0xdd0108) + 0x7c pthread1arg<psafeptr<opalconnection,psafeptrbase> >::main(0xffffffffd2282faf from have deduced, perhaps incorrectly if there thread lock issue caused (possibly arising fact application sending expected h323 call, throwing in c...
Read more