• 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
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

Spring boot with JDBC

 
Ranch Hand
Posts: 189
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Ranchers,

i am learning Spring boot i am trying to connect with the the JDBC but not able to do, can some one please i followed this link https://www.javatpoint.com/spring-boot-jdbc

i did each and every step mentioned there but getting:


Whitelabel Error Page

This application has no explicit mapping for /error, so you are seeing this as a fallback.

Fri May 19 23:25:53 IST 2017
There was an unexpected error (type=Internal Server Error, status=500).
Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Incorrect database name 'springbootdb '



my application.properties file  looks



and java files are :



and controller looks like:



the URL used is : http://localhost:8080/insert
but it is giving the error as above:

and the pom.xml looks:
 
Ranch Hand
Posts: 472
10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Incorrect database name 'springbootdb '
Have you create schema? have you  'springbootdb '  created?
 
vin Hari
Ranch Hand
Posts: 189
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you Sergej  for your reply, i solved that issue by granting all privileges to the user in mysql that solved the problem, thanks again for your reply.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!