Hello does anyone tried to connect to SQLite in memory stora

Question

Hello does anyone tried to connect to SQLite in memory storage using Exposed I tried this but doesn t works ```Database connect url = jdbc sqlite memory driver = org sqlite JDBC TransactionManager manager defaultIsolationLevel = Connection TRANSACTION SERIALIZABLE``` Follow the wiki and use `Database connect jdbc sqlite file test mode=memory amp cache=shared org sqlite JDBC ` and doesn t work either Not sure what I missing Any suggestions are appreciated Thanks

tapac · Answer

Did you get any exeption

shengyou · Answer

I use it inside a Ktor application The application can start without any problem But when I try to read write from SQLite It thrown exception and said SQL error or missing database

shengyou · Answer

```2021 02 27 00 33 41 151 main DEBUG Exposed CREATE TABLE IF NOT EXISTS tasks id INTEGER PRIMARY KEY AUTOINCREMENT title VARCHAR 255 NOT NULL completed BOOLEAN DEFAULT 0 NOT NULL 2021 02 27 00 33 41 169 main INFO Application Responding at <http 0 0 0 0 8080> 2021 02 27 00 34 19 822 eventLoopGroupProxy 4 2 DEBUG Exposed SELECT tasks id tasks title tasks completed FROM tasks ORDER BY tasks id DESC 2021 02 27 00 34 19 824 eventLoopGroupProxy 4 2 WARN Exposed Transaction attempt 0 failed org sqlite SQLiteException SQLITE ERROR SQL error or missing database no such table tasks Statement s SELECT tasks id tasks title tasks completed FROM tasks ORDER BY tasks id DESC org jetbrains exposed exceptions ExposedSQLException org sqlite SQLiteException SQLITE ERROR SQL error or missing database no such table tasks at org jetbrains exposed sql statements Statement executeIn$exposed core Statement kt 50 at org jetbrains exposed sql Transaction exec Transaction kt 126 at org jetbrains exposed sql Transaction exec Transaction kt 112 at org jetbrains exposed sql Query iterator Query kt 212 at org jetbrains exposed sql IterableExKt$mapLazy$1 iterator IterableEx kt 129 at io kraftsman ApplicationKt$module$3$3$tasks$1 invoke Application kt 143 at io kraftsman ApplicationKt$module$3$3$tasks$1 invoke Application kt at org jetbrains exposed sql transactions ThreadLocalTransactionManagerKt$inTopLevelTransaction$1 invoke ThreadLocalTransactionManager kt 170 at org jetbrains exposed sql transactions ThreadLocalTransactionManagerKt$inTopLevelTransaction$2 invoke ThreadLocalTransactionManager kt 211 at org jetbrains exposed sql transactions ThreadLocalTransactionManagerKt keepAndRestoreTransactionRefAfterRun ThreadLocalTransactionManager kt 219 at org jetbrains exposed sql transactions ThreadLocalTransactionManagerKt inTopLevelTransaction ThreadLocalTransactionManager kt 210 at org jetbrains exposed sql transactions ThreadLocalTransactionManagerKt$transaction$1 invoke ThreadLocalTransactionManager kt 148 at org jetbrains exposed sql transactions ThreadLocalTransactionManagerKt keepAndRestoreTransactionRefAfterRun ThreadLocalTransactionManager kt 219 at org jetbrains exposed sql transactions ThreadLocalTransactionManagerKt transaction ThreadLocalTransactionManager kt 120 at org jetbrains exposed sql transactions ThreadLocalTransactionManagerKt transaction ThreadLocalTransactionManager kt 118 at org jetbrains exposed sql transactions ThreadLocalTransactionManagerKt transaction$default ThreadLocalTransactionManager kt 117 at io kraftsman ApplicationKt$module$3$3 invokeSuspend Application kt 53 at io kraftsman ApplicationKt$module$3$3 invoke Application kt at io ktor util pipeline SuspendFunctionGun loop SuspendFunctionGun kt 243 at io ktor util pipeline SuspendFunctionGun proceed SuspendFunctionGun kt 113 at io ktor util pipeline SuspendFunctionGun execute SuspendFunctionGun kt 133 at io ktor util pipeline Pipeline execute Pipeline kt 79 at io ktor routing Routing executeResult Routing kt 155 at io ktor routing Routing interceptor Routing kt 39 at io ktor routing Routing$Feature$install$1 invokeSuspend Routing kt 107 at io ktor routing Routing$Feature$install$1 invoke Routing kt at io ktor util pipeline SuspendFunctionGun loop SuspendFunctionGun kt 243 at io ktor util pipeline SuspendFunctionGun proceed SuspendFunctionGun kt 113 at io ktor features ContentNegotiation$Feature$install$1 invokeSuspend ContentNegotiation kt 110 at io ktor features ContentNegotiation$Feature$install$1 invoke ContentNegotiation kt at io ktor util pipeline SuspendFunctionGun loop SuspendFunctionGun kt 243 at io ktor util pipeline SuspendFunctionGun proceed SuspendFunctionGun kt 113 at io ktor util pipeline SuspendFunctionGun execute SuspendFunctionGun kt 133 at io ktor util pipeline Pipeline execute Pipeline kt 79 at io ktor server engine DefaultEnginePipelineKt$defaultEnginePipeline$2 invokeSuspend DefaultEnginePipeline kt 124 at io ktor server engine DefaultEnginePipelineKt$defaultEnginePipeline$2 invoke DefaultEnginePipeline kt at io ktor util pipeline SuspendFunctionGun loop SuspendFunctionGun kt 243 at io ktor util pipeline SuspendFunctionGun proceed SuspendFunctionGun kt 113 at io ktor util pipeline SuspendFunctionGun execute SuspendFunctionGun kt 133 at io ktor util pipeline Pipeline execute Pipeline kt 79 at io ktor server netty NettyApplicationCallHandler$handleRequest$1 invokeSuspend NettyApplicationCallHandler kt 122 at io ktor server netty NettyApplicationCallHandler$handleRequest$1 invoke NettyApplicationCallHandler kt at kotlinx coroutines intrinsics UndispatchedKt startCoroutineUndispatched Undispatched kt 55 at kotlinx coroutines BuildersKt Builders commonKt startCoroutineImpl Builders common kt 194 at kotlinx coroutines BuildersKt startCoroutineImpl Unknown Source at kotlinx coroutines AbstractCoroutine start AbstractCoroutine kt 145 at kotlinx coroutines BuildersKt Builders commonKt launch Builders common kt 56 at kotlinx coroutines BuildersKt launch Unknown Source at io ktor server netty NettyApplicationCallHandler handleRequest NettyApplicationCallHandler kt 43 at io ktor server netty NettyApplicationCallHandler channelRead NettyApplicationCallHandler kt 34 at io netty channel AbstractChannelHandlerContext invokeChannelRead AbstractChannelHandlerContext java 379 at io netty channel AbstractChannelHandlerContext access$600 AbstractChannelHandlerContext java 61 at io netty channel AbstractChannelHandlerContext$7 run AbstractChannelHandlerContext java 370 at io netty util concurrent AbstractEventExecutor safeExecute AbstractEventExecutor java 164 at io netty util concurrent SingleThreadEventExecutor runAllTasks SingleThreadEventExecutor java 472 at io netty channel nio NioEventLoop run NioEventLoop java 500 at io netty util concurrent SingleThreadEventExecutor$4 run SingleThreadEventExecutor java 989 at io netty util internal ThreadExecutorMap$2 run ThreadExecutorMap java 74 at io ktor server netty EventLoopGroupProxy$Companion$create$factory$1$1 run NettyApplicationEngine kt 227 at io netty util concurrent FastThreadLocalRunnable run FastThreadLocalRunnable java 30 at java base java lang Thread run Thread java 834 ```