Execute Stored with insert

[gabrie1a2001]

Hi, good morning:

I need your help in the following, I’m using Jasper Soft Studio 6.2.0 and PLSQL and I execute the following store procedure:

{call SISINFO.dbo.SP_EJECUTA_BASE_PORTABILIDAD ($P{FechaInicio}, $P{FechaFin})}

Inside this store procedure I also execute the following instructions:

ALTER PROCEDURE [dbo].[sP_EJECUTA_BASE_PORTABILIDAD]

@FechaInicio AS DATE,@FechaFin AS DATE

AS

BEGIN

    SET NOCOUNT ON;

 insert into VAGUIAR..TABLA_SOL_JOBS (REPORTE)  values ('PRUEBA')

 select MAX(JOB_ID) AS JOB FROM VAGUIAR..TABLA_SOL_JOBS

END

GO

When I do this in my PC all runs perfectly, but when I publish it on the Jasper Server, even though it doesn’t sent me any errors, the server sends me the max JOB_ID(example: 54), but when I access the table It just have until JOB_ID: 53

If I run it again in my PC, now it gives me back a JOB_ID: 55, and If I access the table it shows the records 53 and 55, I mean the JOB_ID that the server showed didn’t got inserted but it got processed. I don’t know why this is happening.

May someone help me please. Thank you very much for your help.

[H Mendoza]

If I understand this correctly, this configuration is not supported out of the box. 

[gabrie1a2001]

What do you mean by out of the box?

[H Mendoza]

Out of the box, Jasper disables SQL prompts -- such as Drop.  I am not sure you can insert without making changes to the platform. 

[gabrie1a2001]

<pre data-fulltext="" data-placeholder="Traducción" dir="ltr" id="tw-target-text">We configured:</pre>

 

https://community.jaspersoft.com/wiki/how-execute-ms-sql-stored-procedure-jasperreports-server

 

and we put : COMMIT TRANSACTION;  At the end of STORED