[jboss-user] [Beginners Corner] - problem trying to create new bean (EJB2.0)

[MikePhoenix]

I'm trying to create a new entity bean for an existing application. When I deploy I get the following error:

anonymous wrote : org.jboss.deployment.DeploymentException: Field changeDate in prim-key-class must be of the same type.

New table sql
CREATE TABLE `projecthistory` (
  |   `ProjectId` int(11) NOT NULL default '0',
  |   `ChangeDate` datetime NOT NULL,
  |   `UserID` varchar(50) NOT NULL,
  |   `Status` int(11) NOT NULL default '0',
  |   PRIMARY KEY (`ProjectId`, `ChangeDate`), 
  |   KEY `projecthistory_ProjectID_FK` (`ProjectId`),
  |   CONSTRAINT `projecthistory_ProjectID_FK` FOREIGN KEY (`ProjectId`) REFERENCES `projects` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE 
  | );

prim-key in ejb-jar.xml
<prim-key-class>lingonet.projecthistory.ProjectHistoryKey</prim-key-class>

The key class
public class ProjectHistoryKey {
  |     public Integer projectID;
  |     public Date changeDate;
  | 
  |     public ProjectHistoryKey (Integer projectID, Date changeDate) {
  |         this.projectID = projectID;
  |         this.changeDate = changeDate;
  |     }
  | }
  | 

I am using java.util.date in my java code, which works for other beans where the date isn't a primary key? Do I need to use java.sql.date or is there just a problem using dates in primary keys or something else entirely? Some guidance here would be appreciated.

Mike

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4193849#4193849

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4193849