为 @Type(type=xxx) 的列指定列长度

发布于 2024-12-10 13:23:11 字数 806 浏览 0 评论 0原文

为了将来自主机数据库表的一些特殊字符删除到我的应用程序中，我必须创建自己的数据类型。

@Column(name="LAST_UPDATED_BY", nullable=false, length=24)
@Type(type="com.xx.CleanedString")
public String getLastUpdatedBy() {
    return this.lastUpdatedBy;
}
public void setLastUpdatedBy(String lastUpdatedBy) {
    this.lastUpdatedBy = lastUpdatedBy;
}

CleanedString 实现 UserType，其 sqlTypes() 被定义为 int[] { Types.CHAR }。基本上，它在迭代 char 数组并过滤掉特殊字符后重建 String。

public int[] sqlTypes() {
    return new int[] { Types.CHAR };
}

应用程序工作得很好，但我在运行 DBUnit 时遇到问题。当 Hibernate 在 HSQLDB 中创建表时（我将 hibernate.hbm2ddl.auto 设置为 create-drop），它会创建一个 CHARACTER 类型的列> 长度为 1。它忽略了我上面指定的 24 的 @column 的长度属性。

有没有办法在此场景中指定列长度？

原文

In order to remove few special characters coming from my host database tables into my application, I had to create my own datatype.

@Column(name="LAST_UPDATED_BY", nullable=false, length=24)
@Type(type="com.xx.CleanedString")
public String getLastUpdatedBy() {
    return this.lastUpdatedBy;
}
public void setLastUpdatedBy(String lastUpdatedBy) {
    this.lastUpdatedBy = lastUpdatedBy;
}

CleanedString implements UserType whose sqlTypes() is defined as an int[] { Types.CHAR }. Basically it rebuilds String after iterating the char array and filtering it out the special characters.

public int[] sqlTypes() {
    return new int[] { Types.CHAR };
}

Application works perfectly fine but I am having problem running my DBUnit. When Hibernate creates the table in HSQLDB (I have hibernate.hbm2ddl.auto set to create-drop), it is creating a column of type CHARACTER with length as 1. It is ignoring the length attribute of my @column specified 24 above.

Is there a way to specify column length in this scneraio?

分享到QQ

分享到微博