Hello, I created a backend JVM app using Exposed a...

# exposed

[Dragos Rachieru]

Hello, I created a backend JVM app using Exposed and Ktor. Can I create an android app that hosts the server using SQLite?

[e5l]

Hey! I think it should be possible with exposed and ktor-server-netty.

[Dragos Rachieru]

I tried with the xerial jdbc but it crashes, unsatisfied link exception

[Dragos Rachieru]

Guess this is no longer an exposed issue

[e5l]

Could you tell me what version xerial is used?

[Dragos Rachieru]

I added a comment here:
https://github.com/xerial/sqlite-jdbc/issues/248#issuecomment-1774070087

3.43.2.1

[Dragos Rachieru]

I just discovered that I have to manually extract the so files, will try again and update with the result

[Dragos Rachieru]

Nope, it did not work:

Caused by: org.jetbrains.exposed.exceptions.ExposedSQLException: java.sql.SQLFeatureNotSupportedException: not implemented by SQLite JDBC driver
SQL: [Failed on expanding args for INSERT: org.jetbrains.exposed.sql.statements.BatchInsertStatement@ff06b82]

[Dragos Rachieru]

override fun find(enum: RoomStatus): RoomStatusEntity? {
    return RoomStatusEntity.find { RoomStatusTable.name eq enum.name }.singleOrNull()
  }

[Dragos Rachieru]

In the end it worked, I used the wrong version in gradle