Hi,

Trying to insert a record in to DB with boolean datatype. In DTO i have declared the type as java.lang.Boolean
While inserting the record, get an exception, what i have observed is that, the boolean datatype is getting converted to integer type (0,1)
Stack trace of the exception is given below
Is it a known problem? Is there a way out. Ultimately i need to save the record with column as boolean

Thanks in advance



Hibernate version: 3.x


Full stack trace of any exception that occurs:
javax.servlet.ServletException: org.springframework.dao.DataIntegrityViolationException: could not insert: [com.satyam.tag.college.data.CollegeCourse]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [com.satyam.tag.college.data.CollegeCourse]
org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:515)
org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:419)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:229)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)

Name and version of the database you are using: PostgreSQL8.2 on WindowsXP

The generated SQL (show_sql=true):
insert into college_courses (course_approved, course_collegeid, course_offered, course_type, last_updated_by, last_updated_time, stream_type, student_count, course_id) values (1, 157, 1, M.C.A, NULL, 2007-11-30 16:34:47.564000 +05:30:00, NULL, 0, 492)