# What does the error mean?

**URL:** https://discourse.hibernate.org/t/what-does-the-error-mean/4649
**Category:** Hibernate ORM
**Created:** [October 5, 2020, 4:59am UTC](https://discourse.hibernate.org/t/what-does-the-error-mean/4649 "2020-10-05T04:59:17Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![karengsh](https://avatars.discourse-cdn.com/v4/letter/k/bb73d2/32.png) [@karengsh](https://discourse.hibernate.org/u/karengsh)
#### Post date: [October 5, 2020, 4:59am UTC](https://discourse.hibernate.org/t/what-does-the-error-mean/4649/1 "2020-10-05T04:59:17Z")

</div>

Hi,  
I am new to SpringBoot and also not beginner level in Hibernate.  
Could someone explain to me what does the error below mean?  
Basically, I get this SpringPet sample from Spring site and then I added new entities including user in the h2 sql data and schema file residing inside the app.  
But, I really don’t know what is wrong…

> Blockquote[ERROR] shouldInsertPetIntoDatabaseAndGenerateId Time elapsed: 0 s \<\<\< ERROR!  
> java.lang.IllegalStateException: Failed to load ApplicationContext  
> Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException:  
> Error creating bean with name ‘org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaConfiguration’: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘dataSource’: Post-processing of FactoryBean’s singleton object failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘org.springframework.boot.autoconfigure.jdbc.DataSourceInitializerInvoker’: Invocation of init method failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #11 of URL [file:/C:/Users/Karen/petstore/target/classes/db/h2/schema.sql]: CREATE TABLE users ( id INTEGER IDENTITY PRIMARY KEY, username VARCHAR(30) firstname VARCHAR(30) lastname VARCHAR(30) email VARCHAR(30) password VARCHAR(30) phone VARCHAR(20) userStatus INTEGER(2) ); nested exception is org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement “CREATE TABLE USERS ( ID INTEGER IDENTITY PRIMARY KEY, USERNAME VARCHAR(30) FIRSTNAME[_] VARCHAR(30) LASTNAME VARCHAR(30) EMAIL VARCHAR(30) PASSWORD VARCHAR(30) PHONE VARCHAR(20) USERSTATUS INTEGER(2) )"; expected “FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, ON, NOT, NULL, AUTO\_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL\_TO\_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, COMMENT, CHECK, REFERENCES, , )”; SQL statement:  
> CREATE TABLE users ( id INTEGER IDENTITY PRIMARY KEY, username VARCHAR(30) firstname VARCHAR(30) lastname VARCHAR(30) email VARCHAR(30) password VARCHAR(30) phone VARCHAR(20) userStatus INTEGER(2) ) [42001-200]  
> Caused by: org.springframework.beans.factory.BeanCreationException:  
> Error creating bean with name ‘dataSource’: Post-processing of FactoryBean’s singleton object failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘org.springframework.boot.autoconfigure.jdbc.DataSourceInitializerInvoker’: Invocation of init method failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #11 of URL [file:/C:/Users/Karen/petstore/target/classes/db/h2/schema.sql]: CREATE TABLE users ( id INTEGER IDENTITY PRIMARY KEY, username VARCHAR(30) firstname VARCHAR(30) lastname VARCHAR(30) email VARCHAR(30) password VARCHAR(30) phone VARCHAR(20) userStatus INTEGER(2) ); nested exception is org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "CREATE TABLE USERS ( ID INTEGER IDENTITY PRIMARY KEY, USERNAME VARCHAR(30) FIRSTNAME[_] VARCHAR(30) LASTNAME VARCHAR(30) EMAIL VARCHAR(30) PASSWORD VARCHAR(30) PHONE VARCHAR(20) USERSTATUS INTEGER(2) )”; expected “FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, ON, NOT, NULL, AUTO\_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL\_TO\_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, COMMENT, CHECK, REFERENCES, , )”; SQL statement:  
> CREATE TABLE users ( id INTEGER IDENTITY PRIMARY KEY, username VARCHAR(30) firstname VARCHAR(30) lastname VARCHAR(30) email VARCHAR(30) password VARCHAR(30) phone VARCHAR(20) userStatus INTEGER(2) ) [42001-200]  
> Caused by: org.springframework.beans.factory.BeanCreationException:  
> Error creating bean with name ‘org.springframework.boot.autoconfigure.jdbc.DataSourceInitializerInvoker’: Invocation of init method failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #11 of URL [file:/C:/Users/Karen/petstore/target/classes/db/h2/schema.sql]: CREATE TABLE users ( id INTEGER IDENTITY PRIMARY KEY, username VARCHAR(30) firstname VARCHAR(30) lastname VARCHAR(30) email VARCHAR(30) password VARCHAR(30) phone VARCHAR(20) userStatus INTEGER(2) ); nested exception is org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement “CREATE TABLE USERS ( ID INTEGER IDENTITY PRIMARY KEY, USERNAME VARCHAR(30) FIRSTNAME[_] VARCHAR(30) LASTNAME VARCHAR(30) EMAIL VARCHAR(30) PASSWORD VARCHAR(30) PHONE VARCHAR(20) USERSTATUS INTEGER(2) )"; expected “FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, ON, NOT, NULL, AUTO\_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL\_TO\_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, COMMENT, CHECK, REFERENCES, , )”; SQL statement:  
> CREATE TABLE users ( id INTEGER IDENTITY PRIMARY KEY, username VARCHAR(30) firstname VARCHAR(30) lastname VARCHAR(30) email VARCHAR(30) password VARCHAR(30) phone VARCHAR(20) userStatus INTEGER(2) ) [42001-200]  
> Caused by: org.springframework.jdbc.datasource.init.ScriptStatementFailedException:  
> Failed to execute SQL script statement #11 of URL [file:/C:/Users/Karen/petstore/target/classes/db/h2/schema.sql]: CREATE TABLE users ( id INTEGER IDENTITY PRIMARY KEY, username VARCHAR(30) firstname VARCHAR(30) lastname VARCHAR(30) email VARCHAR(30) password VARCHAR(30) phone VARCHAR(20) userStatus INTEGER(2) ); nested exception is org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "CREATE TABLE USERS ( ID INTEGER IDENTITY PRIMARY KEY, USERNAME VARCHAR(30) FIRSTNAME[_] VARCHAR(30) LASTNAME VARCHAR(30) EMAIL VARCHAR(30) PASSWORD VARCHAR(30) PHONE VARCHAR(20) USERSTATUS INTEGER(2) )”; expected “FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, ON, NOT, NULL, AUTO\_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL\_TO\_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, COMMENT, CHECK, REFERENCES, , )”; SQL statement:  
> CREATE TABLE users ( id INTEGER IDENTITY PRIMARY KEY, username VARCHAR(30) firstname VARCHAR(30) lastname VARCHAR(30) email VARCHAR(30) password VARCHAR(30) phone VARCHAR(20) userStatus INTEGER(2) ) [42001-200]  
> Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException:  
> Syntax error in SQL statement “CREATE TABLE USERS ( ID INTEGER IDENTITY PRIMARY KEY, USERNAME VARCHAR(30) FIRSTNAME[\*] VARCHAR(30) LASTNAME VARCHAR(30) EMAIL VARCHAR(30) PASSWORD VARCHAR(30) PHONE VARCHAR(20) USERSTATUS INTEGER(2) )”; expected “FOR, UNSIGNED, INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, ON, NOT, NULL, AUTO\_INCREMENT, BIGSERIAL, SERIAL, IDENTITY, NULL\_TO\_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, PRIMARY, UNIQUE, NOT, NULL, COMMENT, CHECK, REFERENCES, , )”; SQL statement:  
> CREATE TABLE users ( id INTEGER IDENTITY PRIMARY KEY, username VARCHAR(30) firstname VARCHAR(3

---

<div class="post-metadata">

### Author: ![rob-valor](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/rob-valor/32/1177_2.png) [@rob-valor](https://discourse.hibernate.org/u/rob-valor)
#### Post date: [October 11, 2020, 8:38am UTC](https://discourse.hibernate.org/t/what-does-the-error-mean/4649/2 "2020-10-11T08:38:37Z")

</div>

This is more a stackoverflow question and related to Spring and SQL. But the issue seems to be:  
\_JdbcSQLSyntaxErrorException SQL statement: `CREATE TABLE users ( id INTEGER IDENTITY PRIMARY KEY, username VARCHAR(30) firstname VARCHAR(30) lastname VARCHAR(30) email VARCHAR(30) password VARCHAR(30) phone VARCHAR(20) userStatus INTEGER(2) )` -\> after each column definition a comma is required.  
Try that sql in [w3schools](https://www.w3schools.com/sql/trysql.asp?filename=trysql_create_table) and you get also an error