• 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
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Spring boot with JDBC

 
Ranch Hand
Posts: 189
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
reply
    Bookmark Topic Watch Topic
  • New Topic