JDBC adapter issue.

[former_member182455]

Hi Experts,

we are facing the below issue in JDBC communication channel, kindly provide the right solution to resolve the below issue.

JDBC message processing failed; reason Error processing request in sax parser: Error when executing statement for table/stored proc. '' (structure 'StatementName'): com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'WHERE'.

MP: exception caught with cause com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. '' (structure 'StatementName'): com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'WHERE'.

Exception caught by adapter framework: Error processing request in sax parser: Error when executing statement for table/stored proc. '' (structure 'StatementName'): com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'WHERE'

Thanks

srinivas

[former_member192343]

Hi, what statement is sending to JDBC? How do you crerate it, native sql or XML?

[former_member182455]

Hi Mikhail,

i have created the structure like below.

Thanks

srinivas

[Former Member]

Hello,

It seems that the issue is with ur SP. check with ur DB team.

Thanks

Amit Srivastava

[gagandeep_batra]

check with data also is there any special charterer coming or not? then use escape handling...

Regards

GB

[former_member192343]

Test StoredProcedure with same parameters directly in DB.