Products | Versions |
---|---|
TIBCO ActiveMatrix BusinessWorks | - |
Not Applicable | - |
Resolution:
Description:
============
JDBC query activity met “BW-JDBC-100014 Job-45000 Error in.... Invalid parameter binding” error with simple sql statement like “ select PRUEBA.BW.EMPRESA FROM PRUEAB.BW WHERE PRUEBA.BW.APELLIIOS=’?’”
Environment:
===========
All
Cause:
=====
There is a wrong usage of a JDBC SQL statement. Itshould be PRUEBA.BW.APELLIIOS=?
Resolution:
==========
Change the SQL statement from PRUEBA.BW.APELLIIOS=’?’ to PRUEBA.BW.APELLIIOS=? (Note the missing apostrophes).