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/7789f6c7-e03b-4b35-9c74-f934a846ce03n%40googlegroups.com.

Reply via email to