Integration

I have been trying to trace the following error for about 2 days now without any luck. Also the surprising part is that this class does not have a javadoc in the API nor is the source code available in the Toplink-src zip file included with the Toplink 101300 download.

The query to be executed is being generated and output correctly, with all bind variables having valid values.

[TopLink Fine]: 2006.06.29 03:14:22.079--UnitOfWork(8886)--Connection(8888)--Thread(Thread[ApplicationServerThread-0,5,RequestThreadGroup])--SELECT t1.PROMOTION_ID, t1.INVOICE_STATUS, t1.INVOICE_TO, t1.INVOICE_DATE, t1.OVERRIDE_REASON, t1.STATUS_UPDATED_DATE, t1.INVOICE_NUMBER, t1.STATUS_UPDATED_BY, t1.PROGRAM_ID, t1.STATUS_CODE, t1.PROMOTION_APP_ID, t1.AUDIT_ID FROM CALENDAR t4, PROMOTION_APPLICATIONS t3, PROGRAM t2, PROMOTIONS t1, STATUS t0 WHERE (((t0.STATUS_CODE = ?) AND ((t2.PROGRAM_ID = ?) AND ((t3.ITEM_NUMBER = ?) AND (t4.PROMOTION_PERIOD = ?)))) AND ((((t0.STATUS_CODE = t1.STATUS_CODE) AND (t2.PROGRAM_ID = t1.PROGRAM_ID)) AND (t3.PROMOTION_APP_ID = t1.PROMOTION_APP_ID)) AND (t4.PROMOTION_PERIOD = t3.PROMOTION_PERIOD)))
bind => [A, 1.0, 178491.0, 200703]

Can someone please help me understand what is wrong with the query. The error stack is as follows:

[TopLink Warning]: 2006.06.29 03:14:22.079--UnitOfWork(8886)--Thread(Thread[ApplicationServerThread-0,5,RequestThreadGroup])--java.lang.NullPointerException

