4 Replies Latest reply on Nov 7, 2006 3:21 PM by Sergio Moreno

    BankLoanBrokerDemo SQL Exception

    Sergio Moreno Newbie

      Hello, I am trying to run the trailblazer demo but i've run into an SQL exception I don't know nothing of, the exception is as follows:

      12:21:49,588 INFO [PersistHandlerBean] org.jboss.soa.esb.services.beans.PersistHandlerBean@a96fd2 Created
      12:21:50,616 ERROR [JdbcCleanConn] execUpdWait() FAILED
      java.sql.SQLException: ERROR: column "xml_data" is of type text but expression is of type bytea
      at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1495)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1279)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:186)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:392)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:330)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:282)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:251
      )
      at org.jboss.soa.esb.helpers.persist.JdbcCleanConn.execUpdateWait(JdbcCleanConn.java:132)
      at org.jboss.soa.esb.services.beans.PersistHandlerBean.doAddSnapshot(PersistHandlerBean.java:307)
      at org.jboss.soa.esb.services.beans.PersistHandlerBean.doAddSnapshot(PersistHandlerBean.java:288)
      at org.jboss.soa.esb.services.beans.PersistHandlerBean.addDTO(PersistHandlerBean.java:167)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
      at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
      at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInt
      erceptor.java:54)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.ejb3.tx.BMTInterceptor.handleStateless(BMTInterceptor.java:71)
      at org.jboss.ejb3.tx.BMTInterceptor.invoke(BMTInterceptor.java:131)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:78)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:225)
      at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:55)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.ejb3.stateless.StatelessRemoteProxy.invoke(StatelessRemoteProxy.java:102)
      at $Proxy85.addDTO(Unknown Source)
      at org.jboss.soa.esb.services.PersistHandlerBsDelegateRemote.addObject(PersistHandlerBsDelegateRemote.java:
      56)
      at org.jboss.soa.esb.samples.loanbroker.web.LoanBrokerWS.RequestLoan(LoanBrokerWS.java:66)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.ws.server.ServiceEndpointInvokerJSE.invokeServiceEndpoint(ServiceEndpointInvokerJSE.java:95)
      at org.jboss.ws.server.ServiceEndpointInvoker.invoke(ServiceEndpointInvoker.java:118)
      at org.jboss.ws.server.ServiceEndpoint.handleRequest(ServiceEndpoint.java:234)
      at org.jboss.ws.server.ServiceEndpointServlet.doPost(ServiceEndpointServlet.java:120)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
      at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
      at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol
      .java:664)
      at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
      at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
      at java.lang.Thread.run(Thread.java:595)
      12:21:50,679 ERROR [STDERR] java.sql.SQLException: ERROR: column "xml_data" is of type text but expression is of ty
      pe bytea
      12:21:50,679 ERROR [STDERR] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.
      java:1495)
      12:21:50,679 ERROR [STDERR] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1
      279)
      12:21:50,679 ERROR [STDERR] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:186)
      12:21:50,679 ERROR [STDERR] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:
      392)
      12:21:50,679 ERROR [STDERR] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statem
      ent.java:330)
      12:21:50,679 ERROR [STDERR] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement
      .java:282)
      12:21:50,679 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPr
      eparedStatement.java:251)
      12:21:50,679 ERROR [STDERR] at org.jboss.soa.esb.helpers.persist.JdbcCleanConn.execUpdateWait(JdbcCleanConn.jav
      a:132)
      12:21:50,679 ERROR [STDERR] at org.jboss.soa.esb.services.beans.PersistHandlerBean.doAddSnapshot(PersistHandler
      Bean.java:307)
      12:21:50,679 ERROR [STDERR] at org.jboss.soa.esb.services.beans.PersistHandlerBean.doAddSnapshot(PersistHandler
      Bean.java:288)
      12:21:50,679 ERROR [STDERR] at org.jboss.soa.esb.services.beans.PersistHandlerBean.addDTO(PersistHandlerBean.ja
      va:167)
      12:21:50,679 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      12:21:50,679 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      12:21:50,679 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav
      a:25)
      12:21:50,679 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
      12:21:50,679 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
      12:21:50,679 ERROR [STDERR] at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.j
      ava:166)
      12:21:50,679 ERROR [STDERR] at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsIn
      terceptor.java:63)
      12:21:50,679 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      12:21:50,679 ERROR [STDERR] at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(Transacti
      onScopedEntityManagerInterceptor.java:54)
      12:21:50,679 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      12:21:50,679 ERROR [STDERR] at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.
      java:47)
      12:21:50,679 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      12:21:50,679 ERROR [STDERR] at org.jboss.ejb3.tx.BMTInterceptor.handleStateless(BMTInterceptor.java:71)
      12:21:50,679 ERROR [STDERR] at org.jboss.ejb3.tx.BMTInterceptor.invoke(BMTInterceptor.java:131)
      12:21:50,679 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      12:21:50,679 ERROR [STDERR] at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.ja
      va:76)
      12:21:50,679 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      12:21:50,679 ERROR [STDERR] at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceIn
      terceptor.java:62)
      12:21:50,694 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      12:21:50,694 ERROR [STDERR] at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterc
      eptor.java:78)
      12:21:50,694 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      12:21:50,694 ERROR [STDERR] at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:4
      7)
      12:21:50,694 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      12:21:50,694 ERROR [STDERR] at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousIntercept
      or.java:106)
      12:21:50,694 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      12:21:50,694 ERROR [STDERR] at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.jav
      a:225)
      12:21:50,694 ERROR [STDERR] at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:55)
      12:21:50,694 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      12:21:50,694 ERROR [STDERR] at org.jboss.ejb3.stateless.StatelessRemoteProxy.invoke(StatelessRemoteProxy.java:1
      02)
      12:21:50,694 ERROR [STDERR] at $Proxy85.addDTO(Unknown Source)
      12:21:50,694 ERROR [STDERR] at org.jboss.soa.esb.services.PersistHandlerBsDelegateRemote.addObject(PersistHandl
      erBsDelegateRemote.java:56)
      12:21:50,694 ERROR [STDERR] at org.jboss.soa.esb.samples.loanbroker.web.LoanBrokerWS.RequestLoan(LoanBrokerWS.j
      ava:66)
      12:21:50,694 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      12:21:50,694 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      12:21:50,694 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav
      a:25)
      12:21:50,694 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
      12:21:50,694 ERROR [STDERR] at org.jboss.ws.server.ServiceEndpointInvokerJSE.invokeServiceEndpoint(ServiceEndpo
      intInvokerJSE.java:95)
      12:21:50,694 ERROR [STDERR] at org.jboss.ws.server.ServiceEndpointInvoker.invoke(ServiceEndpointInvoker.java:11
      8)
      12:21:50,694 ERROR [STDERR] at org.jboss.ws.server.ServiceEndpoint.handleRequest(ServiceEndpoint.java:234)
      12:21:50,694 ERROR [STDERR] at org.jboss.ws.server.ServiceEndpointServlet.doPost(ServiceEndpointServlet.java:12
      0)
      12:21:50,694 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      12:21:50,694 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
      12:21:50,694 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
      erChain.java:252)
      12:21:50,694 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
      java:173)
      12:21:50,694 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:9
      6)
      12:21:50,694 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
      erChain.java:202)
      12:21:50,694 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
      java:173)
      12:21:50,694 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2
      13)
      12:21:50,694 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:1
      78)
      12:21:50,694 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociatio
      nValve.java:175)
      12:21:50,694 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
      12:21:50,694 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      12:21:50,694 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      12:21:50,694 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107
      )
      12:21:50,694 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      12:21:50,694 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
      12:21:50,694 ERROR [STDERR] at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConne
      ction(Http11BaseProtocol.java:664)
      12:21:50,694 ERROR [STDERR] at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:52
      7)
      12:21:50,694 ERROR [STDERR] at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.j
      ava:112)
      12:21:50,694 ERROR [STDERR] at java.lang.Thread.run(Thread.java:595)

      It would seem as if there is a problem with the database definition, but I loaded the schema with the .sql provided.

      Thnx

      Sergio

        • 1. Re: BankLoanBrokerDemo SQL Exception
          Kurt Stam Master

          This seems to be a postgres driver issue. Can you try the one in product/config/lib called pg74.216.jdbc.j2ee.jar?

          --Kurt

          • 2. Re: BankLoanBrokerDemo SQL Exception
            Sergio Moreno Newbie

             

            "kurt.stam@jboss.com" wrote:
            This seems to be a postgres driver issue. Can you try the one in product/config/lib called pg74.216.jdbc.j2ee.jar?

            --Kurt[/quote

            Thanks for the advice Kurt, I did and though it seems to be able to connect to the database I got the following exception:

            14:18:17,399 INFO [STDOUT] -6101458123877306066
            14:18:17,399 INFO [STDOUT] file:/C:/jboss-4.0.4.GA/server/default/tmp/deploy/tmp43549jbossesb-appl.ear-contents/jb
            ossesb-common.jar
            14:18:17,399 INFO [STDOUT] 2006-11-07 14:18:17,399 [http-0.0.0.0-8080-1] INFO org.jboss.soa.esb.services.beans.Per
            sistHandlerBean - org.jboss.soa.esb.services.beans.PersistHandlerBean@888fc9 Created
            14:18:17,399 INFO [STDOUT] 2006-11-07 14:18:17,399 [http-0.0.0.0-8080-1] INFO org.jboss.soa.esb.services.beans.Per
            sistHandlerBean - org.jboss.soa.esb.services.beans.PersistHandlerBean@888fc9 Created
            14:18:17,399 INFO [PersistHandlerBean] org.jboss.soa.esb.services.beans.PersistHandlerBean@888fc9 Created
            14:18:17,415 ERROR [JdbcCleanConn] execQueryWait: Error while executing query
            org.postgresql.util.PSQLException: ERROR: relation "customer_index" does not exist

            at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
            at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
            at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
            at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
            at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
            at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
            at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:233)
            at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)

            at org.jboss.soa.esb.helpers.persist.JdbcCleanConn.execQueryWait(JdbcCleanConn.java:108)
            at org.jboss.soa.esb.helpers.persist.SqlDbTable.initFields(SqlDbTable.java:165)
            at org.jboss.soa.esb.helpers.persist.SqlDbTable.<init>(SqlDbTable.java:54)
            at org.jboss.soa.esb.internal.core.objectstore.DaoIndexTable.<init>(DaoIndexTable.java:68)
            at org.jboss.soa.esb.services.beans.PersistHandlerBean.getDaoIndex(PersistHandlerBean.java:198)
            at org.jboss.soa.esb.services.beans.PersistHandlerBean.doAddSnapshot(PersistHandlerBean.java:311)
            at org.jboss.soa.esb.services.beans.PersistHandlerBean.doAddSnapshot(PersistHandlerBean.java:288)
            at org.jboss.soa.esb.services.beans.PersistHandlerBean.addDTO(PersistHandlerBean.java:167)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:585)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
            at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
            at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInt
            erceptor.java:54)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.tx.BMTInterceptor.handleStateless(BMTInterceptor.java:71)
            at org.jboss.ejb3.tx.BMTInterceptor.invoke(BMTInterceptor.java:131)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:78)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:225)
            at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:55)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.stateless.StatelessRemoteProxy.invoke(StatelessRemoteProxy.java:102)
            at $Proxy85.addDTO(Unknown Source)
            at org.jboss.soa.esb.services.PersistHandlerBsDelegateRemote.addObject(PersistHandlerBsDelegateRemote.java:
            56)
            at org.jboss.soa.esb.samples.loanbroker.web.LoanBrokerWS.RequestLoan(LoanBrokerWS.java:66)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:585)
            at org.jboss.ws.server.ServiceEndpointInvokerJSE.invokeServiceEndpoint(ServiceEndpointInvokerJSE.java:95)
            at org.jboss.ws.server.ServiceEndpointInvoker.invoke(ServiceEndpointInvoker.java:118)
            at org.jboss.ws.server.ServiceEndpoint.handleRequest(ServiceEndpoint.java:234)
            at org.jboss.ws.server.ServiceEndpointServlet.doPost(ServiceEndpointServlet.java:120)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
            at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
            at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
            at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
            at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
            at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol
            .java:664)
            at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
            at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
            at java.lang.Thread.run(Thread.java:595)
            14:18:17,602 ERROR [JdbcCleanConn] execQueryWait: Error while executing query
            org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction
            block

            at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
            at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
            at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
            at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
            at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
            at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
            at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:233)
            at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)

            at org.jboss.soa.esb.helpers.persist.JdbcCleanConn.execQueryWait(JdbcCleanConn.java:108)
            at org.jboss.soa.esb.helpers.persist.SqlDbTable.initFields(SqlDbTable.java:165)
            at org.jboss.soa.esb.helpers.persist.SqlDbTable.<init>(SqlDbTable.java:54)
            at org.jboss.soa.esb.internal.core.objectstore.DaoIndexTable.<init>(DaoIndexTable.java:68)
            at org.jboss.soa.esb.services.beans.PersistHandlerBean.getDaoIndex(PersistHandlerBean.java:198)
            at org.jboss.soa.esb.services.beans.PersistHandlerBean.doAddSnapshot(PersistHandlerBean.java:311)
            at org.jboss.soa.esb.services.beans.PersistHandlerBean.doAddSnapshot(PersistHandlerBean.java:288)
            at org.jboss.soa.esb.services.beans.PersistHandlerBean.addDTO(PersistHandlerBean.java:167)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:585)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
            at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
            at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInt
            erceptor.java:54)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.tx.BMTInterceptor.handleStateless(BMTInterceptor.java:71)
            at org.jboss.ejb3.tx.BMTInterceptor.invoke(BMTInterceptor.java:131)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:78)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:225)
            at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:55)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.stateless.StatelessRemoteProxy.invoke(StatelessRemoteProxy.java:102)
            at $Proxy85.addDTO(Unknown Source)
            at org.jboss.soa.esb.services.PersistHandlerBsDelegateRemote.addObject(PersistHandlerBsDelegateRemote.java:
            56)
            at org.jboss.soa.esb.samples.loanbroker.web.LoanBrokerWS.RequestLoan(LoanBrokerWS.java:66)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:585)
            at org.jboss.ws.server.ServiceEndpointInvokerJSE.invokeServiceEndpoint(ServiceEndpointInvokerJSE.java:95)
            at org.jboss.ws.server.ServiceEndpointInvoker.invoke(ServiceEndpointInvoker.java:118)
            at org.jboss.ws.server.ServiceEndpoint.handleRequest(ServiceEndpoint.java:234)
            at org.jboss.ws.server.ServiceEndpointServlet.doPost(ServiceEndpointServlet.java:120)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
            at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
            at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
            at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
            at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
            at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol
            .java:664)
            at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
            at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
            at java.lang.Thread.run(Thread.java:595)
            14:18:17,789 ERROR [JdbcCleanConn] execQueryWait: Error while executing query
            org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction
            block

            at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
            at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
            at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
            at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
            at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
            at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
            at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:233)
            at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)

            at org.jboss.soa.esb.helpers.persist.JdbcCleanConn.execQueryWait(JdbcCleanConn.java:108)
            at org.jboss.soa.esb.helpers.persist.SqlDbTable.initFields(SqlDbTable.java:165)
            at org.jboss.soa.esb.helpers.persist.SqlDbTable.<init>(SqlDbTable.java:54)
            at org.jboss.soa.esb.internal.core.objectstore.DaoIndexTable.<init>(DaoIndexTable.java:68)
            at org.jboss.soa.esb.services.beans.PersistHandlerBean.getDaoIndex(PersistHandlerBean.java:198)
            at org.jboss.soa.esb.services.beans.PersistHandlerBean.doAddSnapshot(PersistHandlerBean.java:311)
            at org.jboss.soa.esb.services.beans.PersistHandlerBean.doAddSnapshot(PersistHandlerBean.java:288)
            at org.jboss.soa.esb.services.beans.PersistHandlerBean.addDTO(PersistHandlerBean.java:167)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:585)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
            at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
            at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInt
            erceptor.java:54)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.tx.BMTInterceptor.handleStateless(BMTInterceptor.java:71)
            at org.jboss.ejb3.tx.BMTInterceptor.invoke(BMTInterceptor.java:131)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:78)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:225)
            at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:55)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.stateless.StatelessRemoteProxy.invoke(StatelessRemoteProxy.java:102)
            at $Proxy85.addDTO(Unknown Source)
            at org.jboss.soa.esb.services.PersistHandlerBsDelegateRemote.addObject(PersistHandlerBsDelegateRemote.java:
            56)
            at org.jboss.soa.esb.samples.loanbroker.web.LoanBrokerWS.RequestLoan(LoanBrokerWS.java:66)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:585)
            at org.jboss.ws.server.ServiceEndpointInvokerJSE.invokeServiceEndpoint(ServiceEndpointInvokerJSE.java:95)
            at org.jboss.ws.server.ServiceEndpointInvoker.invoke(ServiceEndpointInvoker.java:118)
            at org.jboss.ws.server.ServiceEndpoint.handleRequest(ServiceEndpoint.java:234)
            at org.jboss.ws.server.ServiceEndpointServlet.doPost(ServiceEndpointServlet.java:120)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
            at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
            at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
            at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
            at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
            at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol
            .java:664)
            at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
            at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
            at java.lang.Thread.run(Thread.java:595)
            14:18:17,976 ERROR [JdbcCleanConn] execQueryWait() FAILED
            org.postgresql.util.PSQLException: ERROR: relation "customer_index" does not exist

            at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
            at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
            at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
            at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
            at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
            at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
            at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:233)
            at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)

            at org.jboss.soa.esb.helpers.persist.JdbcCleanConn.execQueryWait(JdbcCleanConn.java:108)
            at org.jboss.soa.esb.helpers.persist.SqlDbTable.initFields(SqlDbTable.java:165)
            at org.jboss.soa.esb.helpers.persist.SqlDbTable.<init>(SqlDbTable.java:54)
            at org.jboss.soa.esb.internal.core.objectstore.DaoIndexTable.<init>(DaoIndexTable.java:68)
            at org.jboss.soa.esb.services.beans.PersistHandlerBean.getDaoIndex(PersistHandlerBean.java:198)
            at org.jboss.soa.esb.services.beans.PersistHandlerBean.doAddSnapshot(PersistHandlerBean.java:311)
            at org.jboss.soa.esb.services.beans.PersistHandlerBean.doAddSnapshot(PersistHandlerBean.java:288)
            at org.jboss.soa.esb.services.beans.PersistHandlerBean.addDTO(PersistHandlerBean.java:167)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:585)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
            at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
            at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInt
            erceptor.java:54)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.tx.BMTInterceptor.handleStateless(BMTInterceptor.java:71)
            at org.jboss.ejb3.tx.BMTInterceptor.invoke(BMTInterceptor.java:131)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:78)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:225)
            at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:55)
            at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            at org.jboss.ejb3.stateless.StatelessRemoteProxy.invoke(StatelessRemoteProxy.java:102)
            at $Proxy85.addDTO(Unknown Source)
            at org.jboss.soa.esb.services.PersistHandlerBsDelegateRemote.addObject(PersistHandlerBsDelegateRemote.java:
            56)
            at org.jboss.soa.esb.samples.loanbroker.web.LoanBrokerWS.RequestLoan(LoanBrokerWS.java:66)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:585)
            at org.jboss.ws.server.ServiceEndpointInvokerJSE.invokeServiceEndpoint(ServiceEndpointInvokerJSE.java:95)
            at org.jboss.ws.server.ServiceEndpointInvoker.invoke(ServiceEndpointInvoker.java:118)
            at org.jboss.ws.server.ServiceEndpoint.handleRequest(ServiceEndpoint.java:234)
            at org.jboss.ws.server.ServiceEndpointServlet.doPost(ServiceEndpointServlet.java:120)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
            at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
            at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
            at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
            at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
            at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol
            .java:664)
            at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
            at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
            at java.lang.Thread.run(Thread.java:595)
            14:18:17,976 ERROR [STDERR] org.postgresql.util.PSQLException: ERROR: relation "customer_index" does not exist
            14:18:17,976 ERROR [STDERR] at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
            14:18:17,976 ERROR [STDERR] at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
            14:18:17,976 ERROR [STDERR] at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
            14:18:17,976 ERROR [STDERR] at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
            14:18:17,976 ERROR [STDERR] at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:
            517)
            14:18:17,976 ERROR [STDERR] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:
            50)
            14:18:17,976 ERROR [STDERR] at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.
            java:233)
            14:18:17,976 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPre
            paredStatement.java:236)
            14:18:17,976 ERROR [STDERR] at org.jboss.soa.esb.helpers.persist.JdbcCleanConn.execQueryWait(JdbcCleanConn.java
            :108)
            14:18:17,976 ERROR [STDERR] at org.jboss.soa.esb.helpers.persist.SqlDbTable.initFields(SqlDbTable.java:165)
            14:18:17,976 ERROR [STDERR] at org.jboss.soa.esb.helpers.persist.SqlDbTable.<init>(SqlDbTable.java:54)
            14:18:17,976 ERROR [STDERR] at org.jboss.soa.esb.internal.core.objectstore.DaoIndexTable.<init>(DaoIndexTable.j
            ava:68)
            14:18:17,976 ERROR [STDERR] at org.jboss.soa.esb.services.beans.PersistHandlerBean.getDaoIndex(PersistHandlerBe
            an.java:198)
            14:18:17,976 ERROR [STDERR] at org.jboss.soa.esb.services.beans.PersistHandlerBean.doAddSnapshot(PersistHandler
            Bean.java:311)
            14:18:17,976 ERROR [STDERR] at org.jboss.soa.esb.services.beans.PersistHandlerBean.doAddSnapshot(PersistHandler
            Bean.java:288)
            14:18:17,976 ERROR [STDERR] at org.jboss.soa.esb.services.beans.PersistHandlerBean.addDTO(PersistHandlerBean.ja
            va:167)
            14:18:17,976 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            14:18:17,976 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            14:18:17,976 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav
            a:25)
            14:18:17,976 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
            14:18:17,976 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
            14:18:17,976 ERROR [STDERR] at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.j
            ava:166)
            14:18:17,976 ERROR [STDERR] at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsIn
            terceptor.java:63)
            14:18:17,976 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            14:18:17,976 ERROR [STDERR] at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(Transacti
            onScopedEntityManagerInterceptor.java:54)
            14:18:17,976 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            14:18:17,976 ERROR [STDERR] at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.
            java:47)
            14:18:17,976 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            14:18:17,976 ERROR [STDERR] at org.jboss.ejb3.tx.BMTInterceptor.handleStateless(BMTInterceptor.java:71)
            14:18:17,976 ERROR [STDERR] at org.jboss.ejb3.tx.BMTInterceptor.invoke(BMTInterceptor.java:131)
            14:18:17,976 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            14:18:17,976 ERROR [STDERR] at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.ja
            va:76)
            14:18:17,976 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            14:18:17,976 ERROR [STDERR] at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceIn
            terceptor.java:62)
            14:18:17,976 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            14:18:17,976 ERROR [STDERR] at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterc
            eptor.java:78)
            14:18:17,976 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            14:18:17,976 ERROR [STDERR] at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:4
            7)
            14:18:17,976 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            14:18:17,976 ERROR [STDERR] at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousIntercept
            or.java:106)
            14:18:17,976 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            14:18:17,976 ERROR [STDERR] at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.jav
            a:225)
            14:18:17,976 ERROR [STDERR] at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:55)
            14:18:17,976 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            14:18:17,976 ERROR [STDERR] at org.jboss.ejb3.stateless.StatelessRemoteProxy.invoke(StatelessRemoteProxy.java:1
            02)
            14:18:17,976 ERROR [STDERR] at $Proxy85.addDTO(Unknown Source)
            14:18:17,976 ERROR [STDERR] at org.jboss.soa.esb.services.PersistHandlerBsDelegateRemote.addObject(PersistHandl
            erBsDelegateRemote.java:56)
            14:18:17,976 ERROR [STDERR] at org.jboss.soa.esb.samples.loanbroker.web.LoanBrokerWS.RequestLoan(LoanBrokerWS.j
            ava:66)
            14:18:17,976 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            14:18:17,992 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            14:18:17,992 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav
            a:25)
            14:18:17,992 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
            14:18:17,992 ERROR [STDERR] at org.jboss.ws.server.ServiceEndpointInvokerJSE.invokeServiceEndpoint(ServiceEndpo
            intInvokerJSE.java:95)
            14:18:17,992 ERROR [STDERR] at org.jboss.ws.server.ServiceEndpointInvoker.invoke(ServiceEndpointInvoker.java:11
            8)
            14:18:17,992 ERROR [STDERR] at org.jboss.ws.server.ServiceEndpoint.handleRequest(ServiceEndpoint.java:234)
            14:18:17,992 ERROR [STDERR] at org.jboss.ws.server.ServiceEndpointServlet.doPost(ServiceEndpointServlet.java:12
            0)
            14:18:17,992 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
            14:18:17,992 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
            14:18:17,992 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
            erChain.java:252)
            14:18:17,992 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
            java:173)
            14:18:17,992 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:9
            6)
            14:18:17,992 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
            erChain.java:202)
            14:18:17,992 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
            java:173)
            14:18:17,992 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2
            13)
            14:18:17,992 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:1
            78)
            14:18:17,992 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociatio
            nValve.java:175)
            14:18:17,992 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
            14:18:17,992 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
            14:18:17,992 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
            14:18:17,992 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107
            )
            14:18:17,992 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
            14:18:17,992 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
            14:18:17,992 ERROR [STDERR] at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConne
            ction(Http11BaseProtocol.java:664)
            14:18:17,992 ERROR [STDERR] at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:52
            7)
            14:18:17,992 ERROR [STDERR] at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.j
            ava:112)
            14:18:17,992 ERROR [STDERR] at java.lang.Thread.run(Thread.java:595)

            I know it's got something to do with the ObjStore.xml, but i don't know if I have to define the table myself, because from the programmers guide it is the ObjStore file that sets the properties.
            this is the property configuration

            #
            # Object Store Settings
            #
            org.jboss.soa.esb.objStore.configfile=file:/C:/jbossesb-4.0Beta1MP1/docs/samples/trailblazer/bankloanbrokerdemo/conf/ObjStore.xml

            thnx for any replies!
            Sergio


            • 3. Re: BankLoanBrokerDemo SQL Exception
              Daniel Brum Novice

              Not sure why your schema didn't get properly created, but you are missing this table:

              CREATE TABLE public.customer_index (
               uid int8 NOT NULL,
               stamp int8 NULL,
               latest_snap_uid int8 NULL,
               latest_snap_date text NULL,
               name text NULL,
               phone text NULL,
               address text NULL,
               PRIMARY KEY(uid)
              );
              


              There should be a file called JBossESB-DB-postgres.sql in your download, I can't remember the location now for the Beta1.

              • 4. Re: BankLoanBrokerDemo SQL Exception
                Sergio Moreno Newbie

                Kurt thank you very much it works prefect now!

                The table you described is not included in the bossesb-4.0Beta1MP1\docs\Install\database\JBossESB-DB-postgres.sql file that is why it wasn't created.
                Thanks again!
                Sergio