java - ERROR SchemaUpdate:237 - near "from": syntax error -

i new spring, , wondering these errors mean?

error schemaupdate:236 - hhh000388: unsuccessful: create table facebookposts (id  integer, created_time timestamp not null, varchar not null, message varchar not null, picture_url varchar not null, post_id varchar not null, varchar not null, updated_time timestamp not null, primary key (id)) error schemaupdate:237 - near "from": syntax error 

i using spring social's facebook library recent posts , store them in sqlite database.

my code follows:

facebookcontrolller

package adam.social.media.controller;  import java.util.hashmap; import java.util.map;  import org.apache.log4j.logger; import org.springframework.beans.factory.annotation.autowired; import org.springframework.social.facebook.api.facebook; import org.springframework.social.facebook.api.post; import org.springframework.social.facebook.api.impl.facebooktemplate; import org.springframework.stereotype.controller; import org.springframework.validation.bindingresult; import org.springframework.web.bind.annotation.requestmapping; import org.springframework.web.bind.annotation.requestmethod; import org.springframework.web.servlet.modelandview;  import adam.social.media.model.facebookmodel; import adam.social.media.repository.facebookrepository;  @controller public class facebookcontroller {         private facebook facebook;      private facebookrepository facebookrepository;      private static logger logger = logger.getlogger(facebookcontroller.class             .getname());      @autowired     public facebookcontroller(facebookrepository facebookrepository) {         logger.debug("entering facebookcontroller");          this.facebookrepository = facebookrepository;                         facebook = new facebooktemplate("caacedeose0cbagjdhb17dtds4vjdhul5ypxqppywdktda963rn4rvzboufatylxcfzkf8aejl0c4cbvtr2og0vjwb7bsbstq71slzhb6d4cvglmzjyi5krayszcflj6tifvhwfmzahzyadnywii3z7p5x8jpovducxsr8pxmeqyeifnh46s5h0p1szuol6usdeqlaf3zap5eswtqs8gqg3loslfksx4zd");                        logger.debug("exiting facebookcontroller");     }      @requestmapping(method = requestmethod.get)     public modelandview getfacebookstatus(facebookmodel facebookmodel) {         logger.debug("entering getfacebookstatus");          modelandview modelandview = new modelandview("index");                post post = facebook.feedoperations().getfeed().get(0);          facebookmodel.setpostid(post.getid());         facebookmodel.setto(post.getto().get(0).getname());         facebookmodel.setfrom(post.getfrom().getname());         facebookmodel.setcreatedtime(post.getcreatedtime());         facebookmodel.setupdatedtime(post.getupdatedtime());         facebookmodel.setmessage(post.getmessage());         facebookmodel.setpictureurl(post.getpicture());          modelandview.addobject("facebookmodel", facebookmodel);          logger.debug("exiting getfacebookstatus");          return modelandview;     }      @requestmapping(method = requestmethod.post)     public modelandview postfacebookstatus(facebookmodel facebookmodel, bindingresult result) {         logger.debug("entering postfacebookstatus");          if (result.haserrors()) {             map<string, object> params = new hashmap<string, object>();              params.put("facebookmodel", facebookmodel);              return new modelandview("index", params);         }          facebookrepository.saveandflush(facebookmodel);          logger.debug("exiting postfacebookstatus");          return new modelandview("redirect:/index.html");     } } 

facebookmodel

package adam.social.media.model;  import java.io.serializable; import java.util.date;  import javax.persistence.column; import javax.persistence.entity; import javax.persistence.generatedvalue; import javax.persistence.generationtype; import javax.persistence.id;  import org.apache.log4j.logger;  @entity(name = "facebookposts") public class facebookmodel implements serializable {      private static final long serialversionuid = -1l;      private static logger logger = logger.getlogger(facebookmodel.class.getname());      @id     @generatedvalue(strategy = generationtype.auto)     private int id;     @column(name = "post_id", nullable = false)     private string postid;     @column(name = "to", nullable = false)     private string to;     @column(name = "from", nullable = false)     private string from;     @column(name = "created_time", nullable = false)     private date createdtime;     @column(name = "updated_time", nullable = false)     private date updatedtime;     @column(name = "message", nullable = false)     private string message;     @column(name = "picture_url", nullable = false)     private string pictureurl;      public int getid() {         return id;     }      public void setid(int id) {         logger.debug("entering setid");          this.id = id;          logger.debug("exiting setid");     }      public string getpostid() {         return postid;     }      public void setpostid(string postid) {         logger.debug("entering setpostid");          this.postid = postid;          logger.debug("exiting setpostid");     }      public string getto() {         return to;     }      public void setto(string to) {         logger.debug("entering setto");          this.to = to;          logger.debug("exiting setto");     }      public string getfrom() {         return from;     }      public void setfrom(string from) {         logger.debug("entering setfrom");          this.from = from;          logger.debug("exiting setfrom");     }      public date getcreatedtime() {         return createdtime;     }      public void setcreatedtime(date createdtime) {         logger.debug("entering setcreatedtime");          this.createdtime = createdtime;          logger.debug("exiting setcreatedtime");     }      public date getupdatedtime() {         return updatedtime;     }      public void setupdatedtime(date updatedtime) {         logger.debug("entering setupdatedtime");          this.updatedtime = updatedtime;          logger.debug("exiting setupdatedtime");     }      public string getmessage() {         return message;     }      public void setmessage(string message) {         logger.debug("entering setmessage");          this.message = message;          logger.debug("exiting setmessage");     }      public string getpictureurl() {         return pictureurl;     }      public void setpictureurl(string pictureurl) {         logger.debug("entering setpictureurl");          this.pictureurl = pictureurl;          logger.debug("exiting setpictureurl");     }      public int hashcode() {         final int prime = 31;         int result = 1;         result = prime * result                 + ((createdtime == null) ? 0 : createdtime.hashcode());         result = prime * result + ((from == null) ? 0 : from.hashcode());         result = prime * result + id;         result = prime * result + ((message == null) ? 0 : message.hashcode());         result = prime * result                 + ((pictureurl == null) ? 0 : pictureurl.hashcode());         result = prime * result + ((postid == null) ? 0 : postid.hashcode());         result = prime * result + ((to == null) ? 0 : to.hashcode());         result = prime * result                 + ((updatedtime == null) ? 0 : updatedtime.hashcode());         return result;     }      public boolean equals(object obj) {         if (this == obj) {             return true;         }         if (obj == null) {             return false;         }         if (getclass() != obj.getclass()) {             return false;         }         facebookmodel other = (facebookmodel) obj;         if (createdtime == null) {             if (other.createdtime != null) {                 return false;             }         } else if (!createdtime.equals(other.createdtime)) {             return false;         }         if (from == null) {             if (other.from != null) {                 return false;             }         } else if (!from.equals(other.from)) {             return false;         }         if (id != other.id) {             return false;         }         if (message == null) {             if (other.message != null) {                 return false;             }         } else if (!message.equals(other.message)) {             return false;         }         if (pictureurl == null) {             if (other.pictureurl != null) {                 return false;             }         } else if (!pictureurl.equals(other.pictureurl)) {             return false;         }         if (postid == null) {             if (other.postid != null) {                 return false;             }         } else if (!postid.equals(other.postid)) {             return false;         }         if (to == null) {             if (other.to != null) {                 return false;             }         } else if (!to.equals(other.to)) {             return false;         }         if (updatedtime == null) {             if (other.updatedtime != null) {                 return false;             }         } else if (!updatedtime.equals(other.updatedtime)) {             return false;         }         return true;     }      public string tostring() {         return "facebookmodel [id=" + id + ", postid=" + postid + ", to=" +                 + ", from=" + + ", createdtime=" + createdtime                 + ", updatedtime=" + updatedtime + ", message=" + message                 + ", pictureurl=" + pictureurl + "]";     }    } 

facebookrepository

package adam.social.media.repository;  import org.springframework.data.jpa.repository.jparepository;  import adam.social.media.model.facebookmodel;  public interface facebookrepository extends jparepository<facebookmodel, integer> {  } 

index.jsp

<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> <%@ taglib prefix="form" uri="http://www.springframework.org/tags/form"%>  <head>     <title>social media</title> </head> <body>     <form:form method="post" commandname="facebookmodel">         <form:hidden path="id" />            <form:hidden path="postid" />            <form:hidden path="to" />            <form:hidden path="from" />          <form:hidden path="createdtime" />           <form:hidden path="updatedtime" />           <form:hidden path="message" />           <form:hidden path="pictureurl" />             <input name="submit" type="submit" value="save" />     </form:form> </body> 

mvc-context.xml

<?xml version="1.0" encoding="utf-8"?>   <beans xmlns="http://www.springframework.org/schema/beans"        xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"        xmlns:p="http://www.springframework.org/schema/p"        xmlns:context="http://www.springframework.org/schema/context"        xmlns:mvc="http://www.springframework.org/schema/mvc"        xsi:schemalocation="http://www.springframework.org/schema/beans                             http://www.springframework.org/schema/beans/spring-beans.xsd                            http://www.springframework.org/schema/context                             http://www.springframework.org/schema/context/spring-context.xsd                            http://www.springframework.org/schema/mvc                            http://www.springframework.org/schema/mvc/spring-mvc.xsd">      <context:property-placeholder location="classpath:application.properties" />         <context:component-scan base-package="adam.social.media" />      <mvc:annotation-driven />     <mvc:view-controller path="/index.html" />      <bean id="messagesource" class="org.springframework.context.support.resourcebundlemessagesource"         p:basename="messages"/>      <bean id="connectionfactorylocator" class="org.springframework.social.connect.support.connectionfactoryregistry">         <property name="connectionfactories">             <list>                 <bean class="org.springframework.social.facebook.connect.facebookconnectionfactory">                     <constructor-arg value="1054655621213643" />                     <constructor-arg value="45c95ab39369187fa11b4272632ea4c7" />                                 </bean>             </list>         </property>     </bean>      <mvc:interceptors>             <bean class="org.springframework.web.servlet.i18n.localechangeinterceptor"             p:paramname="locale" />     </mvc:interceptors>      <bean id="localeresolver" class="org.springframework.web.servlet.i18n.sessionlocaleresolver" />      <bean class="org.springframework.web.servlet.view.internalresourceviewresolver">         <property name="prefix"><value>/web-inf/jsp/</value></property>         <property name="suffix"><value>.jsp</value></property>     </bean>  </beans> 

