We see below error in our log file. Appreciate if you can help us understand the reason for this and its resolution.
Not returning connection 7 for database "pegadata" to the pool as it previously encountered the following error
User ID: firstname.lastname@example.org
Last SQL: DELETE FROM PEGADATA.pr_CAAS_Data_AssignedOrg WHERE OfficerProfileID=? ;
java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
As identified by you above, we are using RDB methods and using "; " as well at the end of the query. This query was working in dev where SQL Server is the data base but not working in higher env where Oracle is being used as DB server.
I see ; being used in OOTB connect SQL rules as well. Ex: PegaSample-Integration-Data-StockTrader-Holding • createHolding • SQL Pega-LP-Integration:07-10-21 . However there are few OOTB rules as well where ; is not being used.
Can you help me understand when to use ; in Connect-SQL rules of Pega.