Map db-functionresult to jpa entity property

Question

I have here a table, where the date is a number. (days since year 0) In the database (oracle) there is a custom function, which converts the number to a date.

Is there an easy way to use that in an jpa Entity?

I just need this for reading. Sure, I could read out the number and convert it myself, but it would be better if i just could use the function.

Something like:

@Entity
public class Person{

@Column(name="toCustomDate(dateAsNumber)")
private Date date;

}

Dylan Reniers · Accepted Answer · 2015-02-25 07:47:22Z

2

The best shot would be to look into the @Formula annotation, or simply save that date instead of the number in your database?

answered Feb 25, 2015 at 7:47

Dylan Reniers

801 gold badge1 silver badge9 bronze badges

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

1 Comment

griFlo Over a year ago

The table is about 15 years old and still in use in many different applications. But the @Formula annotation does it for me!

Collectives™ on Stack Overflow

Map db-functionresult to jpa entity property

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related