[wswwong]

Hello

Create web project using the latest MyEclipse Professional Version: 2013 SR2
Myeclips->project facets -> install jPA facet this include MyEclipse Hibernate 4.1.4 library
Then from MyEclipse Hibernate Prespective->chose JPA reverseengineering-> JAVA Data Access Generation -> findby method, Java Interfaces, basic DAO, generate support for Listed Table
After source generation all the table domain objects have compile error to show a few

@Entity
@Table(name = “acct”, catalog = “racing”)

Description Resource Path Location Type
Catalog “racing” cannot be resolved for table “acct” Acct.java /Racingtip/src/com/racing/jpa/domain line 24 JPA Problem

@AttributeOverrides({
@AttributeOverride(name = “acctNbr”, column = @Column(name = “Acct_Nbr”, nullable = false)),
@AttributeOverride(name = “partyId”, column = @Column(name = “Party_ID”, nullable = false)) })

Description Resource Path Location Type
Table “acct” for column “Acct_Nbr” is not valid for this entity Acct.java /Racingtip/src/com/racing/jpa/domain line 85 JPA Problem

@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = “Sec_Qstn_Id”)

Description Resource Path Location Type
Table “acct” for column “Sec_Ans_Tx” is not valid for this entity Acct.java /Racingtip/src/com/racing/jpa/domain line 210

Any idea what is going on or am I missing certain facets

Thanks
-Wilson

[support-swapna]

Wilson,

Thanks for reporting it. I could replicate the issue at my end with MySQL Database.

Can you please let us know which database are you working with along with the driver details ?

This looks like a JPA issue. I have filed a PR for the dev team to investigate further.

Can you please check this discussion and see if any of the suggestions help ?
https://community.jboss.org/message/602330

Let us know how it works for you.

[Author]

Posts