06/06/29 15:14:22 java.lang.NullPointerException
06/06/29 15:14:22 at oracle.toplink.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1159)
06/06/29 15:14:22 at oracle.toplink.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:591)
06/06/29 15:14:22 at oracle.toplink.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:489)
06/06/29 15:14:22 at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:442)
06/06/29 15:14:22 at oracle.toplink.publicinterface.UnitOfWork.executeCall(UnitOfWork.java:1603)
06/06/29 15:14:22 at oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:117)
06/06/29 15:14:22 at oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:103)
06/06/29 15:14:22 at oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.cursorSelectAllRows(DatasourceCallQueryMechanism.java:60)
06/06/29 15:14:22 at oracle.toplink.queryframework.ScrollableCursorPolicy.execute(ScrollableCursorPolicy.java:72)
06/06/29 15:14:22 at oracle.toplink.queryframework.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:449)
06/06/29 15:14:22 at oracle.toplink.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:800)
06/06/29 15:14:22 at oracle.toplink.queryframework.DatabaseQuery.execute(DatabaseQuery.java:603)
06/06/29 15:14:22 at oracle.toplink.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:768)
06/06/29 15:14:22 at oracle.toplink.queryframework.ReadAllQuery.execute(ReadAllQuery.java:436)
06/06/29 15:14:22 at oracle.toplink.queryframework.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:825)
06/06/29 15:14:22 at oracle.toplink.publicinterface.UnitOfWork.internalExecuteQuery(UnitOfWork.java:2532)
06/06/29 15:14:22 at oracle.toplink.publicinterface.Session.executeQuery(Session.java:981)
06/06/29 15:14:22 at oracle.toplink.publicinterface.Session.executeQuery(Session.java:938)
06/06/29 15:14:22 at org.springframework.orm.toplink.TopLinkTemplate$2.readFromSession(TopLinkTemplate.java:233)
06/06/29 15:14:22 at org.springframework.orm.toplink.SessionReadCallback.doInTopLink(SessionReadCallback.java:75)
06/06/29 15:14:22 at org.springframework.orm.toplink.TopLinkTemplate.execute(TopLinkTemplate.java:152)
06/06/29 15:14:22 at org.springframework.orm.toplink.TopLinkTemplate.executeQuery(TopLinkTemplate.java:227)
06/06/29 15:14:22 at org.springframework.orm.toplink.TopLinkTemplate.executeQuery(TopLinkTemplate.java:213)
06/06/29 15:14:22 at xxx.core.persistence.AnyTypeObjectDao.find(AnyTypeObjectDao.java:97)
06/06/29 15:14:22 at xxx.model.service.BusinessValidationServiceImpl.validateXXX(BusinessValidationServiceImpl.java:406)
06/06/29 15:14:22 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
06/06/29 15:14:22 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
06/06/29 15:14:22 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
06/06/29 15:14:22 at java.lang.reflect.Method.invoke(Method.java:585)
06/06/29 15:14:22 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
06/06/29 15:14:22 at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
06/06/29 15:14:22 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
06/06/29 15:14:22 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
06/06/29 15:14:22 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
06/06/29 15:14:22 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
06/06/29 15:14:22 at $Proxy0.validateXXX(Unknown Source)
06/06/29 15:14:22 at xxx.model.service.PromotionsServiceImpl.persist(PromotionsServiceImpl.java:198)
06/06/29 15:14:22 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
06/06/29 15:14:22 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
06/06/29 15:14:22 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
06/06/29 15:14:22 at java.lang.reflect.Method.invoke(Method.java:585)
06/06/29 15:14:22 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
06/06/29 15:14:22 at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
06/06/29 15:14:22 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
06/06/29 15:14:22 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
06/06/29 15:14:22 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
06/06/29 15:14:22 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
06/06/29 15:14:22 at $Proxy1.persist(Unknown Source)
06/06/29 15:14:22 at xxx.view.beans.PromotionApplicationMaintenanceBean.save(PromotionApplicationMaintenanceBean.java:737)
06/06/29 15:14:22 at xxx.view.beans.PromotionApplicationMaintenanceBean.persist(PromotionApplicationMaintenanceBean.java:707)
06/06/29 15:14:22 at xxx.view.beans.PromotionApplicationMaintenanceBean.executePersist(PromotionApplicationMaintenanceBean.java:480)
06/06/29 15:14:22 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
06/06/29 15:14:22 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
06/06/29 15:14:22 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
06/06/29 15:14:22 at java.lang.reflect.Method.invoke(Method.java:585)
06/06/29 15:14:22 at com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:126)
06/06/29 15:14:22 at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:72)
06/06/29 15:14:22 at oracle.adf.view.faces.component.UIXCommand.broadcast(UIXCommand.java:211)
06/06/29 15:14:22 at oracle.adf.view.faces.component.UIXCollection.broadcast(UIXCollection.java:94)
06/06/29 15:14:22 at oracle.adf.view.faces.component.UIXPage.broadcast(UIXPage.java:122)
06/06/29 15:14:22 at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:267)
06/06/29 15:14:22 at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:381)
06/06/29 15:14:22 at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:75)
06/06/29 15:14:22 at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)
06/06/29 15:14:22 at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:90)
06/06/29 15:14:22 at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)
06/06/29 15:14:22 at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
06/06/29 15:14:22 at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._invokeDoFilter(AdfFacesFilterImpl.java:367)
06/06/29 15:14:22 at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._doFilterImpl(AdfFacesFilterImpl.java:336)
06/06/29 15:14:22 at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl.doFilter(AdfFacesFilterImpl.java:196)
06/06/29 15:14:22 at oracle.adf.view.faces.webapp.AdfFacesFilter.doFilter(AdfFacesFilter.java:87)
06/06/29 15:14:22 at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
06/06/29 15:14:22 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:292)
06/06/29 15:14:22 at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
06/06/29 15:14:22 at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:78)
06/06/29 15:14:22 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
06/06/29 15:14:22 at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:143)
06/06/29 15:14:22 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
06/06/29 15:14:22 at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:138)
06/06/29 15:14:22 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
06/06/29 15:14:22 at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:246)
06/06/29 15:14:22 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
06/06/29 15:14:22 at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:220)
06/06/29 15:14:22 at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:303)
06/06/29 15:14:22 at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173)
06/06/29 15:14:22 at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:120)
06/06/29 15:14:22 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)
06/06/29 15:14:22 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
06/06/29 15:14:22 at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
06/06/29 15:14:22 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
06/06/29 15:14:22 at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:218)
06/06/29 15:14:22 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:119)
06/06/29 15:14:22 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
06/06/29 15:14:22 at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
06/06/29 15:14:22 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
06/06/29 15:14:22 at java.lang.Thread.run(Thread.java:595)