Description Nathan Beyer (Cerner) 2008-07-17 15:06:30 EDT

Build ID:  I20080617-2000

Steps To Reproduce:
1. Import attached project archive (zip) into Eclipse 3.4 and a JavaSE-1.6 EE available.
2. Execute the 'pkbug.Main' class. This should result in a lot of output to the console and a final error about a constraint violation on a duplicated primary key.


More information:
Given the following classes and persistence.xml file --

-- ThreadInfo.java --
package pkbug;

import javax.persistence.Embeddable;

@Embeddable
public class ThreadInfo {

    private long id;
    private String name;

    public ThreadInfo() {}

    public long getId() {
        return id;
    }

    public void setId(long id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

}

-- MachineState.java --
package pkbug;

import javax.persistence.AttributeOverride;
import javax.persistence.AttributeOverrides;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;

@Entity
public class MachineState {

    @Id
    private long id;

    @AttributeOverrides( { 
        @AttributeOverride(name = "id", column = @Column(name = "THREAD_ID")),
        @AttributeOverride(name = "name", column = @Column(name = "THREAD_NAME")) })
    private ThreadInfo thread;

    public MachineState() {}

    public long getId() {
        return id;
    }

    public void setId(long id) {
        this.id = id;
    }

    public ThreadInfo getThread() {
        return thread;
    }

    public void setThread(ThreadInfo thread) {
        this.thread = thread;
    }

}

-- persistence.xml --
<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
    <persistence-unit name="pkbug" transaction-type="RESOURCE_LOCAL">
        <class>pkbug.MachineState</class>
        <class>pkbug.ThreadInfo</class>
        <exclude-unlisted-classes>true</exclude-unlisted-classes>
    </persistence-unit>
</persistence>

EclipseLink will dynamically generate the following DDL statement to create the table.

CREATE TABLE MACHINESTATE (ID BIGINT, THREAD_ID BIGINT NOT NULL, THREAD_NAME VARCHAR(255), PRIMARY KEY (THREAD_ID))

Note that 'PIMARY KEY' is on 'THREAD_ID' instead of 'ID', which is the field that has the @Id annotation.