I am getting this error while running an integration test with a Liquibase 
bean.

Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "CREATE 
ROLE DBA_USER LOGIN[*] PASSWORD 'dba_user' "; SQL statement:
    CREATE ROLE dba_user LOGIN PASSWORD 'dba_user' [42000-196]


below changeSet is the yaml file. 

   - changeSet:
        id: 2
        author: XXX
        changes:
        - sql:
            splitStatements: true
            sql: CREATE ROLE dba_user LOGIN PASSWORD 'dba_user';
            stripComments: true


I can seem to find any examples of CREATE ROLE yet its in the docs? Does 
this feature really exists?


-- 
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.

Reply via email to