Skip to Content
0
Former Member
Jul 19, 2013 at 09:45 AM

Proxy to JDBC scenario....enexpected behaviour...while inserting into table...

11 Views

HI

I am working on Proxy to JDBC scenario........

All the objects are created....but sometimes it looks like it is success and sometimes it is failing saying as below.....

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'MANAGER_STAGING' (structure 'STATEMENT'): java.sql.SQLSyntaxErrorException: line 1, Syntax error on ','. The correct syntax is: INSERT INTO tablename [(column {, ... })] [OVERRIDING {SYSTEM | USER} VALUE] VALUES (expression {, ... }) {, ... } INSERT INTO tablename [(column {, ... })] [OVERRIDING {SYSTEM | USER} VALUE] subselect

Error when executing statement for table/stored proc. MANAGER_STAGING' (structure 'STATEMENT'): java.sql.SQLSyntaxErrorException: line 1, Syntax error on ','. The correct syntax is: INSERT INTO tablename [(column {, ... })] [OVERRIDING {SYSTEM | USER} VALUE] VALUES (expression {, ... }) {, ... } INSERT INTO tablename [(column {, ... })] [OVERRIDING {SYSTEM | USER} VALUE] subselect


Error processing request in sax parser: Error when executing statement for table/stored proc. 'MANAGER_STAGING' (structure 'STATEMENT'): java.sql.SQLSyntaxErrorException: line 1, Syntax error on ','. The correct syntax is: INSERT INTO tablename [(column {, ... })] [OVERRIDING {SYSTEM | USER} VALUE] VALUES (expression {, ... }) {, ... } INSERT INTO tablename [(column {, ... })] [OVERRIDING {SYSTEM | USER} VALUE] subselect

Do we need to take care any Database table level tuning activities like index......because database level just created a table ...that;s it.

Some times for few records it is working fine.....but some times if we get around 100 rows also it is failing as above.

Please help.......

Thanks