springs

springs

sir i am trying to insert data from form...using spring and hibernate

i got the error like this;

rg.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select user0_.ID as ID0_, user0_.community as community0_, user0_.dateofjoin as dateofjoin0_, user0_.destination as destinat4_0_, user0_.emailid as emailid0_, user0_.gender as gender0_, user0_.lastname as lastname0_, user0_.firstname as firstname0_, user0_.pno as pno0_ from Doctor user0_]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:659)
    org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:552)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

root cause

org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select user0_.ID as ID0_, user0_.community as community0_, user0_.dateofjoin as dateofjoin0_, user0_.destination as destinat4_0_, user0_.emailid as emailid0_, user0_.gender as gender0_, user0_.lastname as lastname0_, user0_.firstname as firstname0_, user0_.pno as pno0_ from Doctor user0_]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
    org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:629)
    org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
    org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
    org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
    org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:912)
    org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:904)
    naveeninsert.imple.listUser(imple.java:27)
    naveeninsert.controller.list(controller.java:30)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    java.lang.reflect.Method.invoke(Method.java:616)
    org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:471)
    org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:408)
    org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
    org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
    org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:771)
    org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:716)
    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:647)
    org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:552)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

root cause

org.hibernate.exception.SQLGrammarException: could not execute query
    org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
    org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    org.hibernate.loader.Loader.doList(Loader.java:2235)
    org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
    org.hibernate.loader.Loader.list(Loader.java:2124)
    org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
    org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
    org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
    org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149)
    org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
    org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:921)
    org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:1)
    org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
    org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
    org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:912)
    org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:904)
    naveeninsert.imple.listUser(imple.java:27)
    naveeninsert.controller.list(controller.java:30)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    java.lang.reflect.Method.invoke(Method.java:616)
    org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:471)
    org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:408)
    org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
    org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
    org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:771)
    org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:716)
    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:647)
    org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:552)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

root cause

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'user0_.community' in 'field list'
    com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
    com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
    com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
    com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
    com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
    com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)
    com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1403)
    org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
    org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
    org.hibernate.loader.Loader.getResultSet(Loader.java:1812)
    org.hibernate.loader.Loader.doQuery(Loader.java:697)
    org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
    org.hibernate.loader.Loader.doList(Loader.java:2232)
    org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
    org.hibernate.loader.Loader.list(Loader.java:2124)
    org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
    org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
    org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
    org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149)
    org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
    org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:921)
    org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:1)
    org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
    org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
    org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:912)
    org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:904)
    naveeninsert.imple.listUser(imple.java:27)
    naveeninsert.controller.list(controller.java:30)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    java.lang.reflect.Method.invoke(Method.java:616)
    org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:471)
    org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:408)
    org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
    org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
    org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:771)
    org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:716)
    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:647)
    org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:552)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
**what is this error sir...how can i solve this;**
View Answers









