I am getting the following error while running a spring based DAO application. I am able to establish database connectivity, using ant but the programmatic access using JDBC is failing.




type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.





exception

org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT id, description, price from products]; nested exception is java.sql.SQLException: Table not found in statement [SELECT id, description, price from products]
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:223)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:493)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:528)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:553)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:574)
org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:114)
org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:124)
org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:139)
db.ProductManagerDaoJdbc.getProductList(ProductManagerDaoJdbc.java:25)
bus.ProductManager.getProducts(ProductManager.java:23)
web.SpringappController.handleRequest(SpringappController.java:36)
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:717)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:658)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:392)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:347)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)