exception while mapping boolean object to char table field

[dhoni Gibson]

Hi

i am getting exception during object mapping in hibernate.

here is the scenario

i have table with char(1) column , am trying to map to boolean(wrapper) object while doing so i am getting below exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:488)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:431)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)


root cause 

org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
	org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:613)
	org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
	org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:378)
	org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:847)
	org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:839)
	springapp.repository.ProductDaoImpl.getProductList(ProductDaoImpl.java:12)
	com.mystuff.product.service.SimpleProductManager.getProducts(SimpleProductManager.java:36)
	springapp.web.controllers.InventoryController.handleRequest(InventoryController.java:42)
	org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:874)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:808)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:476)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:431)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)


root cause 

org.hibernate.exception.SQLGrammarException: could not execute query
	org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
	org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	org.hibernate.loader.Loader.doList(Loader.java:2223)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
	org.hibernate.loader.Loader.list(Loader.java:2099)
	org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
	org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
	org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
	org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
	org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
	org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate(HibernateTemplate.java:856)
	org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:373)
	org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:847)
	org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:839)
	springapp.repository.ProductDaoImpl.getProductList(ProductDaoImpl.java:12)
	com.mystuff.product.service.SimpleProductManager.getProducts(SimpleProductManager.java:36)
	springapp.web.controllers.InventoryController.handleRequest(InventoryController.java:42)
	org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:874)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:808)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:476)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:431)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)


root cause 

java.sql.SQLException: Column not found: PRODUCTBO0_.ONLINEBUY in statement [select productbo0_.id as id0_, productbo0_.productName as productN2_0_, productbo0_.productType as productT3_0_, productbo0_.manufacturer as manufact4_0_, productbo0_.dateOfBuy as dateOfBuy0_, productbo0_.onlineBuy as onlineBuy0_, productbo0_.price as price0_ from products productbo0_]
	org.hsqldb.jdbc.Util.throwError(Unknown Source)
	org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
	org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
	org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:248)
	org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:302)
	org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
	org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423)
	org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
	org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
	org.hibernate.loader.Loader.doQuery(Loader.java:673)
	org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
	org.hibernate.loader.Loader.doList(Loader.java:2220)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
	org.hibernate.loader.Loader.list(Loader.java:2099)
	org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
	org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
	org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
	org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
	org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
	org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate(HibernateTemplate.java:856)
	org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:373)
	org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:847)
	org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:839)
	springapp.repository.ProductDaoImpl.getProductList(ProductDaoImpl.java:12)
	com.mystuff.product.service.SimpleProductManager.getProducts(SimpleProductManager.java:36)
	springapp.web.controllers.InventoryController.handleRequest(InventoryController.java:42)
	org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:874)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:808)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:476)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:431)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

my hbm file content

onlineBuy is the boolean method

<hibernate-mapping>
	<class name="com.mystuff.product.buisessObjects.ProductBO"
		table="products">
		<id name="id" column="id">
			<generator class="increment" />
		</id>
		<property name="productName" column="productName" />
		<property name="productType" column="productType" />
		<property name="manufacturer" column="manufacturer" />
		<property name="dateofBuy" column="dateOfBuy" />
		<property name="onlineBuy" column="onlineBuy" />
		<property name="price" column="price" />
	</class>
</hibernate-mapping>

[Anantha Sharma]

please check your DB table schema, the column in question isn't available to be selected, thats the problem here...

even though you've mapped the column (ONLINEBUY) in hibernate, the table doesn't contain a column with that name (or you might have misspelled it..