Subject | Re: SpringDataJPA @Procedure on Firebird 1.5 vs Firebird 3.0 |
---|---|
Author | |
Post date | 2019-02-16T08:35:34Z |
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
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