Hibernate 4 : setting a default value if query returns null

Question

I have a use case where i am mapping two tables to the same object.

In this object i have a string called source and I want to be able to set the table name or the database name to this variable.

Any ideas on how to achieve this?

I have thought about iterating over my list and manually setting it but this has the potential to waste a fair chunk of time.

I appreciate this is somewhat of an odd request so this may be the only way but am hoping for a solution that maps the source variable when hibernate is mapping everything else.

"I have thought about iterating over my list and manually setting it" Could you please explain this solution in more details? — Dragan Bozanovic
– Dragan Bozanovic, Commented Jun 16, 2015 at 14:08
so at the implementation of my dao (that has a seperate datasource than my other dao) i get my list of object via criteria.list() and then for(myObject current : myList){ current.setSource("tableOne"); } — user1383163
– user1383163, Commented Jun 16, 2015 at 14:29

AntJavaDev · Accepted Answer · 2015-06-16 14:51:35Z

1

if i had understood correctly your issue , then your solution might be the MappedSuperClass , in which you must have an abstract class , which will have the common fields of the two tables and then you will extend that to the two entities you want , which will point to two different tables. Check this link

answered Jun 16, 2015 at 14:51

AntJavaDev

1,2621 gold badge20 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 11:43:42Z

0

You could try to achieve this with Load listener or Interceptors. In the listener/interceptor you can check what the data source is and populate the source field accordingly.

edited May 23, 2017 at 11:43

CommunityBot

11 silver badge

answered Jun 16, 2015 at 15:03

Dragan Bozanovic

23.6k5 gold badges50 silver badges117 bronze badges

Comments

user1383163 · Accepted Answer · 2015-06-17 18:05:50Z

0

In the end i ended up using a formula to map my variable to a select statement which was sufficient for what i needed.

answered Jun 17, 2015 at 18:05

user1383163

6071 gold badge8 silver badges27 bronze badges

Collectives™ on Stack Overflow

Hibernate 4 : setting a default value if query returns null

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related