SQLException Cant find local placeholder mapping parameter

SQLException Cant find local placeholder mapping parameter

If you see exception while calling stored procedure:
java.sql.SQLException: Can’t find local placeholder mapping for parameter named “departId”

Solution: It means your stored procedure is expecting parameter and during making call to its parameter is missing

  • Example stored procedure which takes one parameter:

  • If you will call as below you will get exception:

  • As you see above while calling stored procedure parameter is missing (

  • To fix it please see below:

  • For more informaton calling stored procedure in Spring please use this linkĀ 

Leave a Reply

Your email address will not be published. Required fields are marked *