I assume you are using the type String for the three properties in your Java code, right ? What does the exact mapping look like ?
Werner Shiva P. Kodityala wrote: > Oracle and all are varchar2. > > SQL> desc table2; > Name Null? Type > ------------------------------- -------- ---- > A VARCHAR2(10) > B VARCHAR2(10) > C VARCHAR2(10) > > > -----Original Message----- > From: Werner Guttmann [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 01, 2005 2:26 PM > To: [email protected] > Subject: Re: [castor-user] ObjectModifiedException > > > Shiva, > > what database are you using ? And what column types to the three columns > a,b and c have ? > > Werner > > Shiva P. Kodityala wrote: > >>Ralf >> >>I created a sample web application with different classes and a table. I >>could reproduce this behaviour again. This time, I have observed a pattern. >> >>Table Name: Table2 has three fields:a, b, c >>I have a class mapping to table: Table2DTO.java: having corresponding fields: >>a, b, c >> >>I am getting ObjectModifiedException when some of the columns have "" value >> >>For example: >> >>I insert a row into Table2 with b and c value blanks. Printed the values of b >>and c of Table2DTO object - shows empty strings >> >>Next time, when I try to modify the column which is blank, I am getting >>ObjectModifiedException. Further modifications of this blank columns are >>successful. >> >>I insert a row >>a1 (b and c are blanks) >> >>modify b where a = a1 -------->ObjectModifiedException >>modify b where a = a1 ---------> success >>modify b where a = a1 ---------> success >> >> >>How do I avoid it? By inserting some default value if nothing is supplied? >> >> >>Thanks >>Shiva. >> >> >> >> >> >> >>-----Original Message----- >>From: Shiva P. Kodityala [mailto:[EMAIL PROTECTED] >>Sent: Thursday, December 01, 2005 1:23 PM >>To: [email protected] >>Subject: RE: [castor-user] ObjectModifiedException >> >> >>Ralf, Thanks for your suggestions. >> >>Do you configure time-period somewhere to make an object available for >>certain time? >> >>"According to my experience I expect >>the problem happend at the last write operation before the failing one." >> >>I too feel the same.. I am doing commit and close resultset and database >>objects after insert; :( >> >>Thanks >>Shiva. >> >>-----Original Message----- >>From: Ralf Joachim [mailto:[EMAIL PROTECTED] >>Sent: Thursday, December 01, 2005 12:11 PM >>To: [email protected] >>Subject: Re: [castor-user] ObjectModifiedException >> >> >>Hi Shiva >> >> >>I'm really sorry but according to the stacktrace it is not possible to >>find out what caused the exception. According to my experience I expect >>the problem happend at the last write operation before the failing one. >>In most cases it is quite difficult to track this as you may have >>recognized yourself. I suggest you to prepare a test case that allows me >>to reproduce the problem. At least with the information I have at the >>moment I am not able to help you. >> >>There is one other thing that came to my mind being the reason for the >>problem. If the object you want to change has been expired from cache >>you may also get this ObjectModifiedException. >> >>Regards >>Ralf >> >> >>Shiva P. Kodityala schrieb: >> >> >> >>>Ralf, >>> >>>I am still not able to figure out what is happening... >>> >>>Could you help me figuring out what is the problem by looking at the >>>exception? Is it because of nulls? >>> >>>exception was logged org.exolab.castor.jdo.ObjectModifiedException: >>>Transaction aborted: Object of type test.tables.User with identity hk has >>>been modified by a concurrent transaction (cache entry is different from >>>database row). The following fields have been changed [actual/expected >>>value]: (test.tables.User).address1: [/null](test.tables.User).address2: >>>[/null](test.tables.User).address3: [null/null](test.tables.User).city: >>>[null/null](test.tables.User).state: [/null] >>> >>>Thanks >>> >>> >>>-----Original Message----- >>>From: Ralf Joachim [mailto:[EMAIL PROTECTED] >>>Sent: Tuesday, November 29, 2005 11:31 PM >>>To: [email protected] >>>Subject: Re: [castor-user] ObjectModifiedException >>> >>> >>>Hi Shiva, >>> >>>a ObjectModifiedException is thrown by Castor if the object in cache >>>differs from the objects representation in the database. There is a >>>various number of reasons that can cause that: >>> >>>- another application changes the values in the database >>>- you have mapped the same table with 2 mappings and change the values >>>through both of them >>>- your database does change values when storing (e.g. convert null to >>>empty String, clip String to column length) >>> >>>Castor is only able to recognize that changes when you try to modify the >>>object the next time after one of the above situation happend. >>> >>>Regards >>>Ralf >>> >>> >>>Shiva P. Kodityala schrieb: >>> >>> >>> >>> >>> >>>>I am trying to modify one of the columns of an obtained row. >>>> >>>>Problem seems to be something to do with nulls. >>>> >>>>Here is the code: >>>> >>>>for(int i=0; i<numberOfSelectedUsers;i++) >>>> >>>>{ >>>> >>>>database = connectionPool.getJDOConnection(); >>>> >>>>database.begin(); >>>> >>>>String oqlString = "select p from test.tables.User p where userid=$1"; >>>> >>>>oql = database.getOQLQuery(oqlString); >>>> >>>>oql.bind( selectedUserIds[i]); >>>> >>>>results = oql.execute(); >>>> >>>>User user = null; >>>> >>>>while (results.hasMore()) { >>>> >>>>user = (User) results.next(); >>>> >>>>} >>>> >>>>user.setActivationstatus(toStatus); >>>> >>>>database.commit(); >>>> >>>>database.close(); >>>> >>>>database = null; >>>> >>>>} >>>> >>>>Here is error. It is not happening always.. I don't know why. >>>> >>>>following fields have been changed [actual/expected value]: >>>>(test.tables.User).address1: [/null](test.tables.User).address2: >>>>[/null](test.tables.User).address3: [null/null](test.tables.User).city: >>>>[null/null](test.tables.User).state: [/null](test.tables.User).country: >>>>[null/null](test.tables.User).ZIP: [/null] >>>>[11/29/05 22:25:06:609 PST] 7e116486 DatabaseImpl E >>>>org.exolab.castor.jdo.engine.DatabaseImpl TRAS0014I: The following >>>>exception was logged org.exolab.castor.jdo.ObjectModifiedException: >>>>Transaction aborted: Object of type test.tables.User with identity hk has >>>>been modified by a concurrent transaction (cache entry is different from >>>>database row). The following fields have been changed [actual/expected >>>>value]: (test.tables.User).address1: [/null](test.tables.User).address2: >>>>[/null](test.tables.User).address3: [null/null](test.tables.User).city: >>>>[null/null](test.tables.User).state: [/null](test.tables.User).country: >>>>[null/null](test.tables.User).ZIP: [/null] >>>>at org.exolab.castor.jdo.engine.SQLEngine.store(SQLEngine.java:1013) >>>>at org.exolab.castor.persist.ClassMolder.store(ClassMolder.java:834) >>>>at org.exolab.castor.persist.LockEngine.store(LockEngine.java:779) >>>>at >>>>org.castor.persist.TransactionContext.prepareForCreate(TransactionContext..java:1654) >>>>at >>>>org.castor.persist.TransactionContext.prepare(TransactionContext.java:1618) >>>>at org.exolab.castor.jdo.engine.DatabaseImpl.commit(DatabaseImpl.java:521) >>>>at test.actions.ChangeStatusAction.changeStatus(ChangeStatusAction.java:226) >>>>at test.actions.ChangeStatusAction.active(ChangeStatusAction.java:120) >>>>at test.actions.ChangeStatusAction.execute(ChangeStatusAction.java:47) >>>>at >>>>org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) >>>>at >>>>org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) >>>>at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) >>>>at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) >>>>at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) >>>>at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) >>>>at >>>>com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110) >>>>at >>>>com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174) >>>>at >>>>com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313) >>>>at >>>>com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116) >>>>at >>>>com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283) >>>>at >>>>com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42) >>>>at >>>>com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40) >>>>at >>>>com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:983) >>>>at >>>>com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:564) >>>>at >>>>com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200) >>>>at >>>>com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119) >>>>at >>>>com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276) >>>>at >>>>com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71) >>>>at >>>>com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182) >>>>at >>>>com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334) >>>>at >>>>com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56) >>>>at >>>>com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618) >>>>at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439) >>>>at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672) >>>>.. >>>> >>>> org.exolab.castor.jdo.ObjectModifiedException: Transaction aborted: Object >>>> of type test.tables.User with identity hk has been modified by a >>>> concurrent transaction (cache entry is different from database row). The >>>> following fields have been changed [actual/expected value]: >>>> (test.tables.User).address1: [/null](test.tables.User).address2: >>>> [/null](test.tables.User).address3: [null/null](test.tables.User).city: >>>> [null/null](test.tables.User).state: [/null](test.tables.User).country: >>>> [null/null](test.tables.User).ZIP: [/null] >>>>at org.exolab.castor.jdo.engine.SQLEngine.store(SQLEngine.java:1013) >>>>at org.exolab.castor.persist.ClassMolder.store(ClassMolder.java:834) >>>>at org.exolab.castor.persist.LockEngine.store(LockEngine.java:779) >>>>at >>>>org.castor.persist.TransactionContext.prepareForCreate(TransactionContext..java:1654) >>>>at >>>>org.castor.persist.TransactionContext.prepare(TransactionContext.java:1618) >>>>at org.exolab.castor.jdo.engine.DatabaseImpl.commit(DatabaseImpl.java:521) >>>>at test.actions.ChangeStatusAction.changeStatus(ChangeStatusAction.java:226) >>>>at test.actions.ChangeStatusAction.active(ChangeStatusAction.java:120) >>>>at test.actions.ChangeStatusAction.execute(ChangeStatusAction.java:47) >>>>at >>>>org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) >>>>at >>>>org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) >>>>at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) >>>>at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) >>>>at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) >>>>at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) >>>>at >>>>com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110) >>>>at >>>>com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174) >>>>at >>>>com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313) >>>>at >>>>com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116) >>>>at >>>>com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283) >>>>at >>>>com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42) >>>>at >>>>com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40) >>>>at >>>>com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:983) >>>>at >>>>com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:564) >>>>at >>>>com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200) >>>>at >>>>com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119) >>>>at >>>>com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276) >>>>at >>>>com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71) >>>>at >>>>com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182) >>>>at >>>>com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334) >>>>at >>>>com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56) >>>>at >>>>com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618) >>>>at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439) >>>>at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672) >>>> >>>>[11/29/05 22:25:06:656 PST] 7e116486 SystemErr R >>>>org.exolab.castor.jdo.ObjectModifiedException: Transaction aborted: Object >>>>of type test.tables.User with identity hk has been modified by a concurrent >>>>transaction (cache entry is different from database row). The following >>>>fields have been changed [actual/expected value]: >>>>(test.tables.User).address1: [/null](test.tables.User).address2: >>>>[/null](test.tables.User).address3: [null/null](test.tables.User).city: >>>>[null/null](test.tables.User).state: [/null](test.tables.User).country: >>>>[null/null](test.tables.User).ZIP: [/null] >>>>[11/29/05 22:25:06:656 PST] 7e116486 SystemErr R at >>>>org.exolab.castor.jdo.engine.SQLEngine.store(SQLEngine.java:1013) >>>>[11/29/05 22:25:06:656 PST] 7e116486 SystemErr R at >>>>org.exolab.castor.persist.ClassMolder.store(ClassMolder.java:834) >>>>[11/29/05 22:25:06:656 PST] 7e116486 SystemErr R at >>>>org.exolab.castor.persist.LockEngine.store(LockEngine.java:779) >>>>[11/29/05 22:25:06:656 PST] 7e116486 SystemErr R at >>>>org.castor.persist.TransactionContext.prepareForCreate(TransactionContext..java:1654) >>>>[11/29/05 22:25:06:656 PST] 7e116486 SystemErr R at >>>>org.castor.persist.TransactionContext.prepare(TransactionContext.java:1618) >>>>[11/29/05 22:25:06:656 PST] 7e116486 SystemErr R at >>>>org.exolab.castor.jdo.engine.DatabaseImpl.commit(DatabaseImpl.java:521) >>>>[11/29/05 22:25:06:656 PST] 7e116486 SystemErr R at >>>>test.actions.ChangeStatusAction.changeStatus(ChangeStatusAction.java:226) >>>>[11/29/05 22:25:06:656 PST] 7e116486 SystemErr R at >>>>test.actions.ChangeStatusAction.active(ChangeStatusAction.java:120) >>>>[11/29/05 22:25:06:656 PST] 7e116486 SystemErr R at >>>>test.actions.ChangeStatusAction.execute(ChangeStatusAction.java:47) >>>>[11/29/05 22:25:06:656 PST] 7e116486 SystemErr R at >>>>org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) >>>>[11/29/05 22:25:06:656 PST] 7e116486 SystemErr R at >>>>org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) >>>>[11/29/05 22:25:06:656 PST] 7e116486 SystemErr R at >>>>org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) >>>>[11/29/05 22:25:06:656 PST] 7e116486 SystemErr R at >>>>org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) >>>>[11/29/05 22:25:06:656 PST] 7e116486 SystemErr R at >>>>javax.servlet.http.HttpServlet.service(HttpServlet.java:760) >>>>[11/29/05 22:25:06:656 PST] 7e116486 SystemErr R at >>>>javax.servlet.http.HttpServlet.service(HttpServlet.java:853) >>>>[11/29/05 22:25:06:656 PST] 7e116486 SystemErr R at >>>>com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110) >>>>[11/29/05 22:25:06:672 PST] 7e116486 SystemErr R at >>>>com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174) >>>>[11/29/05 22:25:06:672 PST] 7e116486 SystemErr R at >>>>com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313) >>>>[11/29/05 22:25:06:672 PST] 7e116486 SystemErr R at >>>>com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116) >>>>[11/29/05 22:25:06:672 PST] 7e116486 SystemErr R at >>>>com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283) >>>>[11/29/05 22:25:06:672 PST] 7e116486 SystemErr R at >>>>com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42) >>>>[11/29/05 22:25:06:672 PST] 7e116486 SystemErr R at >>>>com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40) >>>>[11/29/05 22:25:06:672 PST] 7e116486 SystemErr R at >>>>com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:983) >>>>[11/29/05 22:25:06:672 PST] 7e116486 SystemErr R at >>>>com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:564) >>>>[11/29/05 22:25:06:672 PST] 7e116486 SystemErr R at >>>>com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200) >>>>[11/29/05 22:25:06:672 PST] 7e116486 SystemErr R at >>>>com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119) >>>>[11/29/05 22:25:06:672 PST] 7e116486 SystemErr R at >>>>com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276) >>>>[11/29/05 22:25:06:672 PST] 7e116486 SystemErr R at >>>>com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71) >>>>[11/29/05 22:25:06:672 PST] 7e116486 SystemErr R at >>>>com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182) >>>>[11/29/05 22:25:06:672 PST] 7e116486 SystemErr R at >>>>com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334) >>>>[11/29/05 22:25:06:672 PST] 7e116486 SystemErr R at >>>>com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56) >>>>[11/29/05 22:25:06:672 PST] 7e116486 SystemErr R at >>>>com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618) >>>>[11/29/05 22:25:06:672 PST] 7e116486 SystemErr R at >>>>com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439) >>>>[11/29/05 22:25:06:672 PST] 7e116486 SystemErr R at >>>>com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672) >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>>------------------------------------------------------------------------ >>>> >>>>------------------------------------------------- >>>>If you wish to unsubscribe from this list, please >>>>send an empty message to the following address: >>>> >>>>[EMAIL PROTECTED] >>>>------------------------------------------------- >>>> >>>> >>>> >>> >>> >>>------------------------------------------------- >>>If you wish to unsubscribe from this list, please >>>send an empty message to the following address: >>> >>>[EMAIL PROTECTED] >>>------------------------------------------------- >>> >>> >>>------------------------------------------------- >>>If you wish to unsubscribe from this list, please >>>send an empty message to the following address: >>> >>>[EMAIL PROTECTED] >>>------------------------------------------------- >>> >>> >>> >> >> >> >>------------------------------------------------- >>If you wish to unsubscribe from this list, please >>send an empty message to the following address: >> >>[EMAIL PROTECTED] >>------------------------------------------------- >> >> >>------------------------------------------------- >>If you wish to unsubscribe from this list, please >>send an empty message to the following address: >> >>[EMAIL PROTECTED] >>------------------------------------------------- >> >> >>------------------------------------------------- >>If you wish to unsubscribe from this list, please >>send an empty message to the following address: >> >>[EMAIL PROTECTED] >>------------------------------------------------- >> >> > > > > ------------------------------------------------- > If you wish to unsubscribe from this list, please > send an empty message to the following address: > > [EMAIL PROTECTED] > ------------------------------------------------- > > > ------------------------------------------------- > If you wish to unsubscribe from this list, please > send an empty message to the following address: > > [EMAIL PROTECTED] > ------------------------------------------------- > > ------------------------------------------------- If you wish to unsubscribe from this list, please send an empty message to the following address: [EMAIL PROTECTED] -------------------------------------------------
