Programmiererforum

unexpected end of stream, read 0 bytes from 4 (socket was closed by server)

CREATE PROCEDURE `get_loan_balances_sample`()

BEGIN

drop table if exists all_loan_ids;
drop table if exists random_loan_ids;

create table all_loan_ids as select distinct loan_id from loan_balances2;
create table random_loan_ids as select * from all_loan_ids order by RAND() limit 50;

SELECT * FROM loan_balances2
where loan_id in (select Loan_ID from random_loan_ids)
order by Loan_ID, balance_date;

END

Wir haben eine gespeicherte Prozedur in Mariadb, die auf dem Server gut ausgeführt wird. Wenn wir sie jedoch von einem Client mit JDBC ausführen[code]unexpected end of stream, read 0 bytes from 4 (socket was closed by server)
[/code]
Die Tabelle liehen_balances2 ist nicht zu groß, rund 600.000 Zeilen.  Dies ist das gespeicherte Verfahren. Sehen Sie Probleme? Danke! < /p>
[code]CREATE PROCEDURE `get_loan_balances_sample`()

BEGIN

drop table if exists all_loan_ids;
drop table if exists random_loan_ids;

create table all_loan_ids as select distinct loan_id from loan_balances2;
create table random_loan_ids as select * from all_loan_ids order by RAND() limit 50;

SELECT * FROM loan_balances2
where loan_id in (select Loan_ID from random_loan_ids)
order by Loan_ID, balance_date;

END
[/code]