Skip to content

libsql/turso with spring jpa ending up with : "Failed to execute isValid() for connection, configure connection test query (null)" #20

@arpanrec

Description

@arpanrec

I am trying to setup libsql as drop in replacement for sqlite. Has anyone faced this with spring boot

I am having jpa database-platform: org.hibernate.community.dialect.SQLiteDialect

diff --git a/build.gradle.kts b/build.gradle.kts
index 0e8f176..ebe647d 100644
--- a/build.gradle.kts
+++ b/build.gradle.kts
@@ -88,7 +88,7 @@ dependencies {
         exclude(group = "org.springframework.boot", module = "spring-boot-starter-logging")
     }
 //    implementation("org.springframework.boot:spring-boot-starter-data-r2dbc")
-    implementation("org.xerial:sqlite-jdbc")
+    implementation("com.dbeaver.jdbc:com.dbeaver.jdbc.driver.libsql:1.0.2")

 
     implementation("org.springframework.boot:spring-boot-starter-web") {
diff --git a/src/main/resources/application.yml b/src/main/resources/application.yml
index e1bb2b6..dc51793 100644
--- a/src/main/resources/application.yml
+++ b/src/main/resources/application.yml
@@ -9,10 +9,11 @@ spring:
     main:
         lazy-initialization: true
     datasource:
-        driver-class-name: org.sqlite.JDBC
-        username: sa
-        password: sa
-        url: jdbc:sqlite:db.sqlite3
+        driver-class-name: com.dbeaver.jdbc.driver.libsql.LibSqlDriver
+        password: x.x.x-x # Trust me valid token
+        url: jdbc:dbeaver:libsql:https://x.turso.io # Trust me valid url
+        hikari:
+            isolate-internal-queries: false # Tried with true as well
     jpa:
         database-platform: org.hibernate.community.dialect.SQLiteDialect
         generate-ddl: true

Failed to execute isValid() for connection, configure connection test query (null)
SQL Error: 0, SQLState: null
null
HHH000342: Could not obtain connection to query metadata
unable to obtain isolated JDBC connection [null]
Caused by: java.sql.SQLFeatureNotSupportedException

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions