我有以下脚本来创建表autolife.log:
CREATE TABLE `log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`idpoint` int(11) NOT NULL,
`value` varchar(10) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `fk_point_id` (`idpoint`),
CONSTRAINT `fk_point_id` FOREIGN KEY (`idpoint`) REFERENCES `point` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=155562 DEFAULT CHARSET=latin2$$
所以我使用JPA工具从Eclipse Indigo中的表创建实体:
@Entity
public class Log implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@SequenceGenerator(name="LOG_ID_GENERATOR", sequenceName="SEQUENCE_KEY")
@GeneratedValue(strategy=GenerationType.SEQUENCE, generator="LOG_ID_GENERATOR")
private Integer id;
private Timestamp time;
private String value;
//bi-directional many-to-one association to Point
@ManyToOne
@JoinColumn(name="idpoint")
private Point point;
public Log() {
}
// get's and set's
当我在我的localhost计算机上运行时,工作正常,但是当我导出.war并投入生产时,给我这个错误(下面你可以看