We are looking for your help on the below given issue.
Issue: We have created one custom data type in PostGreSQL database as given below:
CREATE TYPE temporal as (
and this needs to be accessed by application using hibernate ORM, but concern is that we can’t select the any subtype (start_date or end_date) of temporal without using brackets () around custom data type as given below:
Create table testTemporal temporal_date temporal;
Select (temporal_date).start_date from testTemporal;
When we are trying to access start_date column using latest JPA/HIbernate version, it is not generating the queries without brackets around temporal_date like (temporal_date.start_date), which is throwing SQL Exception by saying that temporal_date is no table found in database. ( We are not using any native queries).
so please advise how to handle such scenario?
Anticipating a reply soon.