Request processing failed; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement

1

Hi all

i have been working on a patients colors module which has a model class that extends BaseOpenmrsData , when i introduce a hibernate mapping in the hbm.xml file & the equivalent liquibase changeSet for adding a column which has a many -to-one O/R mapping relationship, i get this http error

Any help will be appreciated… Thanks

@mksd @mozzy @ruhanga

2

i can see this in your Error Logs

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'openmrs.patients_colors' doesn't exist

check the correct spelling of your table name in either hbm or liquibase config files.

1 Like
3

thanks @mozzy

1 Like
4

you could simply be connecting to a non existing table,still you might have a repetition in your code due to nested exception

1 Like
5

thanks @herbert24