[求助]用hibernate插入表单数据报错..

Kipen 2007-04-18 11:28:52
工具:myeclipse
数据库:mysql
架构是:Struts+Sping+Hibernate
项目:学生选课系统

//addstu.jsp

form是:xh,password,xm,yx,major

然后填充到AddstuForm

_____________________________________________
//AddstuFormAction的execute()方法

AddstForm addstForm = (AddstForm) form;// TODO Auto-generated method stub
Student stu=new Student();

stu.setXh(addstForm.getXh());
stu.setPassword(addstForm.getPassword());
stu.setXm(addstForm.getXm());
stu.setYx(addstForm.getYx());
stu.setMajor(addstForm.getMajor());
studentdao.save(stu);

return mapping.findForward("succeed");
______________________________________


//StudentDAO.java

public void save(Student transientInstance) {
log.debug("saving Student instance");
try {
System.out.println("ssssssssss");
getHibernateTemplate().save(transientInstance);
log.debug("save successful");
} catch (RuntimeException re) {
log.error("save failed", re);
throw re;
}
}

---------------------

★tomcat可以执行到System.out.println("ssssssssss");
输出ssssssssss


type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Hibernate operation: could not insert: [org.rockie.dao.Student]; bad SQL grammar [insert into stucourse__student (XH, PASSWORD, XM, YX, MAJOR) values (?, ?, ?, ?, ?)]; nested exception is java.sql.SQLException: Base table or view not found, message from server: "Table 'stucourse.stucourse__student' doesn't exist"
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:523)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


root cause

org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not insert: [org.rockie.dao.Student]; bad SQL grammar [insert into stucourse__student (XH, PASSWORD, XM, YX, MAJOR) values (?, ?, ?, ?, ?)]; nested exception is java.sql.SQLException: Base table or view not found, message from server: "Table 'stucourse.stucourse__student' doesn't exist"
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:224)
org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:411)
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:371)
org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:614)
org.rockie.dao.StudentDAO.save(StudentDAO.java:36)
org.rockie.action.AddstAction.execute(AddstAction.java:58)
org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


note The full stack trace of the root cause is available in the Apache Tomcat/5.5.17 logs.


...全文
206 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
Kipen 2007-04-19
  • 打赏
  • 举报
回复
找不到表'stucourse.stucourse__student'


不是这个问题
自己昨晚调了1.晚..
终于解决了
是XXXX.hbm.xml的文件问题..
leasa 2007-04-18
  • 打赏
  • 举报
回复
找不到表'stucourse.stucourse__student'

81,095

社区成员

发帖
与我相关
我的任务
社区描述
Java Web 开发
社区管理员
  • Web 开发社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