pom.xml

<project xmlns="http://maven.apache.org/pom/4.0.0" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"   xsi:schemalocation="http://maven.apache.org/pom/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">     <modelversion>4.0.0</modelversion>     <groupid>adam.social.media</groupid>     <artifactid>socialmedia</artifactid>     <packaging>war</packaging>     <version>0.0.1-snapshot</version>     <name>social media</name>      <dependencies>         <dependency>             <groupid>org.springframework</groupid>             <artifactid>spring-webmvc</artifactid>             <version>4.0.4.release</version>         </dependency>         <dependency>             <groupid>org.springframework</groupid>             <artifactid>spring-orm</artifactid>             <version>4.0.4.release</version>         </dependency>         <dependency>             <groupid>org.springframework</groupid>             <artifactid>spring-core</artifactid>             <version>4.1.7.release</version>         </dependency>         <dependency>             <groupid>org.springframework</groupid>             <artifactid>spring-web</artifactid>             <version>4.1.6.release</version>         </dependency>         <dependency>             <groupid>org.springframework.social</groupid>             <artifactid>spring-social-core</artifactid>             <version>1.1.2.release</version>         </dependency>         <dependency>             <groupid>org.springframework.social</groupid>             <artifactid>spring-social-facebook</artifactid>             <version>2.0.1.release</version>         </dependency>         <dependency>             <groupid>org.springframework.social</groupid>             <artifactid>spring-social-web</artifactid>             <version>1.1.2.release</version>         </dependency>         <dependency>             <groupid>org.springframework.data</groupid>             <artifactid>spring-data-jpa</artifactid>             <version>1.6.0.release</version>         </dependency>         <dependency>             <groupid>org.hibernate</groupid>             <artifactid>hibernate-entitymanager</artifactid>             <version>4.3.5.final</version>         </dependency>         <dependency>             <groupid>org.hibernate</groupid>             <artifactid>hibernate-validator</artifactid>             <version>5.0.1.final</version>         </dependency>         <dependency>             <groupid>org.hibernate.javax.persistence</groupid>             <artifactid>hibernate-jpa-2.0-api</artifactid>             <version>1.0.1.final</version>         </dependency>         <dependency>             <groupid>javax.servlet</groupid>             <artifactid>javax.servlet-api</artifactid>             <version>3.1.0</version>         </dependency>         <dependency>             <groupid>javax.servlet</groupid>             <artifactid>jstl</artifactid>             <version>1.2</version>         </dependency>         <dependency>             <groupid>javax.validation</groupid>             <artifactid>validation-api</artifactid>             <version>1.1.0.final</version>         </dependency>         <dependency>             <groupid>junit</groupid>             <artifactid>junit</artifactid>             <version>4.11</version>             <scope>test</scope>         </dependency>         <dependency>             <groupid>log4j</groupid>             <artifactid>log4j</artifactid>             <version>1.2.16</version>         </dependency>         <dependency>             <groupid>org.xerial</groupid>             <artifactid>sqlite-jdbc</artifactid>             <version>3.7.2</version>         </dependency>         <dependency>             <groupid>commons-dbcp</groupid>             <artifactid>commons-dbcp</artifactid>             <version>1.2.2</version>         </dependency>     </dependencies>     <build>         <finalname>socialmedia</finalname>         <plugins>             <plugin>                 <groupid>org.apache.maven.plugins</groupid>                 <artifactid>maven-compiler-plugin</artifactid>                 <version>3.0</version>                 <configuration>                     <source>1.6</source>                     <target>1.6</target>                 </configuration>             </plugin>             <plugin>                 <groupid>org.mortbay.jetty</groupid>                 <artifactid>maven-jetty-plugin</artifactid>                 <version>6.1.10</version>             </plugin>         </plugins>   </build> </project> 

thanks in advance!

adam

from reserved word in sqlite. can either use different name (if possible) or quote mentioned in linked url:

if want use keyword name, need quote it. there 4 ways of quoting keywords in sqlite:

• 'keyword' - keyword in single quotes string literal.
• "keyword" - keyword in double-quotes identifier.
• [keyword] - keyword enclosed in square brackets identifier. not standard sql. quoting mechanism used ms access , sql server , included in sqlite compatibility.
• `keyword` - keyword enclosed in grave accents (ascii code 96) identifier. not standard sql. quoting mechanism used mysql , included in sqlite compatibility.

according jpa spec (you'll need accept license agreement) seems preferred use double quotes:

@column(name = "\"from\"", nullable = false) private string from; 

cf. my related answer more (hibernate , hsql specific) details.