When try to pass variable into query of database connector it gives error

1
0
-1

hello ,

i m using on service task which give ti list of pant based on parameter of user's city i m using oracle 10 database connector .

Detail description ,

  1. perameter : NDS
  2. query : "Select title from plant_mst where unit_id=NDS"

this is perfactly run . but when i try dynamic query .

Select title from plant_mst where unit_id = " + city(variable- which store users city =NDS)

it gives error : Invelid Identifier . what i m doing wrong .

Here is server log :

WARNING: THREAD_ID=94 | HOSTNAME=CRP-027 | TENANT_ID=1 | org.bonitasoft.engine.core.connector.exception.SConnectorException : "PROCESS_DEFINITION_ID=6869692618665564032 | PROCESS_NAME=testUnit_plant | PROCESS_VERSION=1.0 | PROCESS_INSTANCE_ID=1005 | ROOT_PROCESS_INSTANCE_ID=1005 | FLOW_NODE_DEFINITION_ID=-8105329340802849338 | FLOW_NODE_INSTANCE_ID=20019 | FLOW_NODE_NAME=DropDowns | CONNECTOR_DEFINITION_IMPLEMENTATION_CLASS_NAME=unit | CONNECTOR_INSTANCE_ID=20010 | org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: java.sql.SQLSyntaxErrorException: ORA-00904: "NDS": invalid identifier
"
1 answer

1
0
-1

The clue is in the error message.

java.sql.SQLSyntaxErrorException: ORA-00904: "NDS": invalid identifier

Should NDS be quoted or is it really an identifier (aka: variable or column name)?

eg: select title from plant_mst where unit_id = 'NDS';

Notifications