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.