Related Tutorials/Questions & Answers:
springs
springs  i am beginer of spring framework any bestbooks for this framework...how i design web projects using springs and hibernate...if any sample code means ple send the link ple it s very useful for me   Please visit
Springs Core
Springs Core  what is form backing object in springs core
Advertisements
springs
springs
how to develop student details using springs
how to develop student details using springs  how to develop student details using springs
downloading excel file using Java and springs
downloading excel file using Java and springs  I need to find out how to download an excel file using the spring framework in java. Please help me out as I am new to springs and its urgent
why we use struts framework instead of springs
why we use struts framework instead of springs  why we use struts framework instead of springs    It depends upon your application requirements.In some cases spring is better and in some cases struts is better
About springs - JDBC
Java Springs Framework Tutorial
Java Springs Framework Tutorial Spring framework is a Java platform that is developed by Spring Source Company and is used develop robust Java applications. Java developers use Spring to create modular, portable and testable
Spring Null value, Set null value in Springs configuration file
Spring Null value, Set null value in Springs configuration file In this example you will see how to set null value in the Spring configuration file. NullBean.java package spring.nullvalue.example
Spring Struts2 Acegi - Security
Spring Struts2 Acegi  I want to implement Springs Acegi security with Struts2. Can some one provide me source code for that? Thanks in advance
Web application - Spring
Web application  I need one simple complete web application example using springs with database connection,i saw ur demo but it is not succfient.can u send to [email protected] am a beginner
core java - Java Beginners
core java  how to create a login page using only corejava(not servlets,jsp,hibernate,springs,structs)and that created loginpage contains database(ms-access) the database contains data what ever u r enter and automatically date
Frame works - Framework
Frame works  I need tutorials on JAVA Plugin Frameworks and hibernate and springs ? I new to these Technologies so i need with Examples to understand Using above technologies i need to do project. so ASAP pls
code for email - Spring
code for email  i want a java code using springs after login process sending an email to the corresponding with a text message to them as successfully registered  Hi Friend, Please visit the following links: http
To Generate Excel
To Generate Excel  hi First of all my application uses Struts2 with Springs and hibernate and am new to all of that and my requirement is as follows in a jsp there will be a link where if you click on that a dialog box
a quesiton on spring injection
to the springs
Hi this is kalavathi - Java Interview Questions
Hi this is kalavathi   what is the difference between hibernate and springs in java   spring is designed as a complete framework software... application. These are the main difference between Hibernate and Springs. thank you
Hibernate required jar files - Hibernate
Hibernate required jar files  Hi, What are the jar files are required for hibernate and Springs application. I want to run complete application springs and hibernate. Where it will be available? How can i use it i.e.
Spring framework implementation
Spring framework implementation  Hi, I am new to springs. Can someone help me in implementing the below case in spring? Coffee Take out problem... the coffee shop problem using springs?ADS_TO_REPLACE_1 Thanks
property datasource required - Spring
property datasource required  Hi I am using java springs I am using mysql as backend I am getting one error when i compile the application.property datasource required. This is my dispatcher-servlet.xml
Binding Error in Spring - Spring
Binding Error in Spring  Error: Neither BindingResult nor plain target object for bean name 'loginBean' available as request attribute I am trying to write a login page in Springs My jsp: User Id : ">
struts - Framework
struts  Hi,roseindia I want best example for struts Login form..Don't integrate springs and hibernate with this example i want only in struts...  Hi Friend, You can get login applications from the following
J2EE - Java Beginners
J2EE  Dear Sir, Right now i am working as a java programmer and i have to learn for J2EE. Which book is good for learning JSP, SERVLETS,EJB,HIBERNATE,SPRINGS,STRUCTS,XML and JSF. and which area i have to concentrate
Validaton(Checking Blank space) - Spring
Validaton(Checking Blank space)  Hi i am using java springs .I am having problem in doing validation. I am just checking blank space. This is my controller. I named it salescontroller. package controller; import
java - Framework
java   hi friends, Q)what is difference between...?   Hi friend, Difference between struts and springs. Struts... as the presentation tier ins spring Springs features strictly associate with presentation
Tourist Places of Sikkim India
, crystal clear lakes, silvery springs, fascinating waterfalls, gorges streams... to see the marvelous Teesta river, the medicinal and therapeutic hot springs..., Biksthang, Legship, Rinchenpong, Reshi Hot Springs, Rabdentse, Norbhugang
Latitude and Longitude of Dominica
. Beautified by some delightful waterfalls, rivers and springs, a large part
Java Training Videos
, springs, JSP, JSF, OOPs, UML, JDBC, SQL, Ajax, Hibernate framework, Struts
Tourist Places of Odisha
rivers, picturesque springs, adventurous wildlife sanctuaries and National parks... Springs, Hatkeshwar temple having bathing complex. Balangir Tourism of Orissa... and Taal. Places to Visit Taptapani Orissa : Hot water springs (Brahmapur).ADS
Tourist Places of Uttarakhand
springs, crystal clear ponds, dense forests, wonderful wildlife sanctuaries..., one of the four places of Char Dham pilgrimage Yatra, Hot water springs... of Himalayas, Samadhi of Adi Shankaracharya, several water springs, Temple
Tourist Places of Himachal Pradesh India
with lakes, hill stations, springs, valleys, passes, dense forests, and different sorts..., Vashist hot water springs and temples, Mountaineering Institute, Manali... springs. Manikaran is situated just 45 kms. from Kulu and just 3 kms. from Kasol
Bihar Tourism Information
. The important places of tourist attractions are Swarna Gufa, the hot springs
Meghalaya Tourist Places
to Garampani :  Hot Springs Tour to Jowai Meghalaya :  Tourist Resort, Lake
Dadra and Nagar Haveli Tourism
waterfall, gurgling springs attracts the tourists throughout the year. ADS
Mutliple files upload
","Struts","Hibernet","Springs","JSP","Servlet","JavaScript"); listValue = new Array("CoreJava","J2EE","J2SE","Struts","Hibernet","Springs","JSP
Mutliple files upload
","Struts","Hibernet","Springs","JSP","Servlet","JavaScript"); listValue = new Array("CoreJava","J2EE","J2SE","Struts","Hibernet","Springs","JSP
Mutliple files upload
","Struts","Hibernet","Springs","JSP","Servlet","JavaScript"); listValue = new Array("CoreJava","J2EE","J2SE","Struts","Hibernet","Springs","JSP
Mutliple files upload
","Struts","Hibernet","Springs","JSP","Servlet","JavaScript"); listValue = new Array("CoreJava","J2EE","J2SE","Struts","Hibernet","Springs","JSP
Mutliple files upload
","Struts","Hibernet","Springs","JSP","Servlet","JavaScript"); listValue = new Array("CoreJava","J2EE","J2SE","Struts","Hibernet","Springs","JSP
Bihar Tourist Places
and a low altitude hill area. Its hills, lakes, springs, flora and fauna
Tourist Places of Chhattisgarh India
Waterfalls, Tata pani springs and Mainpat etc. Raipur Tourism Chhattisgarh
Tourism Places of Jammu and Kashmir
lakes and springs, gushing rivers, eye soothing greenery packed with various
Tourist Places of Karnataka India
of a hill, at the foot natural water Springs. Dharmasthala Travel Karnataka
Explore Incredible Kerala
springs. The Janardhanswamy temple and the Sivagari Mutt Ashram are the two

Ads