Spring Kotlin Postgres

Question

   @Entity
    @Table(name = "profiles")
    data class Profile(
    @Id
        @GeneratedValue(generator = "UUID")
        @GenericGenerator(
                name = "UUID",
                strategy = "org.hibernate.id.UUIDGenerator"
        )
        @Column(name = "id", updatable = false, nullable = false)
        val id: UUID,

    @Column(name = "first_name")
        var firstName: String? = null,

        @Column(name = "last_name")
        var lastName: String? = null,

    @Column(name = "phones")
        var phones: String? = null
}

In Postgres has table profiles and has column 'phones' => character varying[] (Array) How can I set type to update and insert datas?

I have errors if I set List<> or Array<> ArrayList<> :

org.postgresql.util.PSQLException: ERROR: column "phones" is of type character varying[] but expression is of type character varying
  Hint: You will need to rewrite or cast the expression.

Does this answer your question? Error while mapping postgres arrays in Spring JPA — chrsblck
– chrsblck, Commented Feb 3, 2020 at 4:01

error86 · Accepted Answer · 2020-02-02 10:06:52Z

0

Are you trying to get a date inside phones column? As I see it you are trying to add phones, and String is the correct type for it, I would add a logic inside postger that adds a new date upon update.

answered Feb 2, 2020 at 10:06

error86

1021 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Бекзат Сайлаубаев Over a year ago

I have many columns on db character varying[] (Array String), how can I use on Kotlin there column for array?

error86 Over a year ago

If you need a dynamic sized array, try to use a List and a foreach loop, if you need a fixed number you can use: var myArr = arrayOf("num1", num2", "num3")

Collectives™ on Stack Overflow

Spring Kotlin Postgres

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related