Database Tuning (MOSC)

MOSC Banner

application not commiting

edited Jul 19, 2011 4:34AM in Database Tuning (MOSC) 2 commentsAnswered
Hi all,
i have an OLTP application running on weblogic application server. The users fills on the online form available on the site. The problem i am facing is that some records for users is not being committed. I have the log below:-

sDebitDate: 19/07/2011
Document Parsed!!!
Document Parsed and Got the Doc!!!
DatabaseConnect.getCon() - Created NEW connection
Mode: retrieve
DatabaseConnect.getCon() - Created NEW connection
isCentreType- subscriber=CNSVC01017 bRes=false
CTXReturn.java - retrieveCompanyNames - sQuery: SELECT DISTINCT Y.COMP_ID,Y.COMP_NAME,Y.COMP_TYPE,Y.TAN FROM WCP_USR_ACCESS_COMP X,WCP_EMPL_HDR Y WHERE  Y.COMP_ID=X.COMP_ID AND X.USER_ID='SUSR001744' AND Y.CTX_FLAG ='Y' ORDER BY Y.COMP_NAME

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center