Question
5
Replies
1639
Views
Accenture
Posted: February 22, 2018
Last activity: April 13, 2018
Closed
Solved
DB Connection Pool Failure
Hello,
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: uat.orguserone@gmail.com
Last SQL: DELETE FROM PEGADATA.pr_CAAS_Data_AssignedOrg WHERE OfficerProfileID=? ;
java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
PFA for stack trace from log file for details.
Hi There,
I guess you would be using RDB methods to manipulate data in the DB.
Somehow I think while writing the query you may have included ";" at the end for connect-sql rule.
Regards,
Ujjwal