I have a micro-service in Ktor and I wanted to add a new column (attribute) in a Table. Let’s call t...

# exposed

[Renaud]

I have a micro-service in Ktor and I wanted to add a new column (attribute) in a Table. Let’s call this attribute given_name. Using Flyway, I’ve successfully added this new attribute to my table (I can see it using a DB file explorer) and I have added the following line :

object MyTable : ExtendedUUIDTable("whateverTable") {
    ...
    val givenName: Column<String> = text("given_name")
}

When I try to use this field, I get the following exception :

java.lang.IllegalStateException: com.innovorder.server.data.model.WhateverTable.given_name is not initialized yet

I found that Exposed is missing some wiki pages regarding doing DB migration. Did someone run into this error as well?

[Phil Richardson]

Did your migration initialise values to the new column, or are the rows returning null for this this due to the lack of initialization?

If they are null as I suspect could be the case, you have a two options.

1: Make the column nullable in your Table object, i.e. val givenName: Column<String> = text("given_name").nullable()
2: Leave the column as not nullable, but have a client side default val givenName: Column<String> = text("given_name").clientDefault("")

[Renaud]

I put the column as nullable and it solved my problem 👍 Thanks Phil !