I have to map a data type created in PostgreSQL, but in hibernate documentation found nothing related. It is a type created in the PostgreSQL object-relational database. Has anyone managed to do this kind of mapping? Is it possible? Below is the SQL of the data type and table. Any help will be appreciated.
Code:
CREATE TYPE tp_data AS (
value_integer integer,
value_double double precision,
value_text character varying(100),
value_date date,
value_time time without time zone
);
CREATE TABLE cultivar_variable (
cultivar integer NOT NULL,
variable integer NOT NULL,
data_type character(1) NOT NULL,
data_value tp_data NOT NULL
);
Login
FAQ
Search