Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Spring boot with JDBC  RSS feed

 
vin Hari
Ranch Hand
Posts: 187
  • 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:
 
Sergej Smoljanov
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: 187
  • 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.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!