first of all i want to thank for this is site. I'm begginer in Java and also in JPA and this site is very helpful for me. Now What is my problem. Unfortunately i have to work with postgresql + JPA + eclipselink, because is my school project. Database is final and i can't do any changes even if i wanted to. In structure of DB is this.
-- -- Name: address; Type: TYPE; Schema: artio; Owner: facman --
CREATE TYPE address AS ( street character varying, city character varying, state character varying, country character varying, zip character varying, note character varying ); ALTER TYPE artio.address OWNER TO facman;
AS you notice, in my project i have more schemats let say "public' and "artio".
i upload you screenshoot of my table called "property" https://img822.imageshack.us/i/18591958.png/
Netbeans generate for me entity class.
problem is exactly in the column address because is not typical date type but user defined. I found some example in your sites here https://www.objectdb.com/api/java/jpa/AttributeOverride but I'cant make it works. Also I have several questions.
1.Can i get access to direct value of address ? Type "address" is consist with variables street,city,zip etc.
2.How should look like get and set method ... shoud be 1 set and 1 get method for Address or for each part (street,zip,etc).
3.If there will be getAddress method what data type it will be ? Array ?
4.I uploded for you my entity class of table Property (attached) and i please need your help, or i will die in front my keyboard with trying. It is only one file, having 135 line. Very much thank you for your help and I hope for answer.
Best Regards Adam