Hibernate version: 3.1.2

Code between sessionFactory.openSession() and session.close():

Session management carried out by Spring Framework

Full stack trace of any exception that occurs:

09:47:39 ERROR [org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:412)] Could not complete request
org.apache.jasper.JasperException: exception setting property value with CGLIB (set hibernate.cglib.use_reflection_optimizer=false for more info) sett
er of com.shawmut.model.project.bid.BidInvitation.setBidSubmitted
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:370)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)

Name and version of the database you are using:

MS SQL Server 2000


I have a BIT column that is mapped to a boolean attribute. This BIT column sometimes has <NULL> values in the record. Unfortunately i can not change the database schema. I know i can use Boolean attribute instead of boolean which would make the error go away in this case but i want to use booleans instead of the wrapper class.


I was hoping some one could give me some ideas to point me in the right direction. Do i need to implement a new Type? I can't imagine i'm the first to run into the situation.


Thanks in advance

Russ

Problem solved! Here's the solution:

<property name="bidSubmitted" column="Udf_Bid_Submitted" formula="CASE Udf_Bid_Submitted WHEN 0 THEN 0 WHEN 1 THEN 1 ELSE 0 END"/>

How do i give myself points? ;)


Russ

Hi,
I read the post from imchi maybe my solution could be resolve you problem...

See: the post
[url]
http://forum.hibernate.org/viewtopic.php?t=960762
[/url]

Ahhhhhhh! I see what you did. Thats a good idea. I'll have to keep that in mind. Not sure which solution i feel more comfortable with.


Thanks for the help Stef-âne!


Russ