Spring Boot Connect to Microsoft SQL Server Example

Learn to write code that connects to Microsoft SQL database Server in a Spring Boot application with JdbcTemplate and Spring Data JPA with Hibernate framework.

How to declare Maven dependency for SQL Server JDBC driver. How to specify datasource properties.

Software programs:
- Java Development Kit (JDK)
- Spring Tool Suite IDE (STS)
- SQL Server Express & SQL Management Studio

[kaarlharster]

Thank you! Very well done. Easy to follow. Very Helpful!

[tuanbruh]

tuyệt vời luôn đúng cái e cần, bắn tiếng anh đúng đỉnh :v

[svalyavasvalyava]

this video is just awesome, thank you infinitely! 😊

[kinucc]

Login failed for user ''. i see this provlem, what must i do?

[bigbeast]

Sorry, couldn't quite understand what the "sqlsrv" in the spring.datasource.url is for?

[jecoy]

Hi can you create an example using it in another class? It seems like it can only be used in Controller class. When using it other than the controller class it does not get initialized.

[skipa]

Thank you for the tutorial. How can I do the connection to Hadoop?

[SoporteDonga]

HI, I have a error "Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled." Can you Helpme?, please, thnks

[deepeshgupta]

When I am doing CRUD operation with SQL server.
Updating the record is not working, while using same save() which is provided by JPARepository.
While updating the record it creates new record in DB.
Making GenerationType "IDENTITY", also in DB making primary column as a "Is Identity" YES.
Can u please help me on this. thank you!!

[solomonlapiana]

what if we are using "windows authentication" instead of "sql server authentication" for our sql server? what do we put in the application.properties file then?

[senay.]

Why doesn't it show up in list form?

[quangnguyenxuan]

I have a error "Could not autowire. No beans of 'JdbcTemplate' type found." How i can't fix it :(

[salman_shaik]

I faced "Query not specified for name findByNameAndCity" JPA API access exception while running a custom native query with mssql

[gnanasaikalupudi]

Could you please create an example using windows authentication

[brandonalexis]

I followed the video step by step but when executing at the end I got this error

login failed for user 'user1'. clientconnectionid:


The user is created and defined in the properties along with the password, what can I do to solve it

[shreysshikhare]

How to call SQL scaler function from springboot application

[jahs]

hello, if you wanted to use the two databases: customer and students. How would the spring.datasource.url connection look like? please!!!

[pranitawadavkar]

Can you please provide git repository of this code..

[adibasiddiqui]

Please give use an example on how to connect Windows Authentication SQL Server with Springboot
Or please give me your number I want help Plz

[mattsalis]

hello, im doing the jpa part step by step, but as I execute the program it deletes all the content from the table, and it outputs nothing, I would apreciate any help