Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: pass (nike.apache.org: domain of zbynek_vavros@cz.ibm.com
 designates 195.75.94.111 as permitted sender)
Subject: Composite key problem
To: users@openjpa.apache.org
Message-ID: 
 <OF520C7ABE.8646D0B3-ONC1257A59.001C8786-C1257A59.001F06C8@cz.ibm.com>
From: Zbynek Vavros <Zbynek_Vavros@cz.ibm.com>
Date: Mon, 13 Aug 2012 07:38:46 +0200
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII


Hi,

Im having trouble with composite key and OpenJPA.
I was using hibernate so excuse my lack of OpenJPA knowledge.

I have a table already created and one that I cannot modify :

CREATE TABLE `admin_skills` (
`admin_id` INT(11) NOT NULL,
`account_id` INT(11) NOT NULL,
`skill` INT(11) NOT NULL DEFAULT '5',
UNIQUE INDEX `account_id` (`account_id`, `admin_id`),
INDEX `admin_id` (`admin_id`),
CONSTRAINT `admin_skills_ibfk_1` FOREIGN KEY (`admin_id`) REFERENCES
`admins` (`idadmin`) ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT `admin_skills_ibfk_2` FOREIGN KEY (`account_id`) REFERENCES
`account` (`account_id`) ON UPDATE CASCADE ON DELETE CASCADE
)

I have created following entity/key :

@Entity
@Table(name = "admin_skills")
public class DitaAdminSkill {

	@EmbeddedId
	private DitaAdminSkillPK id;

	@Column(name = "skill")
	private Integer skill;

	//getters & setters

@Embeddable
public class DitaAdminSkillPK implements Serializable{

	@ManyToOne
	@JoinColumn(name = "admin_id")
	private DitaAdmin admin;

	@ManyToOne
	@JoinColumn(name = "account_id")
	private DitaAccount account;

	//getters & setters

This works just fine with Hibernate 4.1.4Final :

	ApplicationContext applicationContext = new
ClassPathXmlApplicationContext(new String[] {"applicationContext.xml",
"db_beans.xml"});
	DitaAdminSkillDao dispDao = applicationContext.getBean
(DitaAdminSkillDao.class);
	List<DitaAdminSkill> disp = dispDao.findAll();
	System.out.println(disp.get(0).getId().getAccount());


But when I try to run this with OpenJPA I get an error : Unknown column
't0.id' in 'field list'
Seems like it is ignoring the @EmbeddedId annotation and tries to select
directly the ID, which do not exists.
I have been trying to use @IdClass instead but with pretty much same
result :(

Since OpenJPA has general lack of support/forums/everything, I wasnt able
to find anything useful through google.

If anyone has any comments, please, it will be more than welcomed.

Oh, and I am using OpenJPA 2.1.5 with Maven (tried 2.2.0-SNAPSHOT but does
the same) :

<!-- Apache implementation of JPA2.0 -->
<dependency>
	<groupId>org.apache.openjpa</groupId>
	<artifactId>openjpa-all</artifactId>
	<version>2.1.5</version>
</dependency>

Thanks !!!!