I am trying out the demo address application and I am having a problem with the save button when saving items back in the database to
change some of the data like the persons name. The database is
MYSQL
and I am using the
mysql-connnector-java-5.1.18.jar
and
vaadin-sqlcontainer-1.1.0.jar
The program saves all new items in the database, but you can’t edit any of the items. I get the following error message: The id field in the database is a Int.
com.vaadin.event.ListenerMethod$MethodException
Cause: java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Integer
at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:532)
at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:164)
at com.vaadin.ui.AbstractComponent.fireEvent(AbstractComponent.java:1219)
at com.vaadin.ui.Button.fireClick(Button.java:550)
at com.vaadin.ui.Button.changeVariables(Button.java:217)
at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.changeVariables(AbstractCommunicationManager.java:1445)
at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.handleVariableBurst(AbstractCommunicationManager.java:1393)
at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.handleVariables(AbstractCommunicationManager.java:1312)
at com.vaadin.terminal.gwt.server.AbstractCommunicationManager.doHandleUidlRequest(AbstractCommunicationManager.java:763)
at com.vaadin.terminal.gwt.server.CommunicationManager.handleUidlRequest(CommunicationManager.java:296)
at com.vaadin.terminal.gwt.server.AbstractApplicationServlet.service(AbstractApplicationServlet.java:501)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:680)
Caused by: java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Integer
at com.example.testdemoapp.DemoFreeformQueryDelegate.storeRow(DemoFreeformQueryDelegate.java:106)
at com.vaadin.addon.sqlcontainer.query.FreeformQuery.storeRow(FreeformQuery.java:280)
at com.vaadin.addon.sqlcontainer.SQLContainer.commit(SQLContainer.java:855)
at com.example.testdemoapp.TestdemoappApplication$2.buttonClick(TestdemoappApplication.java:104)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:512)
… 23 more
the database table which it is trying to save is
delimiter $$
CREATE TABLE people (
ID int(10) unsigned NOT NULL AUTO_INCREMENT,
FIRSTNAME varchar(32) DEFAULT NULL,
LASTNAME varchar(32) DEFAULT NULL,
COMPANY varchar(32) DEFAULT NULL,
MOBILE varchar(20) DEFAULT NULL,
WORKPHONE varchar(20) DEFAULT NULL,
HOMEPHONE varchar(20) DEFAULT NULL,
WORKEMAIL varchar(128) DEFAULT NULL,
HOMEEMAIL varchar(128) DEFAULT NULL,
STREET varchar(32) DEFAULT NULL,
ZIP varchar(16) DEFAULT NULL,
CITY varchar(32) DEFAULT NULL,
STATE varchar(2) DEFAULT NULL,
COUNTRY varchar(32) DEFAULT NULL,
PRIMARY KEY (ID)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1$$
The two java files are from the demo. DemoFreeFormQueryDelegate.java and TestdemoApplication.java