springs

Home Answers Viewqa Spring springs

naveenkumar

springs
0 Answer(s) a year and a month ago
Posted in : Spring

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

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

Springs Core
Springs Core what is form backing object in springs core

About springs - JDBC

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

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 raghavendra@oneapps.com.I 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? 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
? 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..., Rinchenpong, Reshi Hot Springs, Rabdentse, Norbhugang Tourism Destinations in North

Latitude and Longitude of Dominica
. Beautified by some delightful waterfalls, rivers and springs, a large part

Tourist Places of Odisha
rivers, picturesque springs, adventurous wildlife sanctuaries and National parks... of Odisha given below: Atri Tourism of Odisha: Hot water Springs, Hatkeshwar.... Places to Visit Taptapani Orissa : Hot water springs (Brahmapur). Tour

Tourist Places of Uttarakhand
springs, crystal clear ponds, dense forests, wonderful wildlife sanctuaries... Dham pilgrimage Yatra, Hot water springs. Travel to Chakrata: Enchanting..., Samadhi of Adi Shankaracharya, several water springs, Temple of Bhairavnath, Gandhi

Tourist Places of Himachal Pradesh India
with lakes, hill stations, springs, valleys, passes, dense forests, and different sorts..., Kothi, Solang valley, Nehru kund, Vashist hot water springs and temples... for its hot springs. Manikaran is situated just 45 kms. from Kulu and just 3 kms

Bihar Tourism Information
, the hot springs, Griddhakuta Parvat and Vishwa Shanti Stupa. Bodhgaya

Meghalaya Tourist Places
waterfalls & caves, Kynerm waterfalls. Visit to Garampani : Hot Springs Tour

Dadra and Nagar Haveli Tourism
, gurgling springs attracts the tourists throughout the year. Must to see Tribal

Mutliple files upload
","Struts","Hibernet","Springs","JSP","Servlet","JavaScript"); listValue = new Array("CoreJava","J2EE","J2SE","Struts","Hibernet","Springs","JSP

Initialising Fields before Superconstructor call - Java Tutorials
that springs to mind is inheritance. Instead of having one CustomerView, we make

Tourist Places of Chhattisgarh India
Waterfall, Kendai Waterfalls, Tata pani springs and Mainpat etc. Raipur Tourism

Bihar Tourist Places
in Nalanda district and a low altitude hill area. Its hills, lakes, springs

West Bengal Tourist Places
, Mahishasurmardini Temple, Hot Water Springs. Bandel Tourist Places of West Bengal : Former

Logging Tutorial - Part 1
(System.out.println springs to mind). In that case you are back to the first problem of too

Tourism Places of Jammu and Kashmir
several picturesque landscapes, crystal clear watery lakes and springs, gushing

Tourist Places of Karnataka India
? Ugranarsimha temple on the top of a hill, at the foot natural water Springs

Explore Incredible Kerala
resort which is rich in mineral water springs. The Janardhanswamy temple

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics