org.hibernate.exception.SQLGrammarException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Going through the setup wizard I got an exception when trying to set the Deployment title, Session timeout, and Base URL. Error displayed: "could not load an entity: [com.atlassian.crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}]; nested exception is org.hibernate.exception.SQLGrammarException: could not load an entity: [com.atlassian.crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}] " From tomcat logs: 2011-08-18 21:33:17,363 http-8095-3 ERROR [console.action.setup.Options] could not load an entity: [com.atlassian.crowd.model.property.Property#compo nent[key,name]{name=deployment.title, key=crowd}]; nested exception is org.hibernate.exception.SQLGrammarException: could not load an entity: [com.at lassian.crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}] org.springframework.dao.InvalidDataAccessResourceUsageException: could not load an entity: [com.atlassian.crowd.model.property.Property#component[key ,name]{name=deployment.title, key=crowd}]; nested exception is org.hibernate.exception.SQLGrammarException: could not load an entity: [com.atlassian. crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}] (blah blah blah) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419) ... 114 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crowd.cwd_property' doesn't exist Looking at the database: mysql> use crowd; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +----------------------------+ | Tables_in_crowd | +----------------------------+ | cwd_app_dir_group_mapping | | cwd_app_dir_mapping | | cwd_app_dir_operation | | cwd_application | | cwd_application_address | | cwd_application_alias | | cwd_application_attribute | | cwd_directory | | cwd_directory_attribute | | cwd_directory_operation | | cwd_group | | cwd_membership | | cwd_token | | cwd_user | | cwd_user_credential_record | | hibernate_unique_key | +----------------------------+ 16 rows in set (0.00 sec) I'm using MyISAM, the hibernate dialect is MySQLDialect. My guess is that the schema creation code didn't create all the tables.
    via by Jesse Callaway,
  • Going through the setup wizard I got an exception when trying to set the Deployment title, Session timeout, and Base URL. Error displayed: "could not load an entity: [com.atlassian.crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}]; nested exception is org.hibernate.exception.SQLGrammarException: could not load an entity: [com.atlassian.crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}] " From tomcat logs: 2011-08-18 21:33:17,363 http-8095-3 ERROR [console.action.setup.Options] could not load an entity: [com.atlassian.crowd.model.property.Property#compo nent[key,name]{name=deployment.title, key=crowd}]; nested exception is org.hibernate.exception.SQLGrammarException: could not load an entity: [com.at lassian.crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}] org.springframework.dao.InvalidDataAccessResourceUsageException: could not load an entity: [com.atlassian.crowd.model.property.Property#component[key ,name]{name=deployment.title, key=crowd}]; nested exception is org.hibernate.exception.SQLGrammarException: could not load an entity: [com.atlassian. crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}] (blah blah blah) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419) ... 114 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crowd.cwd_property' doesn't exist Looking at the database: mysql> use crowd; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +----------------------------+ | Tables_in_crowd | +----------------------------+ | cwd_app_dir_group_mapping | | cwd_app_dir_mapping | | cwd_app_dir_operation | | cwd_application | | cwd_application_address | | cwd_application_alias | | cwd_application_attribute | | cwd_directory | | cwd_directory_attribute | | cwd_directory_operation | | cwd_group | | cwd_membership | | cwd_token | | cwd_user | | cwd_user_credential_record | | hibernate_unique_key | +----------------------------+ 16 rows in set (0.00 sec) I'm using MyISAM, the hibernate dialect is MySQLDialect. My guess is that the schema creation code didn't create all the tables.
    via by Jesse Callaway,
    • org.hibernate.exception.SQLGrammarException: could not load an entity: [com.atlassian. crowd.model.property.Property#component[key,name]{name=deployment.title, key=crowd}] (blah blah blah) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
    No Bugmate found.