Spring stored procedure | Java Techie

thank sir, can u add English sub for your video? it's very helpful

Sir how to save our entity variables in preserve order because in my entity i used Id,name, salary, address but db storing id, address, salary,name but i need id,name, salary, address how sir

How i can create Stored Functions in Spring Boot?

well Explained

Good afternoon sir, how can we call stored procedure in jsp using spring boot?

can i do the same with oracle procedure pl/sql

java.sql.SQLSyntaxErrorException: PROCEDURE ticket.firstProcedure does not exist - I am getting this. Can you explain why

How to create procedure in h2 database

Hello sir,

Can you please help me to pass Java collection to Oracle Stored procedure

List<Long> to Oracle Stored procedure as IN parameter

When one single store procedure have multiple query how to retrieve that data?

How to convert the response to json ?

i am getting entity manager as null can anyone help ?

thanks a lot!

Thanks ..looking for it.

In the dao class, function to insert,update and delete and in controller
in this example u tought us only select using list<> function
Thanks

Thank u for nice tutorial but how to do insert,update and delete ??

amazing...very nicely explained...this is what i was looking for thank you

How TO Retrieve Data in JSON Format with paramere name?

thank u so much...u saved my life:):)

Hi, Thanks for this detailed video.
I have created the standalone service as thought in your video as per my requirements, it worked perfectly fine.

When I integrated with other project, the same service, this is throwing error as
no @NamedStoredProcedureQuery was found with that name= <the name specified for category named stroed proc>

Please note there is no in and out parameter in my case.

Thank you in advance!

Hi sir , i want to insert data into oracle database in 7 different table with 7 diff store procedure so how ca do this using jpa .in one hit. please suggest the solution.......thanks in advanced

Hello. I have copied and pasted the code as it is from gitub. I have created table and two procedures as you created. But I am not able to fetch any data in the postman using get. I am getting status 500 . and in the console i got nullpointerexception. What could be the reason?

Can you try to pass this query to ThymeLeaf and check? It would not work because you get List<Object[]> and you are converting them to List<Ticket> type.

Thans a lot. This worked for me.

Work on your spellings

For some reason i tried this and had an error with the parameters i had a error: parameter has been not registered.
So i tried solething like this in the dao classand it worked ! for anyone who needs it !. thanks 4 the video.
StoredProcedureQuery query = em.createStoredProcedureQuery("calculate");
query.registerStoredProcedureParameter("x", Double.class, ParameterMode.IN);

simple and easy thanks mate.

In the response its giving array ....but my need id i want key value pair array ...and u are getting simple array how can i distinguished with json key value

tks bro. I have some question. Now a my result is Array of Array. i want to convert it to Entity. Help me please

Hi sir, I am getting this error : java.lang.IllegalArgumentException: Named parameter [tcategory] is not registered with this procedure call. I wrote the same procedure call like you and same steps. What am I missing

Bhai.. Tame poora jhakkaas explanation daucha

Good explanation.. Liked it.

Thank you, you know who I can create a Pagination with stored procedure?

This is showing a simple example where I am linking one entity to a stored procedure that selects data from a table containing records of data for that entity. In reality we are going to use complex stored procedures joining multiple tables. how do I call a stored procedure that is joining multiple tables and is performing complex operations? Do I just link all the entities that are used in that stored procedure or what? Just need some clarification on that. Every where else I look I am seeing simple examples like what you just showed.

how to display the output in html table ?? please show

What is lamboc bro

Thank you very much for uploading and your time

Thank you sir it is very helpful for everyone...superb

nice bro.

super