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.
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
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!!
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?
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
i did everything follow the video. but i'm facing the problem "@org.springframework.beans.factory.annotation.Autowired(required=true)" and i dont know why. could you give me a hint or any clue
@@CodeJava i fixed it. But my problem is The project is broken down to piecies. So i have to declare where is Component and Repository. Thank for your help
@@CodeJava I did the example you have and if I can target both. I leave the data: spring.datasource.url=jdbc:sqlserver://sqlsrv\\sqlexpress:1433;databaseName=customer;databaseName =students
I followed the video step by step but when executing at the end I got this error login failed for user 'user1'. clientconnectionid: b079867b-c338-45d5-a3a8-4dda7ab8516b The user is created and defined in the properties along with the password, what can I do to solve it
Thank you! Very well done. Easy to follow. Very Helpful!
Glad it was helpful!
tuyệt vời luôn đúng cái e cần, bắn tiếng anh đúng đỉnh :v
cảm ơn em :)
Sorry, couldn't quite understand what the "sqlsrv" in the spring.datasource.url is for?
that's the hostname of my computer. It can be localhost if you use local SQL server.
Thank you for the tutorial. How can I do the connection to Hadoop?
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.
Login failed for user ''. ClientConnectionId:f85cc665-9f31-4438-8a1c-3fed3f42dac7 i see this provlem, what must i do?
Thank you! Very well done.
Glad it was helpful!
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
kindly provide full exception details so I can figure out what went wrong.
this video is just awesome, thank you infinitely! 😊
Glad it helped!
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!!
kindly tell the error in details.
This is what I'm waiting for 🌟
I have a error "Could not autowire. No beans of 'JdbcTemplate' type found." How i can't fix it :(
make sure you have spring-boot-starter-jdbc dependency in the pom.xml file
where did you add the sql auth dll?
Could you please create an example using windows authentication
Yes, I will.
@@CodeJava did you do it?
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?
Windows authentication uses the current user account so you don't have to specify username and password.
Hi, my output is like this for each student: com.example.demo.Student@6137cf6e
Why doesn't it show up in list form?
you need to override toString() method in Student class, to print details of the student.
@@CodeJava Thank you
Eres un héroe !!! Thanks
Simply put, great guide
Glad it helped!
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
hmm, it seems not relate to this video, right?
@@CodeJava hmm I'm literally doing what the video says, how its not related?
@@mattsalis1935 sorry, I was thinking about another video. you mean select query deletes the table?
That mean it was successful done lol
i did everything follow the video. but i'm facing the problem "@org.springframework.beans.factory.annotation.Autowired(required=true)" and i dont know why. could you give me a hint or any clue
for @Autowired to work, you must annotate the autowired class using @Component, @Service, @Repository....
@@CodeJava i fixed it. But my problem is The project is broken down to piecies. So i have to declare where is Component and Repository. Thank for your help
hello, if you wanted to use the two databases: customer and students. How would the spring.datasource.url connection look like? please!!!
the datasource url can point to only one databasel
@@CodeJava I did the example you have and if I can target both. I leave the data:
spring.datasource.url=jdbc:sqlserver://sqlsrv\\sqlexpress:1433;databaseName=customer;databaseName =students
connect to any of the 2 databases and access the other through the query, example: select * from databaseName.dbo.TableName
@@gransam lol... you're right
how did u get the customer.class?
It was written at 9:00 in this video.
I followed the video step by step but when executing at the end I got this error
login failed for user 'user1'. clientconnectionid: b079867b-c338-45d5-a3a8-4dda7ab8516b
The user is created and defined in the properties along with the password, what can I do to solve it
I think either username or password is incorrect.
I faced "Query not specified for name findByNameAndCity" JPA API access exception while running a custom native query with mssql
@Query(value="select * from Users where name= ?1 and city= ?2",nativeQuery=true)
List findByNameAndCity(String name,String city);
Hmm, I have no idea why.
cảm ơn a nhìu :)))
welcome :)
How to call SQL scaler function from springboot application
consider using native query. Follow this video: ua-cam.com/video/yXwHu6g-wlY/v-deo.html
nice job thanks!
Glad you liked it!
Can you please provide git repository of this code..
you can find code in this article: www.codejava.net/frameworks/spring-boot/connect-to-microsoft-sql-server-examples
thank you
You're welcome
OK
am feeling sleepy
Sorry to hear that. I hope you can still follow it.
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