Skip to content

Instantly share code, notes, and snippets.

@smithh032772
smithh032772 / ORDERS_order_template_tables.sql
Created November 22, 2012 16:43
ORDERS and order_template tables, foreign key, entity and EJB/facade beans
CREATE TABLE orders (
order_id INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY,
trip_date_time TIMESTAMP NOT NULL,
report_date_time TIMESTAMP,
return_date_time TIMESTAMP,
details_id INTEGER,
customer_id INTEGER,
routes_id INTEGER,
template_id INTEGER,
total_cost DOUBLE,
@smithh032772
smithh032772 / Users.java
Created November 23, 2012 11:58
Users table structure and entity class
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package jpa.entities;
import java.io.Serializable;
import java.util.Collection;
import java.util.Date;
import javax.persistence.*;
@smithh032772
smithh032772 / Issue_100_exception_20121126.txt
Created November 26, 2012 14:38
Issue 100: exception after starting app (using batoo-jpa-2.0.1.0-20121126.105944-4.jar)
SEVERE: Unable to stop web application /mcmsweb: Exception: Failed undeploying application: id=C:\Users\Public\NetBeansProjects\mcms\build\web
org.apache.openejb.UndeployException: Failed undeploying application: id=C:\Users\Public\NetBeansProjects\mcms\build\web
at org.apache.openejb.assembler.classic.Assembler.destroyApplication(Assembler.java:1264)
at org.apache.openejb.assembler.classic.Assembler.destroyApplication(Assembler.java:1196)
at org.apache.tomee.catalina.TomcatWebAppBuilder.afterStop(TomcatWebAppBuilder.java:1429)
at org.apache.tomee.catalina.GlobalListenerSupport.lifecycleEvent(GlobalListenerSupport.java:114)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90)
at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:402)
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:252)
@smithh032772
smithh032772 / batoo-snapshot-7-exception.txt
Created November 27, 2012 05:34
Batoo JPA snapshot-7 exception: EntityManager has been previously closed
Nov 27, 2012 12:14:53 AM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet [Faces Servlet] in context with path [/mcmsweb] threw exception [javax.el.ELException: java.lang.IllegalStateException: EntityManager has been previously closed] with root cause
java.lang.IllegalStateException: EntityManager has been previously closed
at org.batoo.jpa.core.impl.manager.EntityManagerImpl.assertOpen(EntityManagerImpl.java:140)
at org.batoo.jpa.core.impl.manager.JtaEntityManagerImpl.joinTransaction(JtaEntityManagerImpl.java:162)
at org.batoo.jpa.core.impl.manager.EntityManagerImpl.getConnection(EntityManagerImpl.java:586)
at org.batoo.jpa.core.impl.criteria.QueryImpl.getResultListImpl(QueryImpl.java:797)
at org.batoo.jpa.core.impl.criteria.QueryImpl.getResultList(QueryImpl.java:775)
at org.batoo.jpa.core.impl.criteria.QueryImpl.getSingleResult(QueryImpl.java:843)
at org.batoo.jpa.core.impl.model.EntityTypeImpl.performSelect(EntityTypeImpl.java:1929)
@smithh032772
smithh032772 / NullPointerException_since_null_OrderCustomerLeader_collection.txt
Created November 27, 2012 06:47
OrderCustomerLeader relationship to ORDERS table is always NULL
Nov 27, 2012 1:09:47 AM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet [Faces Servlet] in context with path [/mcmsweb] threw exception [javax.el.ELException: java.lang.NullPointerException] with root cause
java.lang.NullPointerException
at java.util.ArrayList.<init>(ArrayList.java:151)
at jsf.orders.OrderDisplayUtil.getOrderTitle(OrderDisplayUtil.java:809)
at jsf.orders.pf_OrdersController.getOrderNumberAndLabel(pf_OrdersController.java:4363)
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:601)
@smithh032772
smithh032772 / stacktrace.txt
Created November 27, 2012 07:55
Several OrdersFacade dynamic SQL test results
pf_UsersController.loginUser(): administrator logged in at Tue Nov 27 01:21:54 EST 2012
javax.ejb.EJBException: The bean encountered a non-application exception; nested exception is:
javax.persistence.PersistenceException: Collection paths cannot be restricted
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.convertException(BaseEjbProxyHandler.java:363)
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:283)
at jpa.session.OrdersFacade$LocalBeanProxy.filterPayroll(jpa/session/OrdersFacade.java)
at jsf.orders.pf_OrdersController.initPayrollDriverList(pf_OrdersController.java:2936)
at jsf.orders.pf_OrdersController.recreateModel(pf_OrdersController.java:16046)
at jsf.orders.pf_OrdersController.prepareList(pf_OrdersController.java:5961)
at jsf.orders.pf_OrdersController.prepareList(pf_OrdersController.java:5913)
@smithh032772
smithh032772 / gist:4670145
Created January 30, 2013 02:41
Atmosphere issue: java.lang.NumberFormatException: For input string: "(TomEE)/7"
Jan 29, 2013 8:52:35 PM org.apache.catalina.core.StandardWrapperValve event
SEVERE: Servlet.service() for servlet [Push Servlet] in context with path [/mcmsweb] threw exception
java.lang.NumberFormatException: For input string: "(TomEE)/7"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.valueOf(Unknown Source)
at org.atmosphere.container.Tomcat7CometSupport.bz51881(Tomcat7CometSupport.java:141)
at org.atmosphere.container.Tomcat7CometSupport.service(Tomcat7CometSupport.java:114)
at org.atmosphere.container.Tomcat7AsyncSupportWithWebSocket.doService(Tomcat7AsyncSupportWithWebSocket.java:63)
at org.atmosphere.container.TomcatWebSocketUtil.doService(TomcatWebSocketUtil.java:84)
@smithh032772
smithh032772 / 20130130_heap_dump_1
Created January 31, 2013 05:12
Heap dump while running Atmosphere 1.0.9 with TomEE 1.5.2-SNAPSHOT (20130128 version which has Tomcat 7.0.35 dependency)
#
# A fatal error has been detected by the Java Runtime Environment:
#
# EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x0000000180005310, pid=2396, tid=3724
#
# JRE version: 7.0_11-b21
# Java VM: Java HotSpot(TM) 64-Bit Server VM (23.6-b04 mixed mode windows-amd64 compressed oops)
# Problematic frame:
# C [tcnative-1.dll+0x5310] Java_org_apache_tomcat_jni_Socket_send+0xa0
#
@smithh032772
smithh032772 / log.txt
Last active December 16, 2015 18:29
webapp with spring3 and MyFaces2
java.lang.UnsupportedOperationException
at javax.faces.application.Application.getResourceHandler(Application.java:860)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:198)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
@smithh032772
smithh032772 / localhost_log.txt
Created May 15, 2013 05:05
Experience using apache-tomee-1.6.0-20130514.041132-71-plus.zip
May 14, 2013 6:24:59 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet [Faces Servlet] in context with path [/mcmsweb] threw exception [null] with root cause
java.lang.NullPointerException
at jsf.users.pf_UsersController.isLoggedInViaAndroid(pf_UsersController.java:366)
at jsf.users.pf_UsersController$$OwbNormalScopeProxy0.isLoggedInViaAndroid(jsf/users/pf_UsersController.java)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at javax.el.BeanELResolver.invoke(BeanELResolver.java:450)