Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to call a Database function using spring data jpa?

I want to call a database function from spring boot application which will return a decrypted value.

Is it possible to call database functions using spring data jpa? If possible how?

If not possible using spring data jpa, Is there any alternatives to call functions from spring boot?

Here is my function

IF OBJECT_ID('fn_MASK_CARD') IS NOT NULL
    DROP FUNCTION fn_MASK_CARD
GO

CREATE FUNCTION fn_MASK_CARD (
    @CARD_NUMBER  VARCHAR(19)
    )
   RETURNS VARCHAR(19)
AS
BEGIN
    RETURN SUBSTRING(@CARD_NUMBER,1,6)+REPLICATE('#',LEN(@CARD_NUMBER)-10)+
                                                        SUBSTRING(@CARD_NUMBER,LEN(@CARD_NUMBER)-3,LEN(@CARD_NUMBER));
END
GO
like image 483
Indrajith K V Avatar asked Jul 16 '26 04:07

Indrajith K V


1 Answers

Finally found the answer, just added the below code in my repository and it worked!

@Query(nativeQuery = true, value = "SELECT DBO.fn_MASK_CARD(:text)")
String callMaskCard(@Param("text") String text);
like image 161
Indrajith K V Avatar answered Jul 17 '26 17:07

Indrajith K V



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!