Hi, Were you able to identify the root cause and solve the issue as I am also facing the same issue.
On Wednesday, 8 September 2021 at 14:24:57 UTC+5:30 [email protected] wrote: > Hi all, I have use SpringBoot, Mybatis and H2 for my app. > when the app first started, it is normal, it can use select sql search > data. > but after a short time, I run the same sql, it had throw a exception that > org.h2.jdbc.JdbcSQLException: Table “xxxxxx” not found; SQL statement. > > this is my sql: > *select * from table_name where **** > > Here is configuration and h2 url > > spring: > h2: > console: > enabled: true > path: /h2 > jpa: > database-platform: org.hibernate.dialect.H2Dialect > datasource: > driver-class-name: org.h2.Driver > username: sa > password: > > url:jdbc:h2:file:${user.dir}/dbh2/test;mode=mysql;DB_CLOSE_DELAY=-1;DATABASE_TO_LOWER=TRUE;AUTO_RECONNECT=TRUE > # init.sql, some cretae table sql > schema: classpath:sql/init.sql > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/63778b53-dd01-43cd-886e-f3a54fc5bb43n%40googlegroups.com.
