• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Liutauras Vilda
  • Paul Clapham
Sheriffs:
  • paul wheaton
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Piet Souris
Bartenders:
  • Mike London

How to fix Spring error: Unable to start web server

 
tangara goh
Ranch Hand
Posts: 947
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have been trying to fix these errors for the past few days mentioned by Spring without avail.

Please let me know what exactly is causing the errors :

My application.properties :



and the error :



Tks.
 
Salil Wadnerkar
Ranch Hand
Posts: 174
1
  • Likes 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The answer is right before your eyes in the exception stack trace:
```
Failed to execute SQL script statement at line 10 of resource URL [file:/C:/Users//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
```
 
Himai Minh
Bartender
Posts: 2266
13
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi, Tangara,
What database do you use?
Maybe try to use a simple embedded h2 database for test purpose.
So, your application.properties should have these:
 
reply
    Bookmark Topic Watch Topic
  • New Topic