Subject Re: SpringDataJPA @Procedure on Firebird 1.5 vs Firebird 3.0
Author
Which Jaybird version are you using (full version please), and are you using the same Jaybird version for both Firebird 1.5 and 3.0?

What is the definition of the stored procedure? At minimum I need to know the declaration (CREATE PROCEDURE up to AS) and if the body contains SUSPEND or not.

Did you recreate the procedure in Firebird 3.0, or did you only backup and restore?

What is the output - both on Firebird 1.5 and 3.0 - for

select
RDB$PROCEDURE_NAME,
RDB$PROCEDURE_INPUTS,
RDB$PROCEDURE_OUTPUTS,
RDB$SYSTEM_FLAG,
RDB$PROCEDURE_TYPE
from RDB$PROCEDURES
where RDB$PROCEDURE_NAME = '<your procedure>'

(on Firebird 1.5, remove the RDB$PROCEDURE_TYPE column)

and the output for

select
RDB$PARAMETER_NAME,
RDB$PROCEDURE_NAME,
RDB$PARAMETER_NUMBER,
RDB$PARAMETER_TYPE
from RDB$PROCEDURE_PARAMETERS
where RDB$PROCEDURE_NAME = '<your procedure>'

It would also be helpful if you can provide the result set data (again for both Firebird 1.5 and Firebird 3.0) of

- DatabaseMetaData.getProcedures(null, null, "<your procedure>")
- DatabaseMetaData.getProcedureColumns(null, null, "<your procedure>", "%")

Mark