com.hp.hpl.jena.sdb.sql.SDBExceptionSQL: SQLException in executing SQL statement

Sakai JIRA | Brian Caruso | 3 years ago
  1. 0

    I cannot create a new classgroup. I deployed and started a vivo system, logged in as root, created a new class (that worked) attempted to create a new classgroup called "newclassgroup" with rank 9 and got an error on the form that said "SQLException in executing SQL statement" In the logs there is a message about DB connections: 2013-10-04 10:54:39,158 WARN [QueryIteratorCheck] Open iterator: QueryIterTriplePattern$TripleMapper/164085 2013-10-04 10:54:39,161 ERROR [OperationController] edu.cornell.mannlib.vedit.controller.OperationController encountered exception performing edit action 2013-10-04 10:54:39,161 ERROR [OperationController] com.hp.hpl.jena.sdb.sql.SDBExceptionSQL: SQLException in executing SQL statement com.hp.hpl.jena.sdb.sql.SDBExceptionSQL: SQLException in executing SQL statement at com.hp.hpl.jena.sdb.compiler.SDB_QC.exec(SDB_QC.java:72) at com.hp.hpl.jena.sdb.compiler.OpSQL.exec(OpSQL.java:53) at com.hp.hpl.jena.sdb.engine.QueryEngineSDB.eval(QueryEngineSDB.java:129) at com.hp.hpl.jena.sparql.engine.QueryEngineBase.evaluate(QueryEngineBase.java:138) at com.hp.hpl.jena.sparql.engine.QueryEngineBase.createPlan(QueryEngineBase.java:109) at com.hp.hpl.jena.sparql.engine.QueryEngineBase.getPlan(QueryEngineBase.java:97) at com.hp.hpl.jena.sdb.engine.QueryEngineSDB$QueryEngineFactorySDB.create(QueryEngineSDB.java:154) at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.getPlan(QueryExecutionBase.java:266) at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.startQueryIterator(QueryExecutionBase.java:243) at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.execResultSet(QueryExecutionBase.java:248) at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.execSelect(QueryExecutionBase.java:94) at edu.cornell.mannlib.vitro.webapp.rdfservice.impl.jena.RDFServiceJena.sparqlSelectQuery(RDFServiceJena.java:343) at edu.cornell.mannlib.vitro.webapp.rdfservice.filter.LanguageFilteringRDFService.sparqlSelectQuery(LanguageFilteringRDFService.java:163) at edu.cornell.mannlib.vitro.webapp.dao.jena.RDFServiceGraph.execSelect(RDFServiceGraph.java:395) at edu.cornell.mannlib.vitro.webapp.dao.jena.RDFServiceGraph.find(RDFServiceGraph.java:254) at edu.cornell.mannlib.vitro.webapp.dao.jena.RDFServiceGraph.find(RDFServiceGraph.java:186) at com.hp.hpl.jena.graph.compose.MultiUnion.singleGraphFind(MultiUnion.java:175) at com.hp.hpl.jena.graph.compose.MultiUnion.graphBaseFind(MultiUnion.java:166) at com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:240) at com.hp.hpl.jena.graph.impl.GraphBase.graphBaseFind(GraphBase.java:260) at com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:257) at com.hp.hpl.jena.sparql.engine.iterator.QueryIterTriplePattern$TripleMapper.<init>(QueryIterTriplePattern.java:67) at com.hp.hpl.jena.sparql.engine.iterator.QueryIterTriplePattern.nextStage(QueryIterTriplePattern.java:41) at com.hp.hpl.jena.sparql.engine.iterator.QueryIterRepeatApply.makeNextStage(QueryIterRepeatApply.java:91) at com.hp.hpl.jena.sparql.engine.iterator.QueryIterRepeatApply.hasNextBinding(QueryIterRepeatApply.java:52) at com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:66) at com.hp.hpl.jena.sparql.engine.iterator.QueryIterBlockTriples.hasNextBinding(QueryIterBlockTriples.java:53) at com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:66) at com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorWrapper.hasNextBinding(QueryIteratorWrapper.java:28) at com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:66) at com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorWrapper.hasNextBinding(QueryIteratorWrapper.java:28) at com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:66) at com.hp.hpl.jena.sparql.engine.ResultSetStream.hasNext(ResultSetStream.java:57) at com.hp.hpl.jena.sparql.resultset.ResultSetApply.apply(ResultSetApply.java:29) at com.hp.hpl.jena.sparql.resultset.JSONOutput.format(JSONOutput.java:23) at com.hp.hpl.jena.query.ResultSetFormatter.outputAsJSON(ResultSetFormatter.java:542) at edu.cornell.mannlib.vitro.webapp.rdfservice.impl.jena.RDFServiceJena.sparqlSelectQuery(RDFServiceJena.java:353) at edu.cornell.mannlib.vitro.webapp.rdfservice.filter.LanguageFilteringRDFService.sparqlSelectQuery(LanguageFilteringRDFService.java:163) at edu.cornell.mannlib.vitro.webapp.dao.jena.RDFServiceGraph.execSelect(RDFServiceGraph.java:395) at edu.cornell.mannlib.vitro.webapp.dao.jena.RDFServiceGraph.find(RDFServiceGraph.java:254) at edu.cornell.mannlib.vitro.webapp.dao.jena.RDFServiceGraph.find(RDFServiceGraph.java:186) at com.hp.hpl.jena.graph.compose.MultiUnion.singleGraphFind(MultiUnion.java:175) at com.hp.hpl.jena.graph.compose.MultiUnion.graphBaseFind(MultiUnion.java:166) at com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:240) at com.hp.hpl.jena.graph.compose.Union.graphBaseFind(Union.java:53) at com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:240) at com.hp.hpl.jena.graph.compose.MultiUnion.singleGraphFind(MultiUnion.java:175) at com.hp.hpl.jena.graph.compose.MultiUnion.graphBaseFind(MultiUnion.java:166) at com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:240) at com.hp.hpl.jena.graph.impl.GraphBase.graphBaseFind(GraphBase.java:260) at com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:257) at com.hp.hpl.jena.rdf.model.impl.ModelCom.listStatements(ModelCom.java:378) at com.hp.hpl.jena.rdf.model.impl.ModelCom.listStatements(ModelCom.java:383) at edu.cornell.mannlib.vitro.webapp.utils.jena.URIUtils.hasExistingURI(URIUtils.java:26) at edu.cornell.mannlib.vitro.webapp.dao.jena.WebappDaoFactoryJena.hasExistingURI(WebappDaoFactoryJena.java:209) at edu.cornell.mannlib.vitro.webapp.dao.jena.WebappDaoFactoryJena.checkURI(WebappDaoFactoryJena.java:190) at edu.cornell.mannlib.vitro.webapp.dao.jena.WebappDaoFactoryJena.checkURI(WebappDaoFactoryJena.java:174) at edu.cornell.mannlib.vitro.webapp.dao.jena.IndividualDaoJena.getUnusedURI(IndividualDaoJena.java:667) at edu.cornell.mannlib.vitro.webapp.dao.jena.IndividualDaoJena.insertNewIndividual(IndividualDaoJena.java:210) at edu.cornell.mannlib.vitro.webapp.dao.jena.IndividualDaoJena.insertNewIndividualWebapp(IndividualDaoJena.java:201) at edu.cornell.mannlib.vitro.webapp.dao.jena.IndividualDaoJena.insertNewIndividual(IndividualDaoJena.java:196) at edu.cornell.mannlib.vitro.webapp.dao.jena.VClassGroupDaoJena.insertNewVClassGroup(VClassGroupDaoJena.java:213) at edu.cornell.mannlib.vitro.webapp.dao.jena.VClassGroupDaoJena.insertNewVClassGroup(VClassGroupDaoJena.java:185) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at edu.cornell.mannlib.vedit.controller.OperationController.performEdit(OperationController.java:457) at edu.cornell.mannlib.vedit.controller.OperationController.doPost(OperationController.java:118) at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at edu.cornell.mannlib.vitro.webapp.controller.VitroHttpServlet.service(VitroHttpServlet.java:65) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at edu.cornell.mannlib.vitro.webapp.filters.PageRoutingFilter.doNonDisplayPage(PageRoutingFilter.java:110) at edu.cornell.mannlib.vitro.webapp.filters.PageRoutingFilter.doFilter(PageRoutingFilter.java:101) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at edu.cornell.mannlib.vitro.webapp.filters.RequestModelsPrep.doFilter(RequestModelsPrep.java:106) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at edu.cornell.mannlib.vitro.webapp.filters.URLRewriterFilter.doFilter(URLRewriterFilter.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at edu.cornell.mannlib.vitro.webapp.filters.JSessionStripFilter.doFilter(JSessionStripFilter.java:60) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at edu.cornell.mannlib.vitro.webapp.filters.CachingResponseFilter.produceBasicResponse(CachingResponseFilter.java:322) at edu.cornell.mannlib.vitro.webapp.filters.CachingResponseFilter.doFilter(CachingResponseFilter.java:115) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at edu.cornell.mannlib.vitro.webapp.i18n.selection.LocaleSelectionFilter.doFilter(LocaleSelectionFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at edu.cornell.mannlib.vitro.webapp.filters.CharsetEncodingFilter.doFilter(CharsetEncodingFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at edu.cornell.mannlib.vitro.webapp.filters.SessionTimeoutLimitingFilter.doFilter(SessionTimeoutLimitingFilter.java:39) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at edu.cornell.mannlib.vitro.webapp.filters.StartupStatusDisplayFilter.doFilter(StartupStatusDisplayFilter.java:64) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:498) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:562) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:394) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:243) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:188) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:724) Caused by: java.sql.SQLException: You can't operate on a closed Connection!!! at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106) at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65) at com.mchange.v2.c3p0.impl.NewProxyConnection.createStatement(NewProxyConnection.java:191) at com.hp.hpl.jena.sdb.sql.SDBConnection.execQuery(SDBConnection.java:107) at com.hp.hpl.jena.sdb.compiler.SDB_QC.exec(SDB_QC.java:60) ... 116 more Caused by: java.lang.NullPointerException at com.mchange.v2.c3p0.impl.NewProxyConnection.createStatement(NewProxyConnection.java:183) ... 118 more

    Sakai JIRA | 3 years ago | Brian Caruso
    com.hp.hpl.jena.sdb.sql.SDBExceptionSQL: SQLException in executing SQL statement
  2. 0

    I cannot create a new classgroup. I deployed and started a vivo system, logged in as root, created a new class (that worked) attempted to create a new classgroup called "newclassgroup" with rank 9 and got an error on the form that said "SQLException in executing SQL statement" In the logs there is a message about DB connections: 2013-10-04 10:54:39,158 WARN [QueryIteratorCheck] Open iterator: QueryIterTriplePattern$TripleMapper/164085 2013-10-04 10:54:39,161 ERROR [OperationController] edu.cornell.mannlib.vedit.controller.OperationController encountered exception performing edit action 2013-10-04 10:54:39,161 ERROR [OperationController] com.hp.hpl.jena.sdb.sql.SDBExceptionSQL: SQLException in executing SQL statement com.hp.hpl.jena.sdb.sql.SDBExceptionSQL: SQLException in executing SQL statement at com.hp.hpl.jena.sdb.compiler.SDB_QC.exec(SDB_QC.java:72) at com.hp.hpl.jena.sdb.compiler.OpSQL.exec(OpSQL.java:53) at com.hp.hpl.jena.sdb.engine.QueryEngineSDB.eval(QueryEngineSDB.java:129) at com.hp.hpl.jena.sparql.engine.QueryEngineBase.evaluate(QueryEngineBase.java:138) at com.hp.hpl.jena.sparql.engine.QueryEngineBase.createPlan(QueryEngineBase.java:109) at com.hp.hpl.jena.sparql.engine.QueryEngineBase.getPlan(QueryEngineBase.java:97) at com.hp.hpl.jena.sdb.engine.QueryEngineSDB$QueryEngineFactorySDB.create(QueryEngineSDB.java:154) at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.getPlan(QueryExecutionBase.java:266) at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.startQueryIterator(QueryExecutionBase.java:243) at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.execResultSet(QueryExecutionBase.java:248) at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.execSelect(QueryExecutionBase.java:94) at edu.cornell.mannlib.vitro.webapp.rdfservice.impl.jena.RDFServiceJena.sparqlSelectQuery(RDFServiceJena.java:343) at edu.cornell.mannlib.vitro.webapp.rdfservice.filter.LanguageFilteringRDFService.sparqlSelectQuery(LanguageFilteringRDFService.java:163) at edu.cornell.mannlib.vitro.webapp.dao.jena.RDFServiceGraph.execSelect(RDFServiceGraph.java:395) at edu.cornell.mannlib.vitro.webapp.dao.jena.RDFServiceGraph.find(RDFServiceGraph.java:254) at edu.cornell.mannlib.vitro.webapp.dao.jena.RDFServiceGraph.find(RDFServiceGraph.java:186) at com.hp.hpl.jena.graph.compose.MultiUnion.singleGraphFind(MultiUnion.java:175) at com.hp.hpl.jena.graph.compose.MultiUnion.graphBaseFind(MultiUnion.java:166) at com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:240) at com.hp.hpl.jena.graph.impl.GraphBase.graphBaseFind(GraphBase.java:260) at com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:257) at com.hp.hpl.jena.sparql.engine.iterator.QueryIterTriplePattern$TripleMapper.<init>(QueryIterTriplePattern.java:67) at com.hp.hpl.jena.sparql.engine.iterator.QueryIterTriplePattern.nextStage(QueryIterTriplePattern.java:41) at com.hp.hpl.jena.sparql.engine.iterator.QueryIterRepeatApply.makeNextStage(QueryIterRepeatApply.java:91) at com.hp.hpl.jena.sparql.engine.iterator.QueryIterRepeatApply.hasNextBinding(QueryIterRepeatApply.java:52) at com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:66) at com.hp.hpl.jena.sparql.engine.iterator.QueryIterBlockTriples.hasNextBinding(QueryIterBlockTriples.java:53) at com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:66) at com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorWrapper.hasNextBinding(QueryIteratorWrapper.java:28) at com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:66) at com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorWrapper.hasNextBinding(QueryIteratorWrapper.java:28) at com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:66) at com.hp.hpl.jena.sparql.engine.ResultSetStream.hasNext(ResultSetStream.java:57) at com.hp.hpl.jena.sparql.resultset.ResultSetApply.apply(ResultSetApply.java:29) at com.hp.hpl.jena.sparql.resultset.JSONOutput.format(JSONOutput.java:23) at com.hp.hpl.jena.query.ResultSetFormatter.outputAsJSON(ResultSetFormatter.java:542) at edu.cornell.mannlib.vitro.webapp.rdfservice.impl.jena.RDFServiceJena.sparqlSelectQuery(RDFServiceJena.java:353) at edu.cornell.mannlib.vitro.webapp.rdfservice.filter.LanguageFilteringRDFService.sparqlSelectQuery(LanguageFilteringRDFService.java:163) at edu.cornell.mannlib.vitro.webapp.dao.jena.RDFServiceGraph.execSelect(RDFServiceGraph.java:395) at edu.cornell.mannlib.vitro.webapp.dao.jena.RDFServiceGraph.find(RDFServiceGraph.java:254) at edu.cornell.mannlib.vitro.webapp.dao.jena.RDFServiceGraph.find(RDFServiceGraph.java:186) at com.hp.hpl.jena.graph.compose.MultiUnion.singleGraphFind(MultiUnion.java:175) at com.hp.hpl.jena.graph.compose.MultiUnion.graphBaseFind(MultiUnion.java:166) at com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:240) at com.hp.hpl.jena.graph.compose.Union.graphBaseFind(Union.java:53) at com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:240) at com.hp.hpl.jena.graph.compose.MultiUnion.singleGraphFind(MultiUnion.java:175) at com.hp.hpl.jena.graph.compose.MultiUnion.graphBaseFind(MultiUnion.java:166) at com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:240) at com.hp.hpl.jena.graph.impl.GraphBase.graphBaseFind(GraphBase.java:260) at com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:257) at com.hp.hpl.jena.rdf.model.impl.ModelCom.listStatements(ModelCom.java:378) at com.hp.hpl.jena.rdf.model.impl.ModelCom.listStatements(ModelCom.java:383) at edu.cornell.mannlib.vitro.webapp.utils.jena.URIUtils.hasExistingURI(URIUtils.java:26) at edu.cornell.mannlib.vitro.webapp.dao.jena.WebappDaoFactoryJena.hasExistingURI(WebappDaoFactoryJena.java:209) at edu.cornell.mannlib.vitro.webapp.dao.jena.WebappDaoFactoryJena.checkURI(WebappDaoFactoryJena.java:190) at edu.cornell.mannlib.vitro.webapp.dao.jena.WebappDaoFactoryJena.checkURI(WebappDaoFactoryJena.java:174) at edu.cornell.mannlib.vitro.webapp.dao.jena.IndividualDaoJena.getUnusedURI(IndividualDaoJena.java:667) at edu.cornell.mannlib.vitro.webapp.dao.jena.IndividualDaoJena.insertNewIndividual(IndividualDaoJena.java:210) at edu.cornell.mannlib.vitro.webapp.dao.jena.IndividualDaoJena.insertNewIndividualWebapp(IndividualDaoJena.java:201) at edu.cornell.mannlib.vitro.webapp.dao.jena.IndividualDaoJena.insertNewIndividual(IndividualDaoJena.java:196) at edu.cornell.mannlib.vitro.webapp.dao.jena.VClassGroupDaoJena.insertNewVClassGroup(VClassGroupDaoJena.java:213) at edu.cornell.mannlib.vitro.webapp.dao.jena.VClassGroupDaoJena.insertNewVClassGroup(VClassGroupDaoJena.java:185) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at edu.cornell.mannlib.vedit.controller.OperationController.performEdit(OperationController.java:457) at edu.cornell.mannlib.vedit.controller.OperationController.doPost(OperationController.java:118) at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at edu.cornell.mannlib.vitro.webapp.controller.VitroHttpServlet.service(VitroHttpServlet.java:65) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at edu.cornell.mannlib.vitro.webapp.filters.PageRoutingFilter.doNonDisplayPage(PageRoutingFilter.java:110) at edu.cornell.mannlib.vitro.webapp.filters.PageRoutingFilter.doFilter(PageRoutingFilter.java:101) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at edu.cornell.mannlib.vitro.webapp.filters.RequestModelsPrep.doFilter(RequestModelsPrep.java:106) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at edu.cornell.mannlib.vitro.webapp.filters.URLRewriterFilter.doFilter(URLRewriterFilter.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at edu.cornell.mannlib.vitro.webapp.filters.JSessionStripFilter.doFilter(JSessionStripFilter.java:60) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at edu.cornell.mannlib.vitro.webapp.filters.CachingResponseFilter.produceBasicResponse(CachingResponseFilter.java:322) at edu.cornell.mannlib.vitro.webapp.filters.CachingResponseFilter.doFilter(CachingResponseFilter.java:115) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at edu.cornell.mannlib.vitro.webapp.i18n.selection.LocaleSelectionFilter.doFilter(LocaleSelectionFilter.java:63) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at edu.cornell.mannlib.vitro.webapp.filters.CharsetEncodingFilter.doFilter(CharsetEncodingFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at edu.cornell.mannlib.vitro.webapp.filters.SessionTimeoutLimitingFilter.doFilter(SessionTimeoutLimitingFilter.java:39) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at edu.cornell.mannlib.vitro.webapp.filters.StartupStatusDisplayFilter.doFilter(StartupStatusDisplayFilter.java:64) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:498) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:562) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:394) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:243) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:188) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:724) Caused by: java.sql.SQLException: You can't operate on a closed Connection!!! at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106) at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65) at com.mchange.v2.c3p0.impl.NewProxyConnection.createStatement(NewProxyConnection.java:191) at com.hp.hpl.jena.sdb.sql.SDBConnection.execQuery(SDBConnection.java:107) at com.hp.hpl.jena.sdb.compiler.SDB_QC.exec(SDB_QC.java:60) ... 116 more Caused by: java.lang.NullPointerException at com.mchange.v2.c3p0.impl.NewProxyConnection.createStatement(NewProxyConnection.java:183) ... 118 more

    Sakai JIRA | 3 years ago | Brian Caruso
    com.hp.hpl.jena.sdb.sql.SDBExceptionSQL: SQLException in executing SQL statement
  3. 0

    Android: Saving Map State in Google map

    Stack Overflow | 11 months ago | Junie Negentien
    java.lang.RuntimeException: Unable to resume activity {com.ourThesis.junieNegentien2015/com.ourThesis.junieNegentien2015.MainActivity}: java.lang.NullPointerException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.lang.NullPointerException

      No message provided

      at com.mchange.v2.c3p0.impl.NewProxyConnection.createStatement()
    2. c3p0:JDBC DataSources/Resource Pools
      NewProxyConnection.createStatement
      1. com.mchange.v2.c3p0.impl.NewProxyConnection.createStatement(NewProxyConnection.java:183)
      1 frame
    3. Apache Jena - SDB (SQL based triple store)
      QueryEngineSDB.eval
      1. com.hp.hpl.jena.sdb.sql.SDBConnection.execQuery(SDBConnection.java:107)
      2. com.hp.hpl.jena.sdb.compiler.SDB_QC.exec(SDB_QC.java:60)
      3. com.hp.hpl.jena.sdb.compiler.OpSQL.exec(OpSQL.java:53)
      4. com.hp.hpl.jena.sdb.engine.QueryEngineSDB.eval(QueryEngineSDB.java:129)
      4 frames
    4. Apache Jena - ARQ (SPARQL 1.1 Query Engine)
      QueryEngineBase.getPlan
      1. com.hp.hpl.jena.sparql.engine.QueryEngineBase.evaluate(QueryEngineBase.java:138)
      2. com.hp.hpl.jena.sparql.engine.QueryEngineBase.createPlan(QueryEngineBase.java:109)
      3. com.hp.hpl.jena.sparql.engine.QueryEngineBase.getPlan(QueryEngineBase.java:97)
      3 frames
    5. Apache Jena - SDB (SQL based triple store)
      QueryEngineSDB$QueryEngineFactorySDB.create
      1. com.hp.hpl.jena.sdb.engine.QueryEngineSDB$QueryEngineFactorySDB.create(QueryEngineSDB.java:154)
      1 frame
    6. Apache Jena - ARQ (SPARQL 1.1 Query Engine)
      QueryExecutionBase.execSelect
      1. com.hp.hpl.jena.sparql.engine.QueryExecutionBase.getPlan(QueryExecutionBase.java:266)
      2. com.hp.hpl.jena.sparql.engine.QueryExecutionBase.startQueryIterator(QueryExecutionBase.java:243)
      3. com.hp.hpl.jena.sparql.engine.QueryExecutionBase.execResultSet(QueryExecutionBase.java:248)
      4. com.hp.hpl.jena.sparql.engine.QueryExecutionBase.execSelect(QueryExecutionBase.java:94)
      4 frames
    7. edu.cornell.mannlib
      RDFServiceGraph.find
      1. edu.cornell.mannlib.vitro.webapp.rdfservice.impl.jena.RDFServiceJena.sparqlSelectQuery(RDFServiceJena.java:343)
      2. edu.cornell.mannlib.vitro.webapp.rdfservice.filter.LanguageFilteringRDFService.sparqlSelectQuery(LanguageFilteringRDFService.java:163)
      3. edu.cornell.mannlib.vitro.webapp.dao.jena.RDFServiceGraph.execSelect(RDFServiceGraph.java:395)
      4. edu.cornell.mannlib.vitro.webapp.dao.jena.RDFServiceGraph.find(RDFServiceGraph.java:254)
      5. edu.cornell.mannlib.vitro.webapp.dao.jena.RDFServiceGraph.find(RDFServiceGraph.java:186)
      5 frames
    8. Apache Jena - Core
      GraphBase.find
      1. com.hp.hpl.jena.graph.compose.MultiUnion.singleGraphFind(MultiUnion.java:175)
      2. com.hp.hpl.jena.graph.compose.MultiUnion.graphBaseFind(MultiUnion.java:166)
      3. com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:240)
      4. com.hp.hpl.jena.graph.impl.GraphBase.graphBaseFind(GraphBase.java:260)
      5. com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:257)
      5 frames
    9. Apache Jena - ARQ (SPARQL 1.1 Query Engine)
      ResultSetFormatter.outputAsJSON
      1. com.hp.hpl.jena.sparql.engine.iterator.QueryIterTriplePattern$TripleMapper.<init>(QueryIterTriplePattern.java:67)
      2. com.hp.hpl.jena.sparql.engine.iterator.QueryIterTriplePattern.nextStage(QueryIterTriplePattern.java:41)
      3. com.hp.hpl.jena.sparql.engine.iterator.QueryIterRepeatApply.makeNextStage(QueryIterRepeatApply.java:91)
      4. com.hp.hpl.jena.sparql.engine.iterator.QueryIterRepeatApply.hasNextBinding(QueryIterRepeatApply.java:52)
      5. com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:66)
      6. com.hp.hpl.jena.sparql.engine.iterator.QueryIterBlockTriples.hasNextBinding(QueryIterBlockTriples.java:53)
      7. com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:66)
      8. com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorWrapper.hasNextBinding(QueryIteratorWrapper.java:28)
      9. com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:66)
      10. com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorWrapper.hasNextBinding(QueryIteratorWrapper.java:28)
      11. com.hp.hpl.jena.sparql.engine.iterator.QueryIteratorBase.hasNext(QueryIteratorBase.java:66)
      12. com.hp.hpl.jena.sparql.engine.ResultSetStream.hasNext(ResultSetStream.java:57)
      13. com.hp.hpl.jena.sparql.resultset.ResultSetApply.apply(ResultSetApply.java:29)
      14. com.hp.hpl.jena.sparql.resultset.JSONOutput.format(JSONOutput.java:23)
      15. com.hp.hpl.jena.query.ResultSetFormatter.outputAsJSON(ResultSetFormatter.java:542)
      15 frames
    10. edu.cornell.mannlib
      RDFServiceGraph.find
      1. edu.cornell.mannlib.vitro.webapp.rdfservice.impl.jena.RDFServiceJena.sparqlSelectQuery(RDFServiceJena.java:353)
      2. edu.cornell.mannlib.vitro.webapp.rdfservice.filter.LanguageFilteringRDFService.sparqlSelectQuery(LanguageFilteringRDFService.java:163)
      3. edu.cornell.mannlib.vitro.webapp.dao.jena.RDFServiceGraph.execSelect(RDFServiceGraph.java:395)
      4. edu.cornell.mannlib.vitro.webapp.dao.jena.RDFServiceGraph.find(RDFServiceGraph.java:254)
      5. edu.cornell.mannlib.vitro.webapp.dao.jena.RDFServiceGraph.find(RDFServiceGraph.java:186)
      5 frames
    11. Apache Jena - Core
      ModelCom.listStatements
      1. com.hp.hpl.jena.graph.compose.MultiUnion.singleGraphFind(MultiUnion.java:175)
      2. com.hp.hpl.jena.graph.compose.MultiUnion.graphBaseFind(MultiUnion.java:166)
      3. com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:240)
      4. com.hp.hpl.jena.graph.compose.Union.graphBaseFind(Union.java:53)
      5. com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:240)
      6. com.hp.hpl.jena.graph.compose.MultiUnion.singleGraphFind(MultiUnion.java:175)
      7. com.hp.hpl.jena.graph.compose.MultiUnion.graphBaseFind(MultiUnion.java:166)
      8. com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:240)
      9. com.hp.hpl.jena.graph.impl.GraphBase.graphBaseFind(GraphBase.java:260)
      10. com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:257)
      11. com.hp.hpl.jena.rdf.model.impl.ModelCom.listStatements(ModelCom.java:378)
      12. com.hp.hpl.jena.rdf.model.impl.ModelCom.listStatements(ModelCom.java:383)
      12 frames
    12. edu.cornell.mannlib
      VClassGroupDaoJena.insertNewVClassGroup
      1. edu.cornell.mannlib.vitro.webapp.utils.jena.URIUtils.hasExistingURI(URIUtils.java:26)
      2. edu.cornell.mannlib.vitro.webapp.dao.jena.WebappDaoFactoryJena.hasExistingURI(WebappDaoFactoryJena.java:209)
      3. edu.cornell.mannlib.vitro.webapp.dao.jena.WebappDaoFactoryJena.checkURI(WebappDaoFactoryJena.java:190)
      4. edu.cornell.mannlib.vitro.webapp.dao.jena.WebappDaoFactoryJena.checkURI(WebappDaoFactoryJena.java:174)
      5. edu.cornell.mannlib.vitro.webapp.dao.jena.IndividualDaoJena.getUnusedURI(IndividualDaoJena.java:667)
      6. edu.cornell.mannlib.vitro.webapp.dao.jena.IndividualDaoJena.insertNewIndividual(IndividualDaoJena.java:210)
      7. edu.cornell.mannlib.vitro.webapp.dao.jena.IndividualDaoJena.insertNewIndividualWebapp(IndividualDaoJena.java:201)
      8. edu.cornell.mannlib.vitro.webapp.dao.jena.IndividualDaoJena.insertNewIndividual(IndividualDaoJena.java:196)
      9. edu.cornell.mannlib.vitro.webapp.dao.jena.VClassGroupDaoJena.insertNewVClassGroup(VClassGroupDaoJena.java:213)
      10. edu.cornell.mannlib.vitro.webapp.dao.jena.VClassGroupDaoJena.insertNewVClassGroup(VClassGroupDaoJena.java:185)
      10 frames
    13. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    14. edu.cornell.mannlib
      OperationController.doPost
      1. edu.cornell.mannlib.vedit.controller.OperationController.performEdit(OperationController.java:457)
      2. edu.cornell.mannlib.vedit.controller.OperationController.doPost(OperationController.java:118)
      2 frames
    15. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
      2 frames
    16. edu.cornell.mannlib
      VitroHttpServlet.service
      1. edu.cornell.mannlib.vitro.webapp.controller.VitroHttpServlet.service(VitroHttpServlet.java:65)
      1 frame
    17. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      2 frames
    18. edu.cornell.mannlib
      PageRoutingFilter.doFilter
      1. edu.cornell.mannlib.vitro.webapp.filters.PageRoutingFilter.doNonDisplayPage(PageRoutingFilter.java:110)
      2. edu.cornell.mannlib.vitro.webapp.filters.PageRoutingFilter.doFilter(PageRoutingFilter.java:101)
      2 frames
    19. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      2 frames
    20. edu.cornell.mannlib
      RequestModelsPrep.doFilter
      1. edu.cornell.mannlib.vitro.webapp.filters.RequestModelsPrep.doFilter(RequestModelsPrep.java:106)
      1 frame
    21. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      2 frames
    22. edu.cornell.mannlib
      URLRewriterFilter.doFilter
      1. edu.cornell.mannlib.vitro.webapp.filters.URLRewriterFilter.doFilter(URLRewriterFilter.java:38)
      1 frame
    23. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      2 frames
    24. edu.cornell.mannlib
      JSessionStripFilter.doFilter
      1. edu.cornell.mannlib.vitro.webapp.filters.JSessionStripFilter.doFilter(JSessionStripFilter.java:60)
      1 frame
    25. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      2 frames
    26. edu.cornell.mannlib
      CachingResponseFilter.doFilter
      1. edu.cornell.mannlib.vitro.webapp.filters.CachingResponseFilter.produceBasicResponse(CachingResponseFilter.java:322)
      2. edu.cornell.mannlib.vitro.webapp.filters.CachingResponseFilter.doFilter(CachingResponseFilter.java:115)
      2 frames
    27. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      2 frames
    28. edu.cornell.mannlib
      LocaleSelectionFilter.doFilter
      1. edu.cornell.mannlib.vitro.webapp.i18n.selection.LocaleSelectionFilter.doFilter(LocaleSelectionFilter.java:63)
      1 frame
    29. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      2 frames
    30. edu.cornell.mannlib
      CharsetEncodingFilter.doFilter
      1. edu.cornell.mannlib.vitro.webapp.filters.CharsetEncodingFilter.doFilter(CharsetEncodingFilter.java:25)
      1 frame
    31. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      2 frames
    32. edu.cornell.mannlib
      SessionTimeoutLimitingFilter.doFilter
      1. edu.cornell.mannlib.vitro.webapp.filters.SessionTimeoutLimitingFilter.doFilter(SessionTimeoutLimitingFilter.java:39)
      1 frame
    33. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      2 frames
    34. edu.cornell.mannlib
      StartupStatusDisplayFilter.doFilter
      1. edu.cornell.mannlib.vitro.webapp.filters.StartupStatusDisplayFilter.doFilter(StartupStatusDisplayFilter.java:64)
      1 frame
    35. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
      5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:498)
      6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
      7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
      8. org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:562)
      9. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
      10. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:394)
      10 frames
    36. Grizzly HTTP
      JIoEndpoint$SocketProcessor.run
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:243)
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:188)
      3. org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
      3 frames
    37. Java RT
      Thread.run
      1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
      3. java.lang.Thread.run(Thread.java:724)
      3 frames