79435619

Date: 2025-02-13 09:20:08
Score: 0.5
Natty:
Report link

I encounterd the same problems.

I use spring and ibatis to map the sql, when i call procedure in PostgreSQL, it always say that "no function matches the given name and argument types. you might need to add explicit type casts."

I feel so confused, cause I always use {call "schema"."procedure name"(?,?,?)} to interact SQL. Why does output say no "function" brabrara.

finally, I realized the problems occur in JDBC driver , the driver may invoke the old calling mode in bottom level.

So you may try this :

  1. find your applicationContent
  2. find the datasource bean in applicationContent
  3. add ?escapeSyntaxCallMode=call behind datasource's url.

it may solve your problem.

Sorry, English is not my native tongue. so it will be a little messy.

Reasons:
  • Whitelisted phrase (-1): try this
  • Long answer (-0.5):
  • No code block (0.5):
  • Contains question mark (0.5):
  • Low reputation (1):
Posted by: Sylas Wu