Strange Hibernate/foreign key problem

[Lonnie Lewis]

I'm having a strange foreign key problem. I'm allowing Hibernate to create my table structure based on my annotated classes. When using the following

@Entity
@Table(name="PERSON_CAR",
       schema="DBUSER"
)
public class PersonCar
{
   @Id @GeneratedValue(strategy=GenerationType.AUTO)
    public int getId() {
        return id;
    }

    @OneToOne
    public Car getCar() {
        return car;
    }
 ...

The generated table includes:

Table: Person_Car
Columns:  ID
          CAR_ID

I'm getting a foreign key: car_id -> person_car.id

I can't figure out why it is creating the creating a foreign key back to the PERSON_CAR table. If I provide the annotation:

There is more code in the application. What other annotations create foreign keys? What could I be doing wrong?

Thanks.

[Mark Spritzler]

Try adding

@JoinColumn(name="personcarId")
or the name might be personcar_id, I forget which Hibernate will generate.

Without the @JoinColumn Hibernate will create a join table between the two tables.

However, also looking at what was generated, isn't the car_id the FK field to the car table? Which actually looks correct to me.

Mark