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 wjj145...@gmail.com 
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 h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/63778b53-dd01-43cd-886e-f3a54fc5bb43n%40googlegroups.com.

Reply via email to