JDBC query activity met “BW-JDBC-100014 Job-45000 Error in.... Invalid parameter binding” error.

JDBC query activity met “BW-JDBC-100014 Job-45000 Error in.... Invalid parameter binding” error.

book

Article ID: KB0090384

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks -
Not Applicable -

Description

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).

Issue/Introduction

JDBC query activity met “BW-JDBC-100014 Job-45000 Error in.... Invalid parameter binding” error.