All Questions
178 questions
0
votes
0
answers
58
views
Problem with stored procedure that not save my rows
I do a stored procedue in my db, I have more of 1 row if I run stored procedure in mysql workbench, but if I try to debug my programm result set is empty
I tried debug, but rs is empty. This is my ...
0
votes
1
answer
90
views
how to filter records by week mysql
I need to filter records by level and by week, that is, if I have 100 records, I only have to show the records of the last 7 days, for example, 30 records for the UTILS level.
select tbe.level, COUNT(...
- 27
0
votes
0
answers
569
views
calling mysql stored procedure (without parameter and return) from java spring boot webserver
i've created a mysql stored procedure with SP name: spAssignPairNo
my stored procedure doesn't take any parameters and doesn't return any result.
the SP will make data update to Picking_Item table ...
0
votes
0
answers
182
views
How to call (MySQL) Database Stored Procedure using JPA (Entity Manager): When Procedure already stored in database
Use Case:
I have the procedure stored in the database:
CREATE DEFINER=`DEVDBA`@`%` PROCEDURE `TestReporting`()
begin
truncate table `report_controller_total_request`;
insert into `...
- 135
0
votes
0
answers
68
views
Issue Running MySQL Stored Procedure from Java
I have a bizarre issue where I can execute a stored procedure from the command line, and directly on the mysql instance, however, when I run the stored procedure from Java, I am getting an error:
...
1
vote
1
answer
2k
views
fixing Mysql Delimiter syntax error in testcontainers init script
I want to test a stored procedure with testcontainers. So I am initializing my container with an SQL script containing the definition of the stored procedure but I am getting this syntax error
java....
- 337
0
votes
0
answers
295
views
Hibernate and stored procedure relation and how to solve create temporary table problem which throws table exists exception
I have hibernate session and database session which temporary table relays on database session. But I really wonder that if database connection pool does not close the database connection after ...
- 1,583
0
votes
1
answer
332
views
How to Solve parameter error in Strored Procedure call in Spring Boot?
I have a stored Procedure in my DB like this:
DELIMITER //
CREATE PROCEDURE Getit()
BEGIN
SELECT title
FROM course
WHERE description="just a course";
END //
Now In the spring boot App I ...
- 302
0
votes
0
answers
74
views
Progress of a stored procedure with JPA and MySQL?
I have a long running stored procedure in MySQL which I call using JPA.
I want to periodically inform the user about the progress of the procedure.
How can I achieve that?
Here is what I've tried.
I'...
- 917
0
votes
1
answer
90
views
MySQL stored procedure not returning result set
I have a MySQL stored procedure that does a select on a table, then wrap the result using concatenated string (HTML code). I get data back when ran through Workbench, but the Java result set seems ...
- 619
0
votes
1
answer
339
views
Row Mapper/Converter to convert list of object array to a json in spring boot
I have a mysql stored procedure which joins multiple tables and returns a table. I am invoking the stored procedure from my Spring data repository -
@Query(value = "CALL get_emp_details(:id);&...
0
votes
1
answer
835
views
Column in field list is ambiguous
Table Reservation:
I want to give the guest the amount he has to pay and I have a procedure
CREATE DEFINER=`root`@`localhost` PROCEDURE `CalculateTotal`(IN ID int ,OUT total float)
BEGIN
SELECT (...
- 1
1
vote
1
answer
732
views
How to retrieve output param from Stored Procedure with Hibernate
I am trying to execute a Stored Procedure which updates a column and retrieves the filename from the same table after updating
StoredProcedure:
CREATE DEFINER=`test`@`%` PROCEDURE `update_count`(
...
- 21
0
votes
1
answer
412
views
Sanitize input before passing it as a variable to stored procedure from java
I have a java code that calls a stored procedure and return a search result to the web browser, the problem i am facing is that the procedure accepts parameter from the browser, now even if I use a ...
- 580
0
votes
0
answers
31
views
JDBC creating procedure throws MySQLSyntaxErrorException [duplicate]
I am trying to run an SQL script in a java application using JDBC and HikariConfig.
CREATE TABLE table_AA(NAME VARCHAR(50) NOT NULL);
CREATE PROCEDURE `ASDF`()
BEGIN
SELECT * FROM table_AA;
end;
...
- 91