Issue With Auto Commit In IPE. (Doc ID 3050510.1)

Last updated on OCTOBER 05, 2024

Applies to:

Symptoms

While configuring scoring IPE rules, auto commit is failing.

STEPS TO REPRODUCE PROBLEM
=============================
1. Add a new inline Dataset
2. Add all the mandatory fields as shown in the screenshot.
3. Finally Save and see a error : Failed to Save

Changes

 Observed below error in ummServcie.log.

[24-05-24 13:00:39,186 GMT PM] [DEBUG] [WEB] [UMM] [ECMADMIN1] [RELATIONSHIPDAO] INSERTJOINCONDITIONS >> insert into RTI_BUS_TBL_JOIN_REL (N_TBL_JOIN_ID,N_SRC_BUS_ID,N_DEST_BUS_ID, V_REL_NAME,V_INFODOM,V_APP_ID,N_SRC_INPUT_TYPE, N_SRC_BUS_NAME_ID, V_SRC_LTRL_VAL, N_SRC_EXP_ID, V_OPERATOR, N_DEST_INPUT_TYPE, N_DEST_BUS_NAME_ID, V_DEST_LTRL_VAL , N_DEST_EXP_ID) values(tasks.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
[24-05-24 13:00:39,186 GMT PM] [DEBUG] [WEB] [UMM] [ECMADMIN1] [RELATIONSHIPDAO] joinCons[i] >> 1,20477,=,1,22019
[24-05-24 13:00:39,186 GMT PM] [DEBUG] [WEB] [UMM] [ECMADMIN1] [RELATIONSHIPDAO] Before commit
[24-05-24 13:00:39,187 GMT PM] [ERROR] [WEB] [UMM] [ECMADMIN1] [LOGGER] Could not commit with auto-commit set on
java.sql.SQLException: Could not commit with auto-commit set on
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:2186)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:2222)
at org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.commit(DelegatingConnection.java:194)
at org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.commit(DelegatingConnection.java:194)
at com.ofs.aai.realtime.dao.RelationshipDAO.saveJoinRelation(RelationshipDAO.java:467)
at com.ofs.aai.realtime.service.RelationshipService.saveJoinRelation(RelationshipService.java:254)
at com.ofs.aai.realtime.servlet.handler.RTIJoinRelSaveHandler.handleRequest(RTIJoinRelSaveHandler.java:28)
at com.ofs.aai.realtime.servlet.RTIServlet.doPost(RTIServlet.java:80)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:555)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154)
at com.mantas.platform.servlet.UTF8Filter.doFilter(UTF8Filter.java:23)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:154)
at com.iflex.fic.filters.FilterServlet.doFilter(FilterServlet.java:1476)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:179)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.