• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Error: Hibernate operation: could not retrieve snapshot

 
Chris Boldon
Ranch Hand
Posts: 190
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a program using Spring and Hibernate3.

I am getting the following error, and cannot seem to find a solution or hint anywhere:

work.jdbc.BadSqlGrammarException: Hibernate operation: could not retrieve snapshot: [com.x.pmo.vo.Project#12345]; bad SQL grammar [select project_.project_id, project_.project_name as project2_0_, project_.project_date_added as project3_0_, project_.project_priority as project4_0_, project_.project_sponsor as project5_0_, project_.project_manager as project6_0_, project_.project_health as project7_0_, project_.project_fiscal as project8_0_, project_.project_organization as project9_0_, project_.scope_comments as scope10_0_, project_.scope_health as scope11_0_, project_.scope as scope0_, project_.scope_override as scope13_0_, project_.budget_health as budget14_0_, project_.budget_comments as budget15_0_, project_.budget_pj1_status as budget16_0_, project_.budget_pj2_status as budget17_0_, project_.budget_pj3_status as budget18_0_, project_.budget_pj4_status as budget19_0_, project_.budget_pj1_override as budget20_0_, project_.budget_pj2_override as budget21_0_, project_.budget_pj3_override as budget22_0_, project_.budget_pj4_override as budget23_0_, project_.milestone_concept_plan as milestone24_0_, project_.milestone_concept_act as milestone25_0_, project_.milestone_feas_plan as milestone26_0_, project_.milestone_feas_act as milestone27_0_, project_.milestone_dev_plan as milestone28_0_, project_.milestone_dev_act as milestone29_0_, project_.milestone_prod_plan as milestone30_0_, project_.milestone_prod_act as milestone31_0_, project_.milestone_concept_met as milestone32_0_, project_.milestone_feas_met as milestone33_0_, project_.milestone_dev_met as milestone34_0_, project_.milestone_prod_met as milestone35_0_, project_.milestone_concept_override as milestone36_0_, project_.milestone_feas_override as milestone37_0_, project_.milestone_dev_override as milestone38_0_, project_.milestone_prod_override as milestone39_0_, project_.milestone_health as milestone40_0_, project_.milestone_comments as milestone41_0_, project_.project_status as project42_0_, project_.project_cost_center as project43_0_, project_.project_date_updated as project44_0_ from projects__project project_ where project_.project_id=?]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'projects.projects__project' doesn't exist
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'projects.projects__project' doesn't exist


ProjectDAOImpl.java:


applicationContext.xml


Test.java:
 
Arun Kumarr
Ranch Hand
Posts: 661
Eclipse IDE Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Does your MySQL script for Project have 'projects__project' column entry?
can you check it?
 
Chris Boldon
Ranch Hand
Posts: 190
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No, project is a table of projects and every value in the table is in the form of project_id, projcet_name etc... . I checked my hibernate mapping and it's looking good:


My Spring config looks to be calling the mapping fine:

[ August 16, 2006: Message edited by: Chris Boldon ]
 
Arun Kumarr
Ranch Hand
Posts: 661
Eclipse IDE Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I see this line in the SQL generated by hibernate.
from projects__project project_


what is projects__project? Table Name?
[ August 16, 2006: Message edited by: Arun Kumarr ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic