Error after trying to save duplicated key oracle, spring, Error

amy

I'm currently use

spring 305 + spring security 305 + spring flex integration 103 + oracle toplink essential 2.0  on Tomcat 6.0.32

and I'm trying to handle the duplicated key exception, but after exception I can do update but can't query data using findBySQL like below:

I hope someone to point me out of this problem.

Thanks.

[Method in DAO]

@SuppressWarnings(quot;uncheckedquot;)
public Listlt;UserQueryFieldgt; findBySQL(final String whereString) {
try {
final String queryString = quot;select e from UserQueryField e where quot; + whereString;
return getJpaTemplate().executeFind(new JpaCallback() {
public Object doInJpa(EntityManager em) throws PersistenceException {
Query query = em.createQuery(queryString);
return query.getResultList();
}
});
} catch (RuntimeException re) {
logger.error(quot;find by SQL failedquot;, re);
throw re;
}
}

[Method update in Service Bean]

@Transactional(propagation = Propagation.REQUIRED, rollbackFor = IOException.class, noRollbackFor = RuntimeException.class)
public UserQueryField update(UserQueryField userQueryField) {
try {
return UserQueryFieldDAO.update(userQueryField);
} catch (RuntimeException re) {

throw re;
}--------------------------
[TopLink Warning]: 2554.02.13 10:21:32.813--UnitOfWork(8571215)--java.lang.NullPointerException
2554-02-13 22:21:32,818 ERROR [com.wisdomplus.dao.UserQueryFieldDAO] - lt;find by SQL failedgt;
java.lang.NullPointerException
at oracle.toplink.essentials.internal.sessions.Abstra  ctRecord.getIndicatingNoEntry(AbstractRecord.java:  287)
at oracle.toplink.essentials.internal.sessions.Abstra  ctRecord.get(AbstractRecord.java:262)
at oracle.toplink.essentials.descriptors.InheritanceP  olicy.classFromRow(InheritancePolicy.java:319)
at oracle.toplink.essentials.internal.descriptors.Obj  ectBuilder.buildObject(ObjectBuilder.java:356)
at oracle.toplink.essentials.queryframework.ReportQue  ryResult.processItem(ReportQueryResult.java:205)
at oracle.toplink.essentials.queryframework.ReportQue  ryResult.buildResult(ReportQueryResult.java:167)
at oracle.toplink.essentials.queryframework.ReportQue  ryResult.lt;initgt;(ReportQueryResult.java:83)
at oracle.toplink.essentials.queryframework.ReportQue  ry.buildObject(ReportQuery.java:579)
at oracle.toplink.essentials.queryframework.ReportQue  ry.buildObjects(ReportQuery.java:628)
at oracle.toplink.essentials.queryframework.ReportQue  ry.executeDatabaseQuery(ReportQuery.java:776)
at oracle.toplink.essentials.queryframework.DatabaseQ  uery.execute(DatabaseQuery.java:609)
at oracle.toplink.essentials.queryframework.ObjectLev  elReadQuery.execute(ObjectLevelReadQuery.java:677)
at oracle.toplink.essentials.queryframework.ObjectLev  elReadQuery.executeInUnitOfWork(ObjectLevelReadQue  ry.java:731)
at oracle.toplink.essentials.internal.sessions.UnitOf  WorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:  2219)
at oracle.toplink.essentials.internal.sessions.Abstra  ctSession.executeQuery(AbstractSession.java:937)
at oracle.toplink.essentials.internal.sessions.Abstra  ctSession.executeQuery(AbstractSession.java:909)
at oracle.toplink.essentials.internal.ejb.cmp3.base.E  JBQueryImpl.executeReadQuery(EJBQueryImpl.java:346  )
at oracle.toplink.essentials.internal.ejb.cmp3.base.E  JBQueryImpl.getResultList(EJBQueryImpl.java:453)
at com.wisdomplus.dao.UserQueryFieldDAO$3.doInJpa(Use  rQueryFieldDAO.java:114)
at org..orm.jpa.JpaTemplate.execute(Jp  aTemplate.java:183)
at org..orm.jpa.JpaTemplate.executeFin  d(JpaTemplate.java:150)
at com.wisdomplus.dao.UserQueryFieldDAO.findBySQL(Use  rQueryFieldDAO.java:111)
at com.wisdomplus.service.base.UserQueryFieldServiceB  ase.findBySQL(UserQueryFieldServiceBase.java:121)
at com.wisdomplus.service.base.UserQueryFieldServiceB  ase$$FastClassByCGLIB$$69af844b.invoke(lt;generatedgt;  )
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.  java:149)
at org..aop.framework.Cglib2AopProxy$D  ynamicAdvisedInterceptor.intercept(Cglib2AopProxy.  java:617)
at com.wisdomplus.service.UserQueryFieldService$$Enha  ncerByCGLIB$$613279b.findBySQL(lt;generatedgt;)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ  e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native  MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De  legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at flex.messaging.services.remoting.adapters.JavaAdap  ter.invoke(JavaAdapter.java:418)
at flex.messaging.services.RemotingService.serviceMes  sage(RemotingService.java:183)
at flex.messaging.MessageBroker.routeMessageToService  (MessageBroker.java:1400)
at flex.messaging.endpoints.AbstractEndpoint.serviceM  essage(AbstractEndpoint.java:1005)
at flex.messaging.endpoints.AbstractEndpoint$$FastCla  ssByCGLIB$$1a3ef066.invoke(lt;generatedgt;)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.  java:149)
at org..aop.framework.Cglib2AopProxy$C  glibMethodInvocation.invokeJoinpoint(Cglib2AopProx  y.java:688)
at org..aop.framework.ReflectiveMethod  Invocation.proceed(ReflectiveMethodInvocation.java  :150)
at org..flex.core.MessageInterceptionA  dvice.invoke(MessageInterceptionAdvice.java:66)
at org..aop.framework.ReflectiveMethod  Invocation.proceed(ReflectiveMethodInvocation.java  :172)
at org..aop.framework.adapter.ThrowsAd  viceInterceptor.invoke(ThrowsAdviceInterceptor.jav  a:124)
at org..aop.framework.ReflectiveMethod  Invocation.proceed(ReflectiveMethodInvocation.java  :172)
at org..aop.framework.Cglib2AopProxy$F  ixedChainStaticTargetInterceptor.intercept(Cglib2A  opProxy.java:572)
at flex.messaging.endpoints.AMFEndpoint$$EnhancerByCG  LIB$$64d82b8f.serviceMessage(lt;generatedgt;)
at flex.messaging.endpoints.amf.MessageBrokerFilter.i  nvoke(MessageBrokerFilter.java:103)
at flex.messaging.endpoints.amf.LegacyFilter.invoke(L  egacyFilter.java:158)
at flex.messaging.endpoints.amf.SessionFilter.invoke(  SessionFilter.java:44)
at flex.messaging.endpoints.amf.BatchProcessFilter.in  voke(BatchProcessFilter.java:67)
at flex.messaging.endpoints.amf.SerializationFilter.i  nvoke(SerializationFilter.java:166)
at flex.messaging.endpoints.BasefromEndpoint.service(  BasefromEndpoint.java:291)
at flex.messaging.endpoints.AMFEndpoint$$EnhancerByCG  LIB$$64d82b8f.service(lt;generatedgt;)
at org..flex.servlet.MessageBrokerHand  lerAdapter.handle(MessageBrokerHandlerAdapter.java  :101)
at org..web.servlet.DispatcherServlet.  doDispatch(DispatcherServlet.java:790)
at org..web.servlet.DispatcherServlet.  doService(DispatcherServlet.java:719)
at org..web.servlet.FrameworkServlet.p  rocessRequest(FrameworkServlet.java:644)
at org..web.servlet.FrameworkServlet.d  oPost(FrameworkServlet.java:560)
at javax.servlet.from.fromServlet.service(fromServlet  .java:637)
at javax.servlet.from.fromServlet.service(fromServlet  .java:717)

at org.apache.catalina.core.ApplicationFilterChain.in  ternalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.do  Filter(ApplicationFilterChain.java:206)
at org..security.web.FilterChainProxy$  VirtualFilterChain.doFilter(FilterChainProxy.java:  368)
at org..security.web.access.intercept.  FilterSecurityInterceptor.invoke(FilterSecurityInt  erceptor.java:109)
at org..security.web.access.intercept.  FilterSecurityInterceptor.doFilter(FilterSecurityI  nterceptor.java:83)
at org..security.web.FilterChainProxy$  VirtualFilterChain.doFilter(FilterChainProxy.java:  380)
at org..security.web.access.ExceptionT  ranslationFilter.doFilter(ExceptionTranslationFilt  er.java:97)
at org..security.web.FilterChainProxy$  VirtualFilterChain.doFilter(FilterChainProxy.java:  380)
at org..security.web.session.SessionMa  nagementFilter.doFilter(SessionManagementFilter.ja  va:100)
at org..security.web.FilterChainProxy$  VirtualFilterChain.doFilter(FilterChainProxy.java:  380)
at org..security.web.servletapi.Securi  tyContextHolderAwareRequestFilter.doFilter(Securit  yContextHolderAwareRequestFilter.java:54)
at org..security.web.FilterChainProxy$  VirtualFilterChain.doFilter(FilterChainProxy.java:  380)
at org..security.web.savedrequest.Requ  estCacheAwareFilter.doFilter(RequestCacheAwareFilt  er.java:35)
at org..security.web.FilterChainProxy$  VirtualFilterChain.doFilter(FilterChainProxy.java:  380)
at org..security.web.context.SecurityC  ontextPersistenceFilter.doFilter(SecurityContextPe  rsistenceFilter.java:79)
at org..security.web.FilterChainProxy$  VirtualFilterChain.doFilter(FilterChainProxy.java:  380)
at org..web.filter.RequestContextFilte  r.doFilterInternal(RequestContextFilter.java:83)
at org..web.filter.OncePerRequestFilte  r.doFilter(OncePerRequestFilter.java:76)
at org..security.web.FilterChainProxy$  VirtualFilterChain.doFilter(FilterChainProxy.java:  380)
at org..security.web.FilterChainProxy.  doFilter(FilterChainProxy.java:169)
at org..web.filter.DelegatingFilterPro  xy.invokeDelegate(DelegatingFilterProxy.java:237)
at org..web.filter.DelegatingFilterPro  xy.doFilter(DelegatingFilterProxy.java:167)