我正在使用Hibernate和H2内存数据库。数据库表根据我在persistence.xml文件中提供的bean信息自动创建。
H2将类型为org.joda.time.DateTime的字段“created”映射到类型为VARBINARY(255)的列中。
当我尝试使用值created=DateTime.now()持久化我的bean时,我收到以下错误:
H2将类型为org.joda.time.DateTime的字段“created”映射到类型为VARBINARY(255)的列中。
当我尝试使用值created=DateTime.now()持久化我的bean时,我收到以下错误:
Caused by: org.h2.jdbc.JdbcSQLException: Value too long for column "CREATED BINARY(255)": "X'aced0005737200166f72672e6a6f64612e74696d652e4461746554696d65b83c78646a5bddf90200007872001f6f72672e6a6f64612e74696d652e62617365... (273)";
SQL statement:
insert into mytable (id, created) values (null, ?) [22001-168]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
你知道为什么会出现这种情况吗?有什么解决方法吗?
很遗憾,我不能改变bean的定义,所以我必须继续使用joda DateTime。
谢谢!
P.S. 这是我的persistence.xml文件。
<persistence-unit name="my-test" transaction-type="RESOURCE_LOCAL">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<class>com.model.MyTable</class>
<exclude-unlisted-classes>true</exclude-unlisted-classes>
<shared-cache-mode>ALL</shared-cache-mode>
<properties>
<property name="javax.persistence.jdbc.driver" value="org.h2.Driver" />
<property name="javax.persistence.jdbc.url" value="jdbc:h2:tcp://localhost/c:\UnitTest;INIT=CREATE SCHEMA IF NOT EXISTS UnitTest" />
<property name="javax.persistence.jdbc.user" value="SA" />
<property name="javax.persistence.jdbc.password" value="" />
<property name="hibernate.hbm2ddl.auto" value="create-drop" />
<property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect" />
<property name="hibernate.show_sql" value = "true" />
<property name="hibernate.cache.use_query_cache" value="true" />
<property name="hibernate.max_fetch_depth" value="4" />
<property name="hibernate.cache.use_second_level_cache" value="true" />
<property name="hibernate.cache.use_query_cache" value="true" />
<property name="hibernate.cache.region.factory_class" value="net.sf.ehcache.hibernate.EhCacheRegionFactory" />
</properties>
</persistence-unit>
并且由Hibernate / H2自动生成的表:
MYTABLE
ID BIGINT(19) NOT NULL
CREATED VARBINARY(255)
这是我的Bean:
@Entity
@Table(name = "MyTable")
@Cache(usage = CacheConcurrencyStrategy.TRANSACTIONAL)
public class MyTable implements Serializable {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name = "id")
private Long id;
public Long getId() {
return id;
}
@SuppressWarnings("unused")
private void setId(Long id) {
this.id = id;
}
@Column(name = "created")
private DateTime created;
public DateTime getCreated() {
return created;
}
@SuppressWarnings("unused")
private void setCreated(DateTime created) {
this.created = created;
}
public MyTable() {
}
public MyTable(DateTime created) {
this.created = created;
}
@Override
public boolean equals(Object obj) {
...
}
@Override
public int hashCode() {
...
}
}