Stored procedures

[Jan Jindráček]

Hello, sorry to annoy you again, but is there any way to run stored procedures? I really need to use Levenshtein.

Thank you for your answer.

[Jinq]

Sorry. I never got around to implementing support for stored procedures in Jinq in the end. You'll have to drop down to regular Hibernate/JPA to use stored procedures in a query.

[Jan Jindráček]

Dne neděle 4. listopadu 2018 19:11:24 UTC+1 Jinq napsal(a):

Sorry. I never got around to implementing support for stored procedures in Jinq in the end. You'll have to drop down to regular Hibernate/JPA to use stored procedures in a query.

Can I use JPA query inside the .where() or .select() query? Or is it completely impossible? If I use JPA repository..

[Jinq]

No, Jinq doesn't support that.

If you can wait, I have to make some changes to Jinq in the next week or two in order to add support for asm 7. I can take a quick look to see if it'll be possible to hack in some rudimentary support for stored procedures at that time. But there's no guarantees there that'll I'll be able to figure it out.

[Jan Jindráček]

Dne neděle 4. listopadu 2018 19:20:03 UTC+1 Jinq napsal(a):

No, Jinq doesn't support that.

If you can wait, I have to make some changes to Jinq in the next week or two in order to add support for asm 7. I can take a quick look to see if it'll be possible to hack in some rudimentary support for stored procedures at that time. But there's no guarantees there that'll I'll be able to figure it out.

Thank you so much! That would be absolutely perfect, I will be looking forward to the next update.

[Jinq]

I've made a new 1.8.25 release of Jinq with experimental support for calling user-defined SQL functions. I made some rough documentation about how to use it in the JPA Query Guide in the section titled "Custom SQL Functions."