issue with calculation using stored procedure in 5.1 beta

Classic Servoy
1

Hi,

after the update from 5.0 to 5.1 beta, I get problems with calculations using stored procedure.

the following code :

var args = new Array();
	args[0] = java.sql.Types.NUMERIC;
	args[1] = offekrt_id
	var typesArray = new Array();
	typesArray[0] = 1;
	typesArray[1] = 0;
	var proc_declaration = '{?=call get_offerte_vkbedr_tot(?)}';
	var dmesp = plugins.rawSQL.executeStoredProcedure('berp2', proc_declaration, args, typesArray, 1);
	return dmesp.getValue(1, 1);

Gives the following error : ( it works fine in 3.5, 4.x, 5.0 )

Exception executing calculation: calc_verkoopprijs_totaal of table offertekaarten, error: java.lang.ClassCastException: com.servoy.j2db.scripting.Zjb cannot be cast to com.servoy.j2db.dataprocessing.JSDataSet

java.lang.ClassCastException: com.servoy.j2db.scripting.Zjb cannot be cast to com.servoy.j2db.dataprocessing.JSDataSet

Regards,

2

dispite the error, using rawSQL in calculations can be real heavy, right?

3

Agree, but is this case it works fine.

If i use javascript it would cause many queries/roundrtrips to the database, in this case only one.

Performance is excellent.

Regards

4

B.t.w. I am moving this one to the Release 5.1 beta item.