Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Please paste your receiver data type and receiver CC configuration. Looks like it's simple data/configuration issue.
Thanks,
Apu
sorry my bad
Kindly guide me how to put semi colon at the end of each SQL statement.
Thank you for the Reply.
The query which you are seeing in the scrren shot is generated by PI only, Sales rep status is of type number, that is the reason I did not put that in inverted commas.
Kindly guide me how to put inverted commas at the end of each sql statement. 🙂
We don't use native sql JDBC channels but rather XML SQL - but could you please try putting a semi colon at the end of your statement. If that doesn't work, could you also try putting the 1 [sales rep status] inside inverted comma's.
Exception caught by adapter framework: Error processing request in sax parser: Error when executing statement for table/stored proc. 'MG_STG_SAP_ITEM_LOC' [structure 'Statement']: java.sql.SQLSyntaxErrorException: ORA-00917: missing comma
[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Java Database Connectivity [JDBC]
Hi, I am new to JSP and Oracle. I am getting the "java.sql.SQLException: ORA-00917: missing comma" error whenever I try to insert a string with a quote into the oracle database using JDBC. For example, if I try to insert the word "it's" into the database, I get the error. Can somebody tell me what's the best way to avoid this problem? Thanks in advance for the reply.