I am a bit new to this and I built some class with some simple relationships
based on an existing data base and I am getting the following error.
org.apache.renamed.openjpa.persistence.PersistenceException: Object id data
"23" loaded from the database for
"com.smartdestinations.domain.backend.impl.CardImpl.order" is not in the
correct format. Please ensure that your database records are in the correct
format.
at
org.apache.renamed.openjpa.jdbc.meta.strats.UntypedPCValueHandler.toObjectValue(UntypedPCValueHandler.java:99)
at
org.apache.renamed.openjpa.jdbc.meta.strats.HandlerFieldStrategy.load(HandlerFieldStrategy.java:203)
at
org.apache.renamed.openjpa.jdbc.meta.FieldMapping.load(FieldMapping.java:802)
My classes look like this
public class CardImpl extends AbstractSdiEntity implements Card {
private String serialNumber;
private String type;
private Integer days;
private Float version;
private String status;
private SdiOrder order;
private int id;
.
.
.
.
....@manytoone(targetEntity = SdiOrder.class)
@JoinColumn( name = "orders_id")
public SdiOrder getOrder() {
return order;
}
I have no references in the SdiOrder class. The DB tables are in mysql and
use the following create options
show create table card
CREATE TABLE `card` (
`id` int(10) NOT NULL auto_increment,
.
.
`orders_id` int(10) default NULL,
.
.
PRIMARY KEY (`id`),
UNIQUE KEY `serial_number` (`serial_number`),
KEY `orders_id` (`orders_id`),
KEY `venue_id` (`venue_id`),
KEY `product_id` (`product_id`),
KEY `region_id` (`region_id`),
KEY `expired_date` (`expired_date`),
KEY `status` (`status`),
KEY `days` (`days`),
KEY `type` (`type`),
KEY `days_limit` (`days_limit`)
If any one could help that would be great. I have trimmed down the class and
db create stuff so the post would not be too long. If you need any more info
please ask.
-Matt
