Win a copy of TensorFlow 2.0 in Action this week in the Artificial Intelligence and Machine Learning forum!
  • 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Paul Clapham
  • Bear Bibeault
  • Jeanne Boyarsky
Sheriffs:
  • Ron McLeod
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Jj Roberts
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • salvin francis
  • Scott Selikoff
  • fred rosenberger

How to fix Spring error: Unable to start web server

 
Ranch Hand
Posts: 653
  • Mark post as helpful
  • send pies
  • 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.
 
Ranch Hand
Posts: 147
1
  • Likes 2
  • Mark post as helpful
  • send pies
  • 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
```
 
Bartender
Posts: 1956
13
  • Mark post as helpful
  • send pies
  • 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:
 
The only cure for that is hours of television radiation. And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic