I have a postgres database and im trying to fetch ...

# spring

[xii]

I have a postgres database and im trying to fetch a jsonb[] column from it, but I can't seem to make this work

[xii]

I imported

@TypeDefs(
    TypeDef(name = "json", typeClass = JsonStringType::class),
    TypeDef(name = "jsonb", typeClass = JsonBinaryType::class)
)

[xii]

it works fine for jsonbs of course, but doing

[xii]

@Type(type = "jsonb[]")
@Column(columnDefinition = "jsonb[]")

is of course not working

[Miguel Guilherme]

well I’m using this with spring and kotlin and it works quite well: https://github.com/vladmihalcea/hibernate-types

[Miguel Guilherme]

for class annotation I have this: @TypeDef(name = "jsonb", typeClass = JsonBinaryType::class)

[Miguel Guilherme]

and for a list as an example:

[Miguel Guilherme]

Untitled

Untitled

[Miguel Guilherme]

this is for postgresql

[xii]

interesting! and that works well?

[xii]

do you not do any parsing of it?

[xii]

you're storing data like this in your db?:
[{a:1}, {a:2}] and that parses it correctly? @Miguel Guilherme

[Miguel Guilherme]

yep

[Miguel Guilherme]

Untitled

Untitled

[Miguel Guilherme]

I ommited the data but this is in my db like this

[xii]

wow, that's really interesting, that's not at all how i expecetd it to behave

[xii]

i'll give it a try, thank you

[Miguel Guilherme]

glad it was helpful 👍

[bjonnh]

really cool, I was going to need exactly that, thanks!

[xii]

it didn’t work in my case sadly... i had to write custom generators

[Miguel Guilherme]

hmm, not sure what to say, it’s working perfectly for me, I’ve been using this library in all my projects java / kotlin with spring

[Miguel Guilherme]

implementation("com.vladmihalcea:hibernate-types-52:2.10.2")