java Jooq数组作为集合
我想用java中的集合而不是数组来序列化postgreSQL数组。例如int[],varchar(256)[]到java集合和集合
我使用jooq 3.6.2、java 8和postgresql 9.2.9
我尝试实现自定义绑定:
public class PostgresArrayBinding implements Binding<Object, Collection> {
@Override
public Converter<Object, Collection> converter() {
return new Converter<Object, Collection>() {
@Override
public Collection from(final Object dbObj) {
return dbObj == null ? null : new ArrayList<>(Arrays.asList((Object[])dbObj));
}
@Override
public Object to(final Collection userObject) {
return userObject == null ? null : "ARRAY[" + Joiner.on(',').join(userObject) + "]";
}
@Override
public Class<Object> fromType() {
return Object.class;
}
@Override
public Class<Collection> toType() {
return Collection.class;
}
};
}
@Override
public void sql(final BindingSQLContext<Collection> ctx) throws SQLException {
ctx.render().visit(DSL.val(ctx.convert(converter()).value())).sql("::ARRAY");
}
@Override
public void register(final BindingRegisterContext<Collection> ctx) throws SQLException {
ctx.statement().registerOutParameter(ctx.index(), Types.ARRAY);
}
@Override
public void set(final BindingSetStatementContext<Collection> ctx) throws SQLException {
ctx.statement().setString(ctx.index(), Objects.toString(ctx.convert(converter()).value(), null));
}
@Override
public void set(final BindingSetSQLOutputContext<Collection> ctx) throws SQLException {
throw new SQLFeatureNotSupportedException();
}
@Override
public void get(final BindingGetResultSetContext<Collection> ctx) throws SQLException {
ctx.convert(converter()).value(ctx.resultSet().getString(ctx.index()));
}
@Override
public void get(final BindingGetStatementContext<Collection> ctx) throws SQLException {
ctx.convert(converter()).value(ctx.statement().getString(ctx.index()));
}
@Override
public void get(final BindingGetSQLInputContext<Collection> ctx) throws SQLException {
throw new SQLFeatureNotSupportedException();
}
}
和jooq-config。xml:
<configuration>
...
<generator>
<database>
<name>org.jooq.util.postgres.PostgresDatabase</name>
<includes>.*</includes>
<excludes>schema_version</excludes>
<inputSchema>public</inputSchema>
<customTypes>
...
<customType>
<name>ARRAY</name>
<type>java.util.Collection</type>
<binding>ru.fabit.contingent.configuration.persistence.PostgresArrayBinding</binding>
</customType>
</customTypes>
<forcedTypes>
...
<forcedType>
<name>ARRAY</name>
<expression>.*_ARRAY</expression>
<types>.*</types>
</forcedType>
</forcedTypes>
</database>
<generate>
<records>true</records>
<interfaces>true</interfaces>
<relations>true</relations>
<validationAnnotations>true</validationAnnotations>
</generate>
<target>
<packageName>ru.fabit.contingent.models.generated</packageName>
<directory>src/main/java/</directory>
</target>
</generator>
</configuration>
SQL:
创建表数组测试(字符串数组varchar(256)[])
我在生成的类中出错:
public final TableField<ArrayTestsRecord, Collection[]> STRING_ARRAY = createField("string_array", org.jooq.impl.DefaultDataType.getDefaultDataType("java.util.Collection").getArrayDataType(), this, "", new PostgresArrayBinding());
找不到适合createField的方法(String、DataType、ArrayTests、String、PostgresArrayBinding)
有什么想法吗
# 1 楼答案
这是由于代码生成器中的一个错误造成的,该错误针对jOOQ 3.8进行了修复: https://github.com/jOOQ/jOOQ/issues/4388
恐怕,对于jOOQ 3.7或更低版本,除了手动修补错误生成的代码之外,没有其他解决方法