SSH架构使用myeclipse自动生成的hbm的错误解决

来源：互联网发布：网络用语拔草什么意思编辑：程序博客网时间：2024/06/07 01:20

错误：

当进行插入操作时有如下异常：

javax.servlet.ServletException: Hibernate operation: Could not execute JDBC batch update; bad SQL grammar [insert into studentmanager__people (name, location, id) values (?, ?, ?)]; nested exception is java.sql.BatchUpdateException: Table 'studentmanager.studentmanager__people' doesn't existorg.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.doGet(ActionServlet.java:414)javax.servlet.http.HttpServlet.service(HttpServlet.java:689)javax.servlet.http.HttpServlet.service(HttpServlet.java:802)org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77)

看似是表名'studentmanager.studentmanager__people' 出现了错误，好像多了一个 studentmanager

因为hbm文件是用myeclipse自动生成的，所以就没有在意，突然发现，myeclipse自动生成的hbm文件有如下字段：

<hibernate-mapping package="domain">
    <class name="People" table="people" catalog="studentmanager" >
        <id name="id" type="java.lang.Integer">
            <column name="id" />
            <generator class="increment"></generator>
        </id>
        <property name="name" type="java.lang.String">
            <column name="name" length="11" />
        </property>
        <property name="location" type="java.lang.String">
            <column name="location" length="11" />
        </property>
    </class>
</hibernate-mapping>

注意，有一个catalog="studentmanager" ，这代表数据库名字，把这个去掉后，一切正常

我用的是mysql数据库，我想根这个有关系吗？因为hibernate打印出的SQL是
Hibernate: insert into studentmanager__people (name, location, id) values (?, ?, ?)

我在用mysql-front输入

insert into studentmanager_people values(12,"1","1");

同样会报错，说表名'studentmanager.studentmanager__people' 不存在，我想可能是mysql问题吧