JDBC Syntax error

[Former Member]

Hi All,

i am facing issues withe receiver JDBC adapter the issues is

"Exception caught by adapter framework: Error processing request in sax parser: Error when executing statement for table/stored proc. 'xxxxxxxxxxx table name' (structure 'Statement1'): com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ','.

scenario is PROXY to JDBC.

[pvishnuvardan_reddy]

Hi Bhagya,

It looks like the payload which you want to pass to the stored procedure is not matching with the stored procedure input format.

Can you cross check whether you are passing the values as expected by the procedure.

Also, in your receiver channel configuration, can you check what did you maintain for empty string values.

Regards

Vishnu

[Former Member]

Hi Bhagya,

I think payload is similar in both cases.. If so check the passing values in both cases.. you might be passing syntax mismatch data...

If possible can you please share the payload so that we can track issue immediately...

Please check the JDBC errors in below links you will get one idea..

http://www.wikiguga.com/topic/568540e802f877d9ab20b83ff77f25ca

http://www.wikiguga.com/topic/983781419294f65c8a6158cfc45b84db

http://www.postseek.com/meta/cec0639fdea4ec62def20b0e3a681241

Regards,

Srikanth Mavuri.

[iaki_vila]

Hi Bhagya,

Please share the payload of your receiver JDBC adapter, obviously the payload has a syntax error to be converted from XML JDBC PI format to JDBC format.

Are you using SQL_QUERY or SQL_DML?, may be you have a comma wrong set.

Regards.

[Former Member]

Hi,

for some records messages is success and update in database tables also for some records i am facin this problem.

Regards,

Bhagya.

[iaki_vila]

Hi Bhagya,

Is the payload similar in the two cases?, i want to mean if one right update for example you are passing 4 values and one empty, on the wrong update is similar the update?.

A syntax error only can be a wrong SQL sentence formed from the JDBC PI XML , please check if the values are passed similar; for example same type of date format, same decimal values, strings with the length, an so on.

Regards.