-
Notifications
You must be signed in to change notification settings - Fork 15
Open
Milestone
Description
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
sharmasourabh
Metadata
Metadata
Assignees
Labels
No labels