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

错误：

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

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 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.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问题吧