Here is how we get the id of the added row (source): val munichId = Cities.insert { it[name] = "Munich" } get Cities.id What about getting the whole row? I use map for select operations...

I am trying to batch insert records into an SQL table using Kotlin Exposed. I have set up the code as per the Exposed documentation, however, the SQL statements being executed are individual insert...

I want to add a custom field when doing a complex join with a value Basically something like this: SELECT p.first_name, "Smith" AS "last_name" FROM person p WHERE first_name = ...

I am setting up some many-to-many relationships and have so far been using the Exposed DSL pattern (as opposed to DAO). However, creating many-to-many relationships seem to only be possible using t...

When trying to fetch the first row from my transaction, I receive an error: java.lang.IllegalStateException: No transaction in context. My code looks like this: fun loadPlayer(client: Client)...

I have added some Postgresql types to Exposed as extensions. It has two ready types named enumeration and enumerationByName. I tested both of them with no success for mapping a postgre enum type to...

I've looked around but cannot seem to find how in the world to 'insert if not exists' or 'insert on conflict' using the Exposed SQL framework for Kotlin. I am currently writing raw SQL statements a...

I'm trying to run some sql specific to postgres and would like to reuse the transaction management within Exposed.

I am writing a service using Ktor and Exposed ORM which apparently isn't async. I am coming from the Python world and back there using a blocking ORM with a async IO library is a sin as it may bloc...

I want to define a column of type date. This column should hold the current date of the resource created. How do i set this up? I'm new to kotlin. In python, one would impletement it this way: da...

I use Exposed as O/R Mapper on Kotlin JVM project. (version: 0.17.6) I had trouble with the N+1 query problem when I got a foreign key column's value from DAO API (columns defined by Exposed's ref...

All of the material I can find on Kotlin exposed library assumes that the table has a primary identity column, and so the entities are in most examples shown inherit the IntEntity abstract class. F...

I am new to Kotlin and recently started working on Ktor server. To perform database operations server needs to communicate with MySql server. I started using JetBrains Exposed library to write data...

I have two entities in a One-To-Many relationship. The "One" entity owns the "Many"'s lifecycle. If the "One" entity is deleted, I want all "Many" entities who belong to the "One" to be deleted aut...

I tryed to fix a problem with encodings. So, I sent from 'Postman', from web browser request to server, where I search data in database by keys in request. Request can be like this: http://localho...

What I try to do is get a lot of data about heroes in a game and save it in a DB, I use OkHttp to make request to the server and gson to parse the json and then save the classes I get from gson to ...

I know that you in general can call Kotlin code from Java, but is this something worth doing when doing Exposed? Or is it's API too tied to the idomatic way of coding Kotlin. Has any one experienc...

I have the following user table object & entity class: object UserTable : IntIdTable() { val name = varchar("name", 256) } class User(id: EntityID<Int>): IntEntity(id) { companion obj...

Following the example provided on Exposed I am not able to read the created tables/data outside the transaction creating it. I am using h2-in-memory database. The exception is: Exception in threa...

I'm using Exposed as my database library and I'm getting these errors when I try to run my code: Exception in thread "main" java.lang.NoClassDefFoundError: kotlin/reflect/full/KClasses at org.jet...

On the github page of Jetbrains' Exposed,a Kotlin SQL Framework, there is a link to a page where you can get the maven dependency for this library (https://bintray.com/kotlin/exposed/exposed/view#)...

How do you enable logging of sql queries generated by Exposed in Spring Boot? The following do not work: logging.level.org.jetbrains.exposed.sql: DEBUG logging.level.org.jetbrains.exposed: DEBUG