Project

General

Custom queries

Profile

Actions

Bug #790

closed

java.sql.SQLException: Operation not allowed after ResultSet closed

Added by Lequeux Olivier almost 15 years ago. Updated over 12 years ago.

Status:
Rejected
Priority:
High
Assigned To:
Category:
-
Target version:
-
Start date:
06/24/2010
Due date:
% Done:

0%

Estimated time:

Description

DESCRIPTION :

Certaines vues, à priori celles qui ont un ou plusieurs paramètres, ne sont plus accessibles via le client SOAP du portail et nous font remonter un exception.
- On note qu'un update de la page web appelante suffit le plus souvent à rafraîchir la vue correctement et à récupérer les données.
- On note aussi que le test sur la modification du plugin avec un rajout d'un Result Close potentiellement manquant à eu
pour effet de ne plus rafraîchir les données dans la BDD.

LAVOISIER : http://cclavoisierfr.in2p3.fr:9000/LavoisierService/view/index

INDICE : http://eswars.blogspot.com/2006/03/javasqlsqlexception-operation-not.html (synchronize)

STACK TRACE :

[2010-06-18 09:33:21,576]  WARN fr.in2p3.lavoisier.adapter.AggregatorAdapter : Failed to aggregate view: site_nagios[@name='INFN-NAPOLI-ARGO']
  59911 fr.in2p3.lavoisier.engine.SerializationException: Exception raised for view 'site_nagios'
  59912         at fr.in2p3.lavoisier.engine.view.InvokedDataView.getAsElement(InvokedDataView.java:70)
  59913         at fr.in2p3.lavoisier.adapter.AggregatorAdapter.writeToOutputStream(AggregatorAdapter.java:75)
  59914         at fr.in2p3.lavoisier.engine.AdapterReader.getAndValidateInputStreamFromStreamAdapter(AdapterReader.java:50)
  59915         at fr.in2p3.lavoisier.engine.tree.OnDiskInvokedTree.buildRecursive(OnDiskInvokedTree.java:36)
  59916         at fr.in2p3.lavoisier.engine.tree.OnDiskInvokedTree.build(OnDiskInvokedTree.java:24)
  59917         at fr.in2p3.lavoisier.engine.view.InvokedDataView.generateViewAsStream(InvokedDataView.java:119)
  59918         at fr.in2p3.lavoisier.engine.view.InvokedDataView.getAsSource(InvokedDataView.java:88)
  59919         at fr.in2p3.lavoisier.engine.view.DataView.getAsString(DataView.java:227)
  59920         at fr.in2p3.lavoisier.LavoisierEngine.getViewAsString(LavoisierEngine.java:131)
  59921         at fr.in2p3.lavoisier.service.impl.LavoisierServiceImpl.getView(LavoisierServiceImpl.java:177)
  59922         at sun.reflect.GeneratedMethodAccessor17.invoke(Unknown Source)
  59923         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  59924         at java.lang.reflect.Method.invoke(Method.java:597)
  59925         at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:136)
  59926         at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:82)
  59927         at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:54)
  59928         at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:68)
  59929         at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:56)
  59930         at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)
  59931         at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:92)
  59932         at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:220)
  59933         at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:78)
  59934         at org.apache.cxf.transport.http_jetty.JettyHTTPDestination.serviceRequest(JettyHTTPDestination.java:278)
  59935         at org.apache.cxf.transport.http_jetty.JettyHTTPDestination.doService(JettyHTTPDestination.java:252)
  59936         at org.apache.cxf.transport.http_jetty.JettyHTTPHandler.handle(JettyHTTPHandler.java:70)
  59937         at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)
  59938         at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:206)
  59939         at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
  59940         at org.mortbay.jetty.Server.handle(Server.java:324)
  59941         at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
  59942         at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:842)
  59943         at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648)
  59944         at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
  59945         at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
  59946         at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
  59947         at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450)
  59948 Caused by: fr.in2p3.lavoisier.engine.SerializationException: Exception raised for view 'nagios_notification'
  59949         at fr.in2p3.lavoisier.engine.view.InvokedDataView.getAsSource(InvokedDataView.java:95)
  59950         at fr.in2p3.lavoisier.engine.tree.DependenciesMapFactory.getViewContent(DependenciesMapFactory.java:52)
  59951         at fr.in2p3.lavoisier.engine.tree.DependenciesMapFactory.createDependenciesMap(DependenciesMapFactory.java:41)
  59952         at fr.in2p3.lavoisier.engine.tree.InMemoryInvokedTree.build(InMemoryInvokedTree.java:34)
  59953         at fr.in2p3.lavoisier.engine.view.InvokedDataView.generateViewAsDOM(InvokedDataView.java:106)
  59954         at fr.in2p3.lavoisier.engine.view.InvokedDataView.getAsElement(InvokedDataView.java:67)
  59955         ... 35 more
  59956 Caused by: java.sql.SQLException: Operation not allowed after ResultSet closed
  59957         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
  59958         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
  59959         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
  59960         at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:768)
  59961         at com.mysql.jdbc.ResultSetImpl.checkRowPos(ResultSetImpl.java:812)
  59962         at com.mysql.jdbc.ResultSetImpl.getStringInternal(ResultSetImpl.java:5528)
  59963         at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5448)
  59964         at fr.in2p3.lavoisier.adapter.DatabaseAdapter.writeToOutputStream(DatabaseAdapter.java:189)
  59965         at fr.in2p3.lavoisier.engine.AdapterReader.getAndValidateInputStreamFromStreamAdapter(AdapterReader.java:50)
  59966         at fr.in2p3.lavoisier.engine.tree.OnDiskInvokedTree.buildRecursive(OnDiskInvokedTree.java:36)
  59967         at fr.in2p3.lavoisier.engine.tree.OnDiskInvokedTree.build(OnDiskInvokedTree.java:24)
  59968         at fr.in2p3.lavoisier.engine.view.InvokedDataView.generateViewAsStream(InvokedDataView.java:119)
  59969         at fr.in2p3.lavoisier.engine.view.InvokedDataView.getAsSource(InvokedDataView.java:88)
  59970         ... 40 more 

Actions #1

Updated by Reynaud Sylvain over 12 years ago

  • Status changed from New to Rejected

Lavoisier 1.x is not supported anymore.

Actions

Also available in: Atom PDF