I don't have jOOQ generated classes, so, I want to use my class and write it to vertica.
Table<Record> table = DSL.table(DATA_TABLE_NAME);
for (Data d : data) {
dsl.insertInto(table, Arrays.asList(
DSL.field(name("uuid"), SQLDataType.UUID)
))
.values(
d.getUuid(),
).execute();
}
In PostgreSql it works, but in Vertica it generate this exception
[Vertica][VJDBC](2631) ERROR: Column "uuid" is of type uuid but expression is of type varchar
How can I write uuid tu Vertica without generated class? d.getUuid() returns java.Util.UUID
Copyright Notice:Content Author:「Hayami Pysh」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/61226843/write-uuid-in-vertica-with-jooq