Can you reproduce this in a small stand-alone Java program? If so, it does seem like a bug and you should report as an issue here: https://github.com/h2database/h2database/issues
Make sure to post the repro code. On Monday, 20 February 2017 09:20:38 UTC+1, Ashok Rai wrote: > > Hi Kerry, > Thanks for your reply. I could replicate this issue using SQL Workbench/J. > > On Saturday, February 18, 2017 at 9:15:56 PM UTC+5:30, Ashok Rai wrote: >> >> I am getting below error : >> >> java.util.concurrent.ExecutionException: java.lang.RuntimeException: >> org.h2.jdbc.JdbcSQLException: Schema "XXXX" not found; SQL statement: >> GRANT SELECT ON SCHEMA XXXX TO USERX[90079-192] >> >> Steps to reproduce: >> 1) Connect to H2 db using Squirrel-sql client . >> Connection url used: >> jdbc:h2:file:MyDBFileLocation;CIPHER=AES;IFEXISTS=TRUE;AUTO_SERVER=FALSE >> 2) Run below command >> alter schema XXXX rename to YYYY; >> 3) Close all the connections >> 4) Try connecting to H2 DB . I am unable to connect getting below error: >> >> java.util.concurrent.ExecutionException: java.lang.RuntimeException: >> org.h2.jdbc.JdbcSQLException: Schema "XXXX" not found; SQL statement: >> GRANT SELECT ON SCHEMA XXXX TO USERX[90079-192] >> >> Please help. >> > -- 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 post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
