Subject: [sama]: p.i.s.s.w.IPWebServiceSoapImpl - Erro ao invocar getAllServicoByUtente
From: [email-masked]
To: [email-masked]
Date: Tue, 8 May 2012 11:09:39 +0100 (WEST)

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
  <head>
    <title>Logback Log Messages</title>
<style  type="text/css">
table { margin-left: 2em; margin-right: 2em; border-left: 2px solid #AAA; }
TR.even { background: #FFFFFF; }
TR.odd { background: #EAEAEA; }
TR.warn TD.Level, TR.error TD.Level, TR.fatal TD.Level {font-weight: bold; color: #FF4040 }
TD { padding-right: 1ex; padding-left: 1ex; border-right: 2px solid #AAA; }
TD.Time, TD.Date { text-align: right; font-family: courier, monospace; font-size: smaller; }
TD.Thread { text-align: left; }
TD.Level { text-align: right; }
TD.Logger { text-align: left; }
TR.header { background: #596ED5; color: #FFF; font-weight: bold; font-size: larger; }
TD.Exception { background: #A2AEE8; font-family: courier, monospace;}
</style>

  </head>
<body>
<hr/>
<p>Log session start time Tue May 08 11:09:26 WEST 2012</p><p></p>

<table cellspacing="0">
<tr class="header">
<td class="Date">Date</td>
<td class="Thread">Thread</td>
<td class="Level">Level</td>
<td class="Logger">Logger</td>
<td class="MDC">MDC</td>
<td class="Message">Message</td>
</tr>

<tr class="warn even">
<td class="Date">2012-05-08 11:07:07,300</td>
<td class="Thread">qtp239887136-27</td>
<td class="Level">WARN</td>
<td class="Logger">org.apache.cxf.phase.PhaseInterceptorChain</td>
<td class="MDC"></td>
<td class="Message">Application {http://portal.apnor.pt/DataObjectModel}IPWebService#{http://portal.apnor.pt/DataObjectModel}GetAllServicoByUtente has thrown exception, unwinding now</td>
</tr>
<tr><td class="Exception" colspan="6">org.apache.cxf.interceptor.Fault: java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement

<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.apache.cxf.service.invoker.AbstractInvoker.createFault(AbstractInvoker.java:155)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.createFault(AbstractJAXWSMethodInvoker.java:86)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:121)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:64)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:75)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at java.util.concurrent.FutureTask.run(FutureTask.java:138)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:123)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:207)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:213)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:193)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:128)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:185)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:108)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:164)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1332)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:477)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:524)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1031)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:965)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:250)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:149)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:111)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.server.Server.handle(Server.java:348)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:452)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:894)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:948)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:851)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:77)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:606)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:46)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:603)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:538)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Thread.java:662)
<br />Caused by: java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement

<br />&nbsp;&nbsp;&nbsp;&nbsp;at pt.ipb.sama.server.ws.IPWebServiceSoapImpl.getAllServicoByUtente(IPWebServiceSoapImpl.java:370)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:173)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:89)
<br />&nbsp;&nbsp;&nbsp;&nbsp;	... 49 common frames omitted
<br />Caused by: java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement

<br />&nbsp;&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at com.jolbox.bonecp.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:172)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at pt.ipb.sama.server.ws.servicos.Servicos.getAllServicoByUtente(Servicos.java:47)
<br />&nbsp;&nbsp;&nbsp;&nbsp;at pt.ipb.sama.server.ws.IPWebServiceSoapImpl.getAllServicoByUtente(IPWebServiceSoapImpl.java:367)
<br />&nbsp;&nbsp;&nbsp;&nbsp;	... 55 common frames omitted
</td></tr>
<tr class="error odd">
<td class="Date">2012-05-08 11:09:26,546</td>
<td class="Thread">qtp239887136-25</td>
<td class="Level">ERROR</td>
<td class="Logger">pt.ipb.sama.server.ws.IPWebServiceSoapImpl</td>
<td class="MDC"></td>
<td class="Message">Erro ao invocar getAllServicoByUtente</td>
</tr>
</table>
</body></html>