Hibernate Community • View topic - Problem with Projections.property and CompositeUserType

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Problem with Projections.property and CompositeUserType

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

sforner

Post subject: Problem with Projections.property and CompositeUserType

Posted: Mon Sep 18, 2006 2:32 pm

Newbie

Joined: Fri Jan 27, 2006 2:09 pm
Posts: 14

Hi,

I have a problem using Projections.property in a Criteria.
My property is named value and is a CompositeUserType (BigDecimal + Currency). The columns in the db are value_v and value_c .
Is it possible to use this kind of Projection (PropertyProjection) here?

Greetings Stefan

Hibernate version: 3.1.2

Full stack trace of any exception that occurs:
property does not map to a single column: value

Top

inemeth

Post subject: same problem

Posted: Mon Oct 30, 2006 1:50 pm

Newbie

Joined: Thu Nov 10, 2005 6:05 am
Posts: 16

Hi Stefan,

I'm currently facing the same problem, have you found any solution to it?

rgrds,
Ivan

Top

sforner

Post subject:

Posted: Mon Oct 30, 2006 2:07 pm

Newbie

Joined: Fri Jan 27, 2006 2:09 pm
Posts: 14

Hi Ivan,

I solved the problem this way:

Code:

try {
         final Criteria criteria = HibernateUtil.getSession().createCriteria(IContract.class);
         ProjectionList projections = Projections.projectionList();
         projections.add(Projections.property("value.value"));
         projections.add(Projections.property("value.currency"));
         criteria.setProjection(projections);
         return criteria.list();
      } catch (HibernateException he) {
         throw new FinderException(he.getMessage(), he);
      }

This way I receive Tuples of BigDecimal and Currency. Then you can use a ResultTransformer to transform it into whatever you want.

I hope this is helpful.

Greetings,
Stefan

Top

inemeth

Post subject:

Posted: Tue Oct 31, 2006 5:21 am

Newbie

Joined: Thu Nov 10, 2005 6:05 am
Posts: 16

Hi Stefan,

thx for the quick answer. unfortunately this isn't a solution to my problem, because I want do write a more dynamic model. I mean the user selects in runtime which properties he wants to see (some kind of dynamic filter)
eg. there is MyPerson which has an Earning field which is a Money UserType (BigDecimal and Currency). And the user can choose whether he wants to see or not the earnings of the person. so the projected properties aren't hardwired in the code.
i'm wondering why can't Hibernate convert the multi-columned UserTypes to the appropriate class in projections while this works with criterias.

regards,
Ivan

Top

Page 1 of 1

[ 4 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum