hi
i want to use composite type for example address in my project in netbean
can anybody help me????

sure, read the doc, and learn to ask better question!

http://docs.jboss.org/hibernate/stable/ ... components

i have a composite type in postgres i want use this type in hibernate for example

is it possible?

I am trying to do the same thing, using PostgreSQL with JBoss Seam, but am receiving the following error:

Caused by: org.hibernate.MappingException: Could not determine type for: MyClass, at table: myTable, for columns: [org.hibernate.mapping.Column(myColumn)]

Did you eventually figure out how to do this?

no
i couldnt solve this problem
i want help
please anyone know how to solve it help me.

azadeh,

I finally got this working. By the way, I did read the docs (particularly the hibernate annotations doc) and did not find the solution documented there. I am not claiming that this is the "correct solution". Rather, I am simply suggesting this based on what worked for me. If anyone has a "better" or "correct solution", then by all means.

I use Eclipse with JBoss AS and JBoss Seam but believe that the following should work for netbeans as well. I recommend the following:

First, in the postgresql database, include some kind of deliminator within the Address data because the solution that I propose reads the full address entry from the person table as one combined, composite string value. The Address class includes @Transient fields city and state that store the parsed city and state parts of the composite string. The parsing is done in the setter of the composite string field within the Address class. Thus for example, using brackets as a deliminator such as {1 Second Ave.}{New York} in the data in the person table, address column of postgresql.

import javax.persistence.Embedded;
@Entity
//Note: Postgresql requires names to be enclosed in `` marks if working with mixed case names
@Table(name="`person`")
public class Person implements Serializable //Definition Begin
{
private Address address;

@Embedded
public Address getAddress() { return address }

public void setAddress(Address address) { this.address = address; }

} //public class Person implements Serializable //Definition End


import javax.persistence.Embeddable;
@Embeddable
public class Address implements Serializable //Definition Begin
{
private String composite;

//I am not including the code for limiting to varchar(100). Thus, this is equivalent to postgresql text
private String street;
private String city;

//Note: in the @Column below, the name= refers to the address field in the Person class. The columnDefinition= refers to the Address type in Postgresql. Again, the `` marks are required because the A in Address is capitalized.
@Column(name="`address`", columnDefinition="`Address`")
public String getComposite() { return composite; }

public void setComposite(String composite) //Definition Begin
{
this.composite = composite;

//Write code here that will parse composite using the brackets {} deliminators such that if composite=="{1 Second Ave.}{New York}" then you set this.street="1 Second Ave." and this.city="New York".

} //public void setComposite(String composite) //Definition End


@Transient
public String getStreet {return street;}
public void setStreet(String street) {this.street = street;}


@Transient
public String getCity {return city;}
public void setCity(String city) {this.city = city;}

} //public class Address implements Serializable //Definition End

You can now access a person's street and city via: person.address.street and person.address.city

Hope that helps.

Regards,
Jeff

There is a simple example..
Hibernate Component Mapping Using Annotations

http://www.dzone.com/tutorials/java/hib ... ons-1.html