Aug 16th, 2011, 09:07 AM
I have added a new domain class to my existing grails project.
When I click on link I am getting below error message.
Error 500: org.springframework.dao.InvalidDataAccessResourceU sgaeException: could not execute query
nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
Invalid object name 'reports'
My application is connecting to MSSQL database
Please help me in resolving this issue.
Aug 18th, 2011, 07:42 AM
Looks like Grails can't find a table called 'reports' in the database. That exception is coming from the MSSQL JDBC driver.
Aug 18th, 2011, 08:56 AM
Yes you right there is no table with "reports" in the database.
May be I am going in wrong direction please correct me.
I want create reports for my existing Grails application.
For this I need a page where I can add filters.
Can you please tell me how this can be done.