Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 7th, 2012  |  syntax: None  |  size: 5.58 KB  |  hits: 26  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. org.hibernate.exception.GenericJDBCException: could not execute query
  2. org.hibernate.exception.GenericJDBCException: could not execute query
  3.     at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
  4.     at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
  5.     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
  6.     at org.hibernate.loader.Loader.doList(Loader.java:2545)
  7.     at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
  8.     at org.hibernate.loader.Loader.list(Loader.java:2271)
  9.     at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
  10.     at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
  11.     at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
  12.     at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
  13.     at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
  14.     at com.myCompany.Query.myMethod(Query.java:99)
  15.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  16.     at java.lang.reflect.Method.invoke(Method.java:597)
  17.     at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
  18.     at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
  19.     at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
  20.     at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:288)
  21.     at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
  22.     at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
  23.     at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
  24.     at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1469)
  25.     at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1400)
  26.     at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1349)
  27.     at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1339)
  28.     at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)
  29.     at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:537)
  30.     at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:699)
  31.     at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
  32.     at org.ebayopensource.ginger.server.internal.container.MessageProcessor.processRequest(MessageProcessor.java:93)
  33.     at org.ebayopensource.ginger.server.container.GingerServletShell.service(GingerServletShell.java:80)
  34.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  35.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  36.     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  37.     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
  38.     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
  39.     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  40.     at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
  41.     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  42.     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
  43.     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
  44.     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
  45.     at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
  46.     at java.lang.Thread.run(Thread.java:662)
  47. Caused by: java.sql.SQLException: Closed Connection
  48.     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
  49.     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
  50.     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
  51.     at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:864)
  52.     at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:783)
  53.     at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
  54.     at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
  55.     at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
  56.     at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
  57.     at org.hibernate.loader.Loader.doQuery(Loader.java:801)
  58.     at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
  59.     at org.hibernate.loader.Loader.doList(Loader.java:2542)
  60.        
  61. BasicDataSource ds = new BasicDataSource();
  62. ds.setDriverClassName("oracle.jdbc.driver.OracleDriver");
  63. ds.setUsername("scott");
  64. ds.setPassword("tiger");
  65. ds.setValidationQuery("SELECT 1"); // this is database specific
  66. ds.setTestWhileIdle(true); // test the connections every so often
  67. ds.setUrl(connectURI);
  68. ...
  69. while (!shutdown) {
  70.     Connection conn = dataSource.getConnection();
  71.     Statement stmt = conn.createStatement();
  72.     ...
  73.     stmt.close();
  74.     // this returns the connection back to the pool instead of really closing
  75.     // the connection
  76.     conn.close();
  77. }
create a new version of this paste RAW Paste Data