API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 24th, 2016
52
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.67 KB | None | 0 0
raw download clone embed print report
  1. ELException
  2.  
  3. /PWFacility/viewReferral.xhtml @151,77 referralMetadata="#{referralMetadata}": /PWFacility/viewReferral.xhtml @15,89 value="#{viewReferralController.referralMetadata}": org.springframework.transaction.TransactionSystemException: Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLRecoverableException: Closed Connection Error Code: 17008
  4.  
  5. System Information
  6.  
  7. Date: Monday, July 11, 2016 09:29 AM
  8. Application Name: /ereferral/PWFacility
  9. Host Name: gtaprodapp04.stratahealth.org
  10. Host Address: 192.168.91.54
  11. Instance: servlet on Glassfish instance Facility-n04x04
  12.  
  13. OS Name: Linux
  14. OS Version: 2.6.32-279.14.1.el6.x86_64
  15. OS Architecture: amd64
  16.  
  17. Java Version: 1.6.0_29
  18. Java Directory: /usr/java/jdk1.6.0_29/jre
  19. WebObjects Version: 5.4.3
  20. Spring Version: 3.2.8.RELEASE
  21. Faces Version: Oracle America, Inc. Mojarra 2.1.22
  22. Oracle Adaptor Version: Oracle Corporation JDBC 11.2.0.3.0
  23.  
  24. Building user: bamboo on zion.stratahealth.org
  25. Build date: 2016-07-05T20:39:04.813-06:00
  26. Revision: e6e3ef8cda83bf7db9fc2442fbf9dfcb6e81aa0d
  27. Branch: PW9.5.2
  28. Application URL: http://resourcematchingandreferral.ca/ereferral/PWFacility/pwx/PWFacility/viewReferral.xhtml
  29.  
  30. Request Handler: JSF
  31. User Locale: English (Canada)
  32. Exception Information
  33.  
  34. javax.el.ELException: /PWFacility/viewReferral.xhtml @151,77 referralMetadata="#{referralMetadata}": /PWFacility/viewReferral.xhtml @15,89 value="#{viewReferralController.referralMetadata}": org.springframework.transaction.TransactionSystemException: Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
  35. Internal Exception: java.sql.SQLRecoverableException: Closed Connection
  36. Error Code: 17008
  37. at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:114)
  38. at javax.faces.component.UIComponentBase$AttributesMap.get(UIComponentBase.java:2392)
  39. at com.sun.faces.el.CompositeComponentAttributesELResolver$ExpressionEvalMap.get(CompositeComponentAttributesELResolver.java:349)
  40. at javax.el.MapELResolver.getValue(MapELResolver.java:199)
  41. at com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:176)
  42. at com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:203)
  43. at com.sun.el.parser.AstValue.getValue(AstValue.java:138)
  44. at com.sun.el.parser.AstValue.getValue(AstValue.java:183)
  45. at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:224)
  46. at com.sun.faces.facelets.el.ContextualCompositeValueExpression.getValue(ContextualCompositeValueExpression.java:156)
  47. at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:109)
  48. at com.sun.el.parser.AstIdentifier.getValue(AstIdentifier.java:99)
  49. at com.sun.el.parser.AstValue.getValue(AstValue.java:179)
  50. at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:224)
  51. at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:109)
  52. at com.sun.el.parser.AstIdentifier.getValue(AstIdentifier.java:99)
  53. at com.sun.el.parser.AstValue.getValue(AstValue.java:179)
  54. at com.sun.el.parser.AstMethodArguments.getParameters(AstMethodArguments.java:65)
  55. at com.sun.el.parser.AstValue.getValue(AstValue.java:131)
  56. at com.sun.el.parser.AstValue.getValue(AstValue.java:183)
  57. at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:224)
  58. at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:109)
  59. at com.sun.el.parser.AstIdentifier.getValue(AstIdentifier.java:99)
  60. at com.sun.el.parser.AstValue.getValue(AstValue.java:179)
  61. at com.sun.el.parser.AstEmpty.getValue(AstEmpty.java:66)
  62. at com.sun.el.parser.AstNot.getValue(AstNot.java:63)
  63. at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:224)
  64. at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:109)
  65. at com.sun.faces.facelets.tag.TagAttributeImpl.getObject(TagAttributeImpl.java:329)
  66. at com.sun.faces.facelets.tag.TagAttributeImpl.getBoolean(TagAttributeImpl.java:136)
  67. at com.sun.faces.facelets.tag.jstl.core.IfHandler.apply(IfHandler.java:91)
  68. at javax.faces.view.facelets.CompositeFaceletHandler.apply(CompositeFaceletHandler.java:95)
  69. at javax.faces.view.facelets.DelegatingMetaTagHandler.applyNextHandler(DelegatingMetaTagHandler.java:137)
  70. at com.sun.faces.facelets.tag.jsf.ComponentTagHandlerDelegateImpl.apply(ComponentTagHandlerDelegateImpl.java:187)
  71. at javax.faces.view.facelets.DelegatingMetaTagHandler.apply(DelegatingMetaTagHandler.java:120)
  72. at javax.faces.view.facelets.CompositeFaceletHandler.apply(CompositeFaceletHandler.java:95)
  73. at com.sun.faces.facelets.tag.composite.ImplementationHandler.apply(ImplementationHandler.java:81)
  74. at javax.faces.view.facelets.CompositeFaceletHandler.apply(CompositeFaceletHandler.java:95)
  75. at com.sun.faces.facelets.compiler.NamespaceHandler.apply(NamespaceHandler.java:93)
  76. at com.sun.faces.facelets.compiler.EncodingHandler.apply(EncodingHandler.java:87)
  77. at com.sun.faces.facelets.impl.DefaultFacelet.include(DefaultFacelet.java:320)
  78. at com.sun.faces.facelets.impl.DefaultFacelet.include(DefaultFacelet.java:379)
  79. at com.sun.faces.facelets.impl.DefaultFaceletContext.includeFacelet(DefaultFaceletContext.java:326)
  80. at com.sun.faces.facelets.tag.jsf.CompositeComponentTagHandler.applyCompositeComponent(CompositeComponentTagHandler.java:376)
  81. at com.sun.faces.facelets.tag.jsf.CompositeComponentTagHandler.applyNextHandler(CompositeComponentTagHandler.java:188)
  82. at com.sun.faces.facelets.tag.jsf.ComponentTagHandlerDelegateImpl.apply(ComponentTagHandlerDelegateImpl.java:187)
  83. at javax.faces.view.facelets.DelegatingMetaTagHandler.apply(DelegatingMetaTagHandler.java:120)
  84. at javax.faces.view.facelets.DelegatingMetaTagHandler.applyNextHandler(DelegatingMetaTagHandler.java:137)
  85. at com.sun.faces.facelets.tag.jsf.ComponentTagHandlerDelegateImpl.apply(ComponentTagHandlerDelegateImpl.java:187)
  86. at javax.faces.view.facelets.DelegatingMetaTagHandler.apply(DelegatingMetaTagHandler.java:120)
  87. at javax.faces.view.facelets.CompositeFaceletHandler.apply(CompositeFaceletHandler.java:95)
  88. at javax.faces.view.facelets.DelegatingMetaTagHandler.applyNextHandler(DelegatingMetaTagHandler.java:137)
  89. at com.sun.faces.facelets.tag.jsf.ComponentTagHandlerDelegateImpl.apply(ComponentTagHandlerDelegateImpl.java:187)
  90. at javax.faces.view.facelets.DelegatingMetaTagHandler.apply(DelegatingMetaTagHandler.java:120)
  91. at javax.faces.view.facelets.CompositeFaceletHandler.apply(CompositeFaceletHandler.java:95)
  92. at javax.faces.view.facelets.DelegatingMetaTagHandler.applyNextHandler(DelegatingMetaTagHandler.java:137)
  93. at com.sun.faces.facelets.tag.jsf.ComponentTagHandlerDelegateImpl.apply(ComponentTagHandlerDelegateImpl.java:187)
  94. at javax.faces.view.facelets.DelegatingMetaTagHandler.apply(DelegatingMetaTagHandler.java:120)
  95. at javax.faces.view.facelets.CompositeFaceletHandler.apply(CompositeFaceletHandler.java:95)
  96. at javax.faces.view.facelets.DelegatingMetaTagHandler.applyNextHandler(DelegatingMetaTagHandler.java:137)
  97. at com.sun.faces.facelets.tag.jsf.CompositeComponentTagHandler.applyNextHandler(CompositeComponentTagHandler.java:185)
  98. at com.sun.faces.facelets.tag.jsf.ComponentTagHandlerDelegateImpl.apply(ComponentTagHandlerDelegateImpl.java:187)
  99. at javax.faces.view.facelets.DelegatingMetaTagHandler.apply(DelegatingMetaTagHandler.java:120)
  100. at javax.faces.view.facelets.DelegatingMetaTagHandler.applyNextHandler(DelegatingMetaTagHandler.java:137)
  101. at com.sun.faces.facelets.tag.jsf.ComponentTagHandlerDelegateImpl.apply(ComponentTagHandlerDelegateImpl.java:187)
  102. at javax.faces.view.facelets.DelegatingMetaTagHandler.apply(DelegatingMetaTagHandler.java:120)
  103. at javax.faces.view.facelets.CompositeFaceletHandler.apply(CompositeFaceletHandler.java:95)
  104. at javax.faces.view.facelets.DelegatingMetaTagHandler.applyNextHandler(DelegatingMetaTagHandler.java:137)
  105. at com.sun.faces.facelets.tag.jsf.CompositeComponentTagHandler.applyNextHandler(CompositeComponentTagHandler.java:185)
  106. at com.sun.faces.facelets.tag.jsf.ComponentTagHandlerDelegateImpl.apply(ComponentTagHandlerDelegateImpl.java:187)
  107. at javax.faces.view.facelets.DelegatingMetaTagHandler.apply(DelegatingMetaTagHandler.java:120)
  108. at com.sun.faces.facelets.compiler.NamespaceHandler.apply(NamespaceHandler.java:93)
  109. at com.sun.faces.facelets.compiler.EncodingHandler.apply(EncodingHandler.java:87)
  110. at com.sun.faces.facelets.impl.DefaultFacelet.apply(DefaultFacelet.java:164)
  111. at com.sun.faces.application.view.FaceletViewHandlingStrategy.buildView(FaceletViewHandlingStrategy.java:906)
  112. at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:99)
  113. at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
  114. at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
  115. at javax.faces.webapp.FacesServlet.service(FacesServlet.java:594)
  116. at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1550)
  117. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:343)
  118. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  119. at com.stratahealth.shared.common.filters.MainFilter.doFilter(MainFilter.java:30)
  120. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
  121. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  122. at com.clickspace.csutilities.jsf.UTF8CharacterEncodingFilter.doFilter(UTF8CharacterEncodingFilter.java:15)
  123. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
  124. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  125. at com.stratahealth.shared.common.filters.RequireLoginFilter.doFilter(RequireLoginFilter.java:63)
  126. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
  127. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217)
  128. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:279)
  129. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
  130. at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655)
  131. at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595)
  132. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:161)
  133. at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:331)
  134. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:231)
  135. at com.sun.enterprise.v3.services.impl.ContainerMapper$AdapterCallable.call(ContainerMapper.java:317)
  136. at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:195)
  137. at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:860)
  138. at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:757)
  139. at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1056)
  140. at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:229)
  141. at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
  142. at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
  143. at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
  144. at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
  145. at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)
  146. at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
  147. at com.sun.grizzly.ContextTask.run(ContextTask.java:71)
  148. at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)
  149. at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)
  150. at java.lang.Thread.run(Thread.java:662)
  151. Caused by: org.springframework.transaction.TransactionSystemException: Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
  152. Internal Exception: java.sql.SQLRecoverableException: Closed Connection
  153. Error Code: 17008
  154. at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:522)
  155. at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:755)
  156. at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:724)
  157. at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:148)
  158. at com.stratahealth.shared.common.converters.GenericJPAConverter.getAsObject(GenericJPAConverter.java:64)
  159. at com.stratahealth.pathways.facility.controllers.ViewReferralController.getReferral(ViewReferralController.java:107)
  160. at com.stratahealth.pathways.facility.controllers.ViewReferralController.getReferralMetadata(ViewReferralController.java:120)
  161. at sun.reflect.GeneratedMethodAccessor1929.invoke(Unknown Source)
  162. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  163. at java.lang.reflect.Method.invoke(Method.java:597)
  164. at javax.el.BeanELResolver.getValue(BeanELResolver.java:363)
  165. at com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:176)
  166. at com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:203)
  167. at com.sun.el.parser.AstValue.getValue(AstValue.java:138)
  168. at com.sun.el.parser.AstValue.getValue(AstValue.java:183)
  169. at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:224)
  170. at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:109)
  171. at com.sun.el.parser.AstIdentifier.getValue(AstIdentifier.java:99)
  172. at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:224)
  173. at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:109)
  174. ... 113 more
  175. Caused by: javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
  176. Internal Exception: java.sql.SQLRecoverableException: Closed Connection
  177. Error Code: 17008
  178. at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:157)
  179. at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:513)
  180. ... 132 more
  181. Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
  182. Internal Exception: java.sql.SQLRecoverableException: Closed Connection
  183. Error Code: 17008
  184. at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
  185. at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1611)
  186. at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicCommitTransaction(DatabaseAccessor.java:443)
  187. at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.commitTransaction(DatasourceAccessor.java:405)
  188. at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.commitTransaction(DatabaseAccessor.java:427)
  189. at org.eclipse.persistence.internal.sessions.AbstractSession.basicCommitTransaction(AbstractSession.java:761)
  190. at org.eclipse.persistence.sessions.server.ClientSession.basicCommitTransaction(ClientSession.java:174)
  191. at org.eclipse.persistence.internal.sessions.AbstractSession.commitTransaction(AbstractSession.java:965)
  192. at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitTransaction(UnitOfWorkImpl.java:1600)
  193. at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitTransaction(RepeatableWriteUnitOfWork.java:647)
  194. at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitTransactionAfterWriteChanges(UnitOfWorkImpl.java:1615)
  195. at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:284)
  196. at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:1169)
  197. at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:132)
  198. ... 133 more
  199. Caused by: java.sql.SQLRecoverableException: Closed Connection
  200. at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3867)
  201. at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3907)
  202. at oracle.jdbc.OracleConnectionWrapper.commit(OracleConnectionWrapper.java:140)
  203. at com.sun.gjc.spi.base.ConnectionHolder.commit(ConnectionHolder.java:244)
  204. at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicCommitTransaction(DatabaseAccessor.java:437)
  205. ... 144 more
  206.  
  207. public Referral getReferral() {
  208. if (referral == null) {
  209. String referralId = request.getParameter("referralId");
  210. if (referralId != null && referralId.trim().length() > 0)
  211. referral = converter.getAsObject(null, null, referralId);
  212. }
  213. return referral;
  214. }
  215.  
  216. @Override
  217. public T getAsObject(FacesContext context, UIComponent component, String value) {
  218. if (value == null || value.trim().isEmpty())
  219. return null;
  220. Long decoded = null;
  221. try {
  222. decoded = Long.decode(value);
  223. } catch (NumberFormatException e) {
  224. return null;
  225. }
  226. BooleanExpression predicate = getIdDef().eq(decoded);
  227. BooleanExpression narrowingPredicate = getNarrowingExpression();
  228. if (narrowingPredicate != null)
  229. predicate = predicate.and(narrowingPredicate);
  230. final BooleanExpression fPredicate = predicate;
  231. List<? extends T> result = getTransactionTemplate().execute(new TransactionCallback<List<? extends T>>() {
  232. @Override
  233. public List<? extends T> doInTransaction(TransactionStatus status) {
  234. JPAQuery query = extendQuery(jpaQuery().from(getQueryDSLDefinition()).where(fPredicate));
  235. List<? extends T> elements = query.list(getQueryDSLDefinition());
  236. if (!elements.isEmpty())
  237. postFetch(elements);
  238. return elements;
  239. }
  240. });
  241. return result.isEmpty() ? null : result.get(0);
  242. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!