Did you mean APPLICATIONID column? Yes, I somehow didn't add it in 3.1.
It's there now on trunk.
-marina
Oliver Mayer wrote:
> Tried it with GF 3.1 - it seems to have the old ddl script shipped.. i
> had to manual add this column - i used varchar(255) NULL - it works for
> me now..
>
>
> Am Donnerstag, den 03.02.2011, 17:27 -0800 schrieb Marina Vatkina:
>
>> Right. You needed to upgrade your domain when you switched from 3.0.1 to
>> 3.1 instead of just reusing the same table with another GF version.
>>
>> Now you have the following options:
>> 1. Remove the marker file
>> glassfish3/glassfish/domains/domain1/generated/ejb-timer-service-app to
>> let EJB Timer service create the table (it does that on the 1st use
>> only, so removing the file you "trick" the TS to think that it's the 1st
>> time)
>> 2. Use the glassfish3/glassfish/lib/install/databases/ejbtimer_mysql.sql
>> DDL and manually create the new table
>> 3. You could use the upgrade file
>> glassfish3/glassfish/lib/install/databases/upgrade/ejbtimer_upgrade_mysql.sql
>> to alter the table and add a required column that way
>>
>> HTH,
>> -marina
>>
>> Derek Knapp wrote:
>>
>>> now I just get
>>>
>>> Internal Exception:
>>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
>>> 'itracmediav4.EJB__TIMER__TBL' doesn't exist
>>>
>>>
>>>
>>> Derek
>>>
>>>
>>>
>>> [#|2011-02-03T00:44:20.777-0500|WARNING|glassfish3.1|javax.enterprise.system.container.ejb.com.sun.ejb.containers|_ThreadID=100;_ThreadName=Thread-1;|EJB5108:Unable
>>> to initialize EJB Timer Service. The possible cause is the timer
>>> resource is not configured correctly, the database has not been
>>> started, or the timer database table has not been created.
>>> javax.ejb.EJBException
>>> at
>>> com.sun.ejb.containers.BaseContainer.processSystemException(BaseContainer.java:5194)
>>>
>>> at
>>> com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:5092)
>>>
>>> at
>>> com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:4880)
>>>
>>> at
>>> com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:2039)
>>> at
>>> com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1990)
>>> at
>>> com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:222)
>>>
>>> at
>>> com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:88)
>>>
>>> at $Proxy316.findActiveTimersOwnedByThisServer(Unknown Source)
>>> at
>>> com.sun.ejb.containers.EJBTimerService.restoreEJBTimers(EJBTimerService.java:489)
>>>
>>> at
>>> com.sun.ejb.containers.EjbContainerUtilImpl.getEJBTimerService(EjbContainerUtilImpl.java:302)
>>>
>>> at
>>> com.sun.ejb.containers.EjbContainerUtilImpl.getEJBTimerService(EjbContainerUtilImpl.java:284)
>>>
>>> at
>>> com.sun.ejb.containers.EjbContainerUtilImpl.getEJBTimerService(EjbContainerUtilImpl.java:269)
>>>
>>> at
>>> com.sun.ejb.containers.BaseContainer.<init>(BaseContainer.java:755)
>>> at
>>> com.sun.ejb.containers.StatelessSessionContainer.<init>(StatelessSessionContainer.java:155)
>>>
>>> at
>>> com.sun.ejb.containers.StatelessSessionContainer.<init>(StatelessSessionContainer.java:149)
>>>
>>> at
>>> com.sun.ejb.containers.ContainerFactoryImpl.createContainer(ContainerFactoryImpl.java:105)
>>>
>>> at
>>> org.glassfish.ejb.startup.EjbApplication.loadContainers(EjbApplication.java:234)
>>>
>>> at
>>> org.glassfish.ejb.startup.EjbDeployer.load(EjbDeployer.java:290)
>>> at
>>> org.glassfish.ejb.startup.EjbDeployer.load(EjbDeployer.java:101)
>>> at
>>> org.glassfish.internal.data.ModuleInfo.load(ModuleInfo.java:186)
>>> at
>>> org.glassfish.internal.data.ApplicationInfo.load(ApplicationInfo.java:249)
>>>
>>> at
>>> com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:460)
>>>
>>> at
>>> com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:240)
>>>
>>> at
>>> org.glassfish.deployment.admin.DeployCommand.execute(DeployCommand.java:370)
>>>
>>> at
>>> com.sun.enterprise.v3.admin.CommandRunnerImpl$1.execute(CommandRunnerImpl.java:354)
>>>
>>> at
>>> com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:369)
>>>
>>> at
>>> com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:1080)
>>>
>>> at
>>> com.sun.enterprise.v3.admin.CommandRunnerImpl.access$1200(CommandRunnerImpl.java:95)
>>>
>>> at
>>> com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1260)
>>>
>>> at
>>> com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1248)
>>>
>>> at
>>> org.glassfish.admingui.common.util.LocalDeploymentFacility$LocalDFCommandRunner.run(LocalDeploymentFacility.java:143)
>>>
>>> at
>>> org.glassfish.deployment.client.AbstractDeploymentFacility.deploy(AbstractDeploymentFacility.java:406)
>>>
>>> at
>>> org.glassfish.admingui.common.util.DeployUtil.invokeDeploymentFacility(DeployUtil.java:100)
>>>
>>> at
>>> org.glassfish.admingui.common.util.DeployUtil.deploy(DeployUtil.java:76)
>>> at
>>> org.glassfish.admingui.common.handlers.DeploymentHandler.deploy(DeploymentHandler.java:191)
>>>
>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>> at
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>>
>>> at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>>
>>> at java.lang.reflect.Method.invoke(Method.java:597)
>>> at
>>> com.sun.jsftemplating.layout.descriptors.handler.Handler.invoke(Handler.java:442)
>>>
>>> at
>>> com.sun.jsftemplating.layout.descriptors.LayoutElementBase.dispatchHandlers(LayoutElementBase.java:420)
>>>
>>> at
>>> com.sun.jsftemplating.layout.descriptors.LayoutElementBase.dispatchHandlers(LayoutElementBase.java:394)
>>>
>>> at
>>> com.sun.jsftemplating.layout.event.CommandActionListener.invokeCommandHandlers(CommandActionListener.java:150)
>>>
>>> at
>>> com.sun.jsftemplating.layout.event.CommandActionListener.processAction(CommandActionListener.java:98)
>>>
>>> at
>>> javax.faces.event.ActionEvent.processListener(ActionEvent.java:88)
>>> at
>>> javax.faces.component.UIComponentBase.broadcast(UIComponentBase.java:777)
>>> at javax.faces.component.UICommand.broadcast(UICommand.java:300)
>>> at
>>> com.sun.webui.jsf.component.WebuiCommand.broadcast(WebuiCommand.java:166)
>>> at
>>> javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:787)
>>> at
>>> javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1252)
>>> at
>>> com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
>>>
>>> at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
>>> at
>>> com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
>>> at javax.faces.webapp.FacesServlet.service(FacesServlet.java:312)
>>> at
>>> org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1534)
>>>
>>> at
>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:343)
>>>
>>> at
>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:215)
>>>
>>> at
>>> com.sun.webui.jsf.util.UploadFilter.doFilter(UploadFilter.java:223)
>>> at
>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
>>>
>>> at
>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:215)
>>>
>>> at
>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:279)
>>>
>>> at
>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
>>>
>>> at
>>> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655)
>>>
>>> at
>>> org.apache.catalina.core.StandardPipeline.doChainInvoke(StandardPipeline.java:600)
>>>
>>> at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:96)
>>> at
>>> com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:91)
>>>
>>> at
>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:162)
>>>
>>> at
>>> org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:326)
>>>
>>> at
>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:227)
>>>
>>> at
>>> com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:228)
>>>
>>> at
>>> com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:822)
>>> at
>>> com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:719)
>>> at
>>> com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1013)
>>> at
>>> com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:225)
>>>
>>> at
>>> com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
>>>
>>> at
>>> com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
>>>
>>> at
>>> com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
>>>
>>> at
>>> com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
>>> at
>>> com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)
>>>
>>> at
>>> com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
>>>
>>> at com.sun.grizzly.ContextTask.run(ContextTask.java:71)
>>> at
>>> com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)
>>>
>>> at
>>> com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)
>>>
>>> at java.lang.Thread.run(Thread.java:619)
>>> Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services
>>> - 2.2.0.v20110114-r8831):
>>> org.eclipse.persistence.exceptions.DatabaseException
>>> Internal Exception:
>>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
>>> 'itracmediav4.EJB__TIMER__TBL' doesn't exist
>>> Error Code: 1146
>>> Call: SELECT `TIMERID`, `APPLICATIONID`, `BLOB`, `CONTAINERID`,
>>> `CREATIONTIMERAW`, `INITIALEXPIRATIONRAW`, `INTERVALDURATION`,
>>> `LASTEXPIRATIONRAW`, `OWNERID`, `PKHASHCODE`, `SCHEDULE`, `STATE` FROM
>>> `EJB__TIMER__TBL` WHERE ((`OWNERID` = ?) AND (`STATE` = ?))
>>> bind => [2 parameters bound]
>>> Query: ReadAllQuery(name="findTimersByOwnerAndState"
>>> referenceClass=TimerState sql="SELECT `TIMERID`, `APPLICATIONID`,
>>> `BLOB`, `CONTAINERID`, `CREATIONTIMERAW`, `INITIALEXPIRATIONRAW`,
>>> `INTERVALDURATION`, `LASTEXPIRATIONRAW`, `OWNERID`, `PKHASHCODE`,
>>> `SCHEDULE`, `STATE` FROM `EJB__TIMER__TBL` WHERE ((`OWNERID` = ?) AND
>>> (`STATE` = ?))")
>>> at
>>> org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
>>>
>>> at
>>> org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:684)
>>>
>>> at
>>> org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526)
>>>
>>> at
>>> org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1729)
>>>
>>> at
>>> org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:566)
>>>
>>> at
>>> org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:207)
>>>
>>> at
>>> org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207)
>>>
>>> at
>>> org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)
>>>
>>> at
>>> org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:264)
>>>
>>> at
>>> org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:647)
>>>
>>> at
>>> org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2558)
>>>
>>> at
>>> org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2517)
>>>
>>> at
>>> org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:410)
>>>
>>> at
>>> org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1080)
>>>
>>> at
>>> org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:808)
>>>
>>> at
>>> org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1040)
>>>
>>> at
>>> org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:383)
>>>
>>> at
>>> org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1126)
>>>
>>> at
>>> org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2842)
>>>
>>> at
>>> org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1521)
>>>
>>> at
>>> org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1503)
>>>
>>> at
>>> org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1477)
>>>
>>> at
>>> org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:484)
>>>
>>> at
>>> org.eclipse.persistence.internal.jpa.EJBQueryImpl.getResultList(EJBQueryImpl.java:741)
>>>
>>> at
>>> com.sun.ejb.containers.TimerBean.findTimersByOwnerAndState(TimerBean.java:204)
>>>
>>> at
>>> com.sun.ejb.containers.TimerBean.findActiveTimersOwnedByThisServer(TimerBean.java:518)
>>>
>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>> at
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>>
>>> at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>>
>>> at java.lang.reflect.Method.invoke(Method.java:597)
>>> at
>>> org.glassfish.ejb.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1052)
>>>
>>> at
>>> org.glassfish.ejb.security.application.EJBSecurityManager.invoke(EJBSecurityManager.java:1124)
>>>
>>> at
>>> com.sun.ejb.containers.BaseContainer.invokeBeanMethod(BaseContainer.java:5367)
>>>
>>> at
>>> com.sun.ejb.EjbInvocation.invokeBeanMethod(EjbInvocation.java:619)
>>> at
>>> com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:801)
>>>
>>> at com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:571)
>>> at
>>> com.sun.ejb.containers.interceptors.SystemInterceptorProxy.doAround(SystemInterceptorProxy.java:162)
>>>
>>> at
>>> com.sun.ejb.containers.interceptors.SystemInterceptorProxy.aroundInvoke(SystemInterceptorProxy.java:144)
>>>
>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>> at
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>>
>>> at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>>
>>> at java.lang.reflect.Method.invoke(Method.java:597)
>>> at
>>> com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:862)
>>>
>>> at
>>> com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:801)
>>>
>>> at
>>> com.sun.ejb.containers.interceptors.InterceptorManager.intercept(InterceptorManager.java:371)
>>>
>>> at
>>> com.sun.ejb.containers.BaseContainer.__intercept(BaseContainer.java:5339)
>>> at
>>> com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:5327)
>>> at
>>> com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:214)
>>>
>>> ... 78 more
>>> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
>>> Table 'itracmediav4.EJB__TIMER__TBL' doesn't exist
>>> at
>>> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>>> at
>>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
>>>
>>> at
>>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
>>>
>>> at
>>> java.lang.reflect.Constructor.newInstance(Constructor.java:513)
>>> at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
>>> at com.mysql.jdbc.Util.getInstance(Util.java:382)
>>> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
>>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
>>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
>>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
>>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
>>> at
>>> com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
>>> at
>>> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
>>>
>>> at
>>> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2273)
>>>
>>> at
>>> com.sun.gjc.spi.jdbc40.PreparedStatementWrapper40.executeQuery(PreparedStatementWrapper40.java:646)
>>>
>>> at
>>> org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:889)
>>>
>>> at
>>> org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:598)
>>>
>>> ... 124 more
>>> |#]
>>>
>>>
>>>
>>> On 11-02-03 12:38 AM, Derek Knapp wrote:
>>>
>>>> I had the table there from when I was using glassfish 3.0.1. I did
>>>> try to delete it, and then restart the server, but it did not
>>>> recreate the table for me.
>>>>
>>>> I will try again and let you know how it goes.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On 11-02-03 12:03 AM, Marina Vatkina wrote:
>>>>
>>>>> Why don't you let EJB timer service create its own table? In 3.1 we
>>>>> indeed added APPLICATIONID to the table to be able to cleanup timers
>>>>> on application undeploy once per cluster.
>>>>>
>>>>> -marina
>>>>>
>>>>> Derek Knapp wrote:
>>>>>
>>>>>> that stack trace is really ugly, I think this is the important part
>>>>>>
>>>>>> Internal Exception:
>>>>>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown
>>>>>> column 'APPLICATIONID' in 'field list'
>>>>>>
>>>>>>
>>>>>> Derek
>>>>>>
>>>>>> On 11-02-02 11:37 PM, derek_at_itracmedia.com wrote:
>>>>>>
>>>>>>> get the following exception when setting ejb timer service jndi name
>>>>>>>
>>>>>>>
>>>>>>> here is glassfish/lib/install/databases/ejbtimer_mysql.sql
>>>>>>>
>>>>>>> CREATE TABLE EJB__TIMER__TBL (
>>>>>>> `CREATIONTIMERAW` BIGINT NOT NULL,
>>>>>>> `BLOB` BLOB,
>>>>>>> `TIMERID` VARCHAR(255) NOT NULL,
>>>>>>> `CONTAINERID` BIGINT NOT NULL,
>>>>>>> `OWNERID` VARCHAR(255) NULL,
>>>>>>> `STATE` INTEGER NOT NULL,
>>>>>>> `PKHASHCODE` INTEGER NOT NULL,
>>>>>>> `INTERVALDURATION` BIGINT NOT NULL,
>>>>>>> `INITIALEXPIRATIONRAW` BIGINT NOT NULL,
>>>>>>> `LASTEXPIRATIONRAW` BIGINT NOT NULL,
>>>>>>> `SCHEDULE` VARCHAR(255) NULL,
>>>>>>> CONSTRAINT `PK_EJB__TIMER__TBL` PRIMARY KEY (`TIMERID`)
>>>>>>> );
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> and the stack trace
>>>>>>>
>>>>>>> [#|2011-02-02T23:30:20.742-0500|WARNING|glassfish3.1|javax.enterprise.s
>>>>>>>
>>>>>>> ystem.container.ejb.com.sun.ejb.containers|_ThreadID=69;_ThreadName=Thr
>>>>>>>
>>>>>>> ead-1;|A system exception occurred during an invocation on EJB
>>>>>>> TimerBean method public java.util.Set
>>>>>>> com.sun.ejb.containers.TimerBean.findActiveTimersOwnedByThisServer()
>>>>>>> javax.ejb.EJBException
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.ejb.containers.BaseContainer.processSystemException(BaseContain
>>>>>>>
>>>>>>> er.java:5194)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:5
>>>>>>>
>>>>>>> 092)
>>>>>>> at
>>>>>>> com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:48
>>>>>>>
>>>>>>> 80)
>>>>>>> at
>>>>>>> com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:2039
>>>>>>>
>>>>>>> )
>>>>>>> at
>>>>>>> com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1990
>>>>>>>
>>>>>>> )
>>>>>>> at
>>>>>>> com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalO
>>>>>>>
>>>>>>> bjectInvocationHandler.java:222)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(E
>>>>>>>
>>>>>>> JBLocalObjectInvocationHandlerDelegate.java:88)
>>>>>>>
>>>>>>> at $Proxy319.findActiveTimersOwnedByThisServer(Unknown Source)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.ejb.containers.EJBTimerService.restoreEJBTimers(EJBTimerService
>>>>>>>
>>>>>>> .java:489)
>>>>>>> at
>>>>>>> com.sun.ejb.containers.EjbContainerUtilImpl.getEJBTimerService(EjbConta
>>>>>>>
>>>>>>> inerUtilImpl.java:302)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.ejb.containers.EjbContainerUtilImpl.getEJBTimerService(EjbConta
>>>>>>>
>>>>>>> inerUtilImpl.java:284)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.ejb.containers.EjbContainerUtilImpl.getEJBTimerService(EjbConta
>>>>>>>
>>>>>>> inerUtilImpl.java:269)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.ejb.containers.BaseContainer.<init>(BaseContainer.java:755)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.ejb.containers.StatelessSessionContainer.<init>(StatelessSessio
>>>>>>>
>>>>>>> nContainer.java:155)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.ejb.containers.StatelessSessionContainer.<init>(StatelessSessio
>>>>>>>
>>>>>>> nContainer.java:149)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.ejb.containers.ContainerFactoryImpl.createContainer(ContainerFa
>>>>>>>
>>>>>>> ctoryImpl.java:105)
>>>>>>>
>>>>>>> at
>>>>>>> org.glassfish.ejb.startup.EjbApplication.loadContainers(EjbApplication.
>>>>>>>
>>>>>>> java:234)
>>>>>>> at
>>>>>>> org.glassfish.ejb.startup.EjbDeployer.load(EjbDeployer.java:290)
>>>>>>>
>>>>>>> at
>>>>>>> org.glassfish.ejb.startup.EjbDeployer.load(EjbDeployer.java:101)
>>>>>>>
>>>>>>> at
>>>>>>> org.glassfish.internal.data.ModuleInfo.load(ModuleInfo.java:186)
>>>>>>>
>>>>>>> at
>>>>>>> org.glassfish.internal.data.ApplicationInfo.load(ApplicationInfo.java:2
>>>>>>>
>>>>>>> 49)
>>>>>>> at
>>>>>>> com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLif
>>>>>>>
>>>>>>> ecycle.java:460)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLif
>>>>>>>
>>>>>>> ecycle.java:240)
>>>>>>>
>>>>>>> at
>>>>>>> org.glassfish.deployment.admin.DeployCommand.execute(DeployCommand.java
>>>>>>>
>>>>>>> :370)
>>>>>>> at
>>>>>>> com.sun.enterprise.v3.admin.CommandRunnerImpl$1.execute(CommandRunnerIm
>>>>>>>
>>>>>>> pl.java:354)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerIm
>>>>>>>
>>>>>>> pl.java:369)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerIm
>>>>>>>
>>>>>>> pl.java:1080)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.enterprise.v3.admin.CommandRunnerImpl.access$1200(CommandRunner
>>>>>>>
>>>>>>> Impl.java:95)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(
>>>>>>>
>>>>>>> CommandRunnerImpl.java:1260)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(
>>>>>>>
>>>>>>> CommandRunnerImpl.java:1248)
>>>>>>>
>>>>>>> at
>>>>>>> org.glassfish.admingui.common.util.LocalDeploymentFacility$LocalDFComma
>>>>>>>
>>>>>>> ndRunner.run(LocalDeploymentFacility.java:143)
>>>>>>>
>>>>>>> at
>>>>>>> org.glassfish.deployment.client.AbstractDeploymentFacility.deploy(Abstr
>>>>>>>
>>>>>>> actDeploymentFacility.java:406)
>>>>>>>
>>>>>>> at
>>>>>>> org.glassfish.admingui.common.util.DeployUtil.invokeDeploymentFacility(
>>>>>>>
>>>>>>> DeployUtil.java:100)
>>>>>>>
>>>>>>> at
>>>>>>> org.glassfish.admingui.common.util.DeployUtil.deploy(DeployUtil.java:76
>>>>>>>
>>>>>>> )
>>>>>>> at
>>>>>>> org.glassfish.admingui.common.handlers.DeploymentHandler.deploy(Deploym
>>>>>>>
>>>>>>> entHandler.java:191)
>>>>>>>
>>>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>>>>>
>>>>>>> at
>>>>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.ja
>>>>>>>
>>>>>>> va:39)
>>>>>>> at
>>>>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso
>>>>>>>
>>>>>>> rImpl.java:25)
>>>>>>>
>>>>>>> at java.lang.reflect.Method.invoke(Method.java:597)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.jsftemplating.layout.descriptors.handler.Handler.invoke(Handler
>>>>>>>
>>>>>>> .java:442)
>>>>>>> at
>>>>>>> com.sun.jsftemplating.layout.descriptors.LayoutElementBase.dispatchHand
>>>>>>>
>>>>>>> lers(LayoutElementBase.java:420)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.jsftemplating.layout.descriptors.LayoutElementBase.dispatchHand
>>>>>>>
>>>>>>> lers(LayoutElementBase.java:394)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.jsftemplating.layout.event.CommandActionListener.invokeCommandH
>>>>>>>
>>>>>>> andlers(CommandActionListener.java:150)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.jsftemplating.layout.event.CommandActionListener.processAction(
>>>>>>>
>>>>>>> CommandActionListener.java:98)
>>>>>>>
>>>>>>> at
>>>>>>> javax.faces.event.ActionEvent.processListener(ActionEvent.java:88)
>>>>>>>
>>>>>>> at
>>>>>>> javax.faces.component.UIComponentBase.broadcast(UIComponentBase.java:77
>>>>>>>
>>>>>>> 7)
>>>>>>> at
>>>>>>> javax.faces.component.UICommand.broadcast(UICommand.java:300)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.webui.jsf.component.WebuiCommand.broadcast(WebuiCommand.java:16
>>>>>>>
>>>>>>> 6)
>>>>>>> at
>>>>>>> javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:787)
>>>>>>>
>>>>>>> at
>>>>>>> javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:125
>>>>>>>
>>>>>>> 2)
>>>>>>> at
>>>>>>> com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicatio
>>>>>>>
>>>>>>> nPhase.java:81)
>>>>>>>
>>>>>>> at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
>>>>>>>
>>>>>>> at
>>>>>>> javax.faces.webapp.FacesServlet.service(FacesServlet.java:312)
>>>>>>>
>>>>>>> at
>>>>>>> org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1
>>>>>>>
>>>>>>> 534)
>>>>>>> at
>>>>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic
>>>>>>>
>>>>>>> ationFilterChain.java:343)
>>>>>>>
>>>>>>> at
>>>>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil
>>>>>>>
>>>>>>> terChain.java:215)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.webui.jsf.util.UploadFilter.doFilter(UploadFilter.java:223)
>>>>>>>
>>>>>>> at
>>>>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic
>>>>>>>
>>>>>>> ationFilterChain.java:256)
>>>>>>>
>>>>>>> at
>>>>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil
>>>>>>>
>>>>>>> terChain.java:215)
>>>>>>>
>>>>>>> at
>>>>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal
>>>>>>>
>>>>>>> ve.java:279)
>>>>>>>
>>>>>>> at
>>>>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextVal
>>>>>>>
>>>>>>> ve.java:175)
>>>>>>>
>>>>>>> at
>>>>>>> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.jav
>>>>>>>
>>>>>>> a:655)
>>>>>>> at
>>>>>>> org.apache.catalina.core.StandardPipeline.doChainInvoke(StandardPipelin
>>>>>>>
>>>>>>> e.java:600)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:96)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessio
>>>>>>>
>>>>>>> nLockingStandardPipeline.java:91)
>>>>>>>
>>>>>>> at
>>>>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jav
>>>>>>>
>>>>>>> a:162)
>>>>>>> at
>>>>>>> org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.jav
>>>>>>>
>>>>>>> a:326)
>>>>>>> at
>>>>>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:
>>>>>>>
>>>>>>> 227)
>>>>>>> at
>>>>>>> com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMa
>>>>>>>
>>>>>>> pper.java:228)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:822
>>>>>>>
>>>>>>> )
>>>>>>> at
>>>>>>> com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:719)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1013)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilte
>>>>>>>
>>>>>>> r.java:225)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProto
>>>>>>>
>>>>>>> colChain.java:137)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:
>>>>>>>
>>>>>>> 104)
>>>>>>> at
>>>>>>> com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:
>>>>>>>
>>>>>>> 90)
>>>>>>> at
>>>>>>> com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:7
>>>>>>>
>>>>>>> 9)
>>>>>>> at
>>>>>>> com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTas
>>>>>>>
>>>>>>> k.java:54)
>>>>>>> at
>>>>>>> com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.ja
>>>>>>>
>>>>>>> va:59)
>>>>>>> at
>>>>>>> com.sun.grizzly.ContextTask.run(ContextTask.java:71)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPoo
>>>>>>>
>>>>>>> l.java:532)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.j
>>>>>>>
>>>>>>> ava:513)
>>>>>>> at
>>>>>>> java.lang.Thread.run(Thread.java:619)
>>>>>>>
>>>>>>> Caused by: Exception
>>>>>>> [EclipseLink-4002] (Eclipse Persistence Services -
>>>>>>> 2.2.0.v20110114-r8831):
>>>>>>> org.eclipse.persistence.exceptions.DatabaseException
>>>>>>>
>>>>>>> Internal Exception:
>>>>>>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown
>>>>>>> column 'APPLICATIONID' in 'field list'
>>>>>>>
>>>>>>> Error Code: 1054
>>>>>>>
>>>>>>> Call: SELECT `TIMERID`,
>>>>>>> `APPLICATIONID`, `BLOB`, `CONTAINERID`,
>>>>>>> `CREATIONTIMERAW`, `INITIALEXPIRATIONRAW`, `INTERVALDURATION`,
>>>>>>> `LASTEXPIRATIONRAW`, `OWNERID`, `PKHASHCODE`, `SCHEDULE`, `STATE`
>>>>>>> FROM
>>>>>>> `EJB__TIMER__TBL` WHERE ((`OWNERID` = ?) AND (`STATE` = ?))
>>>>>>> bind => [2 parameters bound]
>>>>>>>
>>>>>>> Query:
>>>>>>> ReadAllQuery(name="findTimersByOwnerAndState"
>>>>>>> referenceClass=TimerState sql="SELECT `TIMERID`, `APPLICATIONID`,
>>>>>>> `BLOB`, `CONTAINERID`, `CREATIONTIMERAW`, `INITIALEXPIRATIONRAW`,
>>>>>>> `INTERVALDURATION`, `LASTEXPIRATIONRAW`, `OWNERID`, `PKHASHCODE`,
>>>>>>> `SCHEDULE`, `STATE` FROM `EJB__TIMER__TBL` WHERE ((`OWNERID` = ?) AND
>>>>>>> (`STATE` = ?))")
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.exceptions.DatabaseException.sqlException(Datab
>>>>>>>
>>>>>>> aseException.java:333)
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicE
>>>>>>>
>>>>>>> xecuteCall(DatabaseAccessor.java:684)
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.execut
>>>>>>>
>>>>>>> eCall(DatabaseAccessor.java:526)
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteC
>>>>>>>
>>>>>>> all(AbstractSession.java:1729)
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.sessions.server.ServerSession.executeCall(Serve
>>>>>>>
>>>>>>> rSession.java:566)
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.sessions.server.ClientSession.executeCall(Clien
>>>>>>>
>>>>>>> tSession.java:207)
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.e
>>>>>>>
>>>>>>> xecuteCall(DatasourceCallQueryMechanism.java:207)
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.e
>>>>>>>
>>>>>>> xecuteCall(DatasourceCallQueryMechanism.java:193)
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.e
>>>>>>>
>>>>>>> xecuteSelectCall(DatasourceCallQueryMechanism.java:264)
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.s
>>>>>>>
>>>>>>> electAllRows(DatasourceCallQueryMechanism.java:647)
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selec
>>>>>>>
>>>>>>> tAllRowsFromTable(ExpressionQueryMechanism.java:2558)
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selec
>>>>>>>
>>>>>>> tAllRows(ExpressionQueryMechanism.java:2517)
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuer
>>>>>>>
>>>>>>> y(ReadAllQuery.java:410)
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQue
>>>>>>>
>>>>>>> ry(ObjectLevelReadQuery.java:1080)
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.jav
>>>>>>>
>>>>>>> a:808)
>>>>>>> at
>>>>>>> org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLeve
>>>>>>>
>>>>>>> lReadQuery.java:1040)
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:
>>>>>>>
>>>>>>> 383)
>>>>>>> at
>>>>>>> org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWor
>>>>>>>
>>>>>>> k(ObjectLevelReadQuery.java:1126)
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecut
>>>>>>>
>>>>>>> eQuery(UnitOfWorkImpl.java:2842)
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(
>>>>>>>
>>>>>>> AbstractSession.java:1521)
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(
>>>>>>>
>>>>>>> AbstractSession.java:1503)
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(
>>>>>>>
>>>>>>> AbstractSession.java:1477)
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeReadQuery(EJBQ
>>>>>>>
>>>>>>> ueryImpl.java:484)
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.internal.jpa.EJBQueryImpl.getResultList(EJBQuer
>>>>>>>
>>>>>>> yImpl.java:741)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.ejb.containers.TimerBean.findTimersByOwnerAndState(TimerBean.ja
>>>>>>>
>>>>>>> va:204)
>>>>>>> at
>>>>>>> com.sun.ejb.containers.TimerBean.findActiveTimersOwnedByThisServer(Time
>>>>>>>
>>>>>>> rBean.java:518)
>>>>>>>
>>>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
>>>>>>> Method)
>>>>>>>
>>>>>>> at
>>>>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.ja
>>>>>>>
>>>>>>> va:39)
>>>>>>> at
>>>>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso
>>>>>>>
>>>>>>> rImpl.java:25)
>>>>>>>
>>>>>>> at java.lang.reflect.Method.invoke(Method.java:597)
>>>>>>>
>>>>>>> at
>>>>>>> org.glassfish.ejb.security.application.EJBSecurityManager.runMethod(EJB
>>>>>>>
>>>>>>> SecurityManager.java:1052)
>>>>>>>
>>>>>>> at
>>>>>>> org.glassfish.ejb.security.application.EJBSecurityManager.invoke(EJBSec
>>>>>>>
>>>>>>> urityManager.java:1124)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.ejb.containers.BaseContainer.invokeBeanMethod(BaseContainer.jav
>>>>>>>
>>>>>>> a:5367)
>>>>>>> at
>>>>>>> com.sun.ejb.EjbInvocation.invokeBeanMethod(EjbInvocation.java:619)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(In
>>>>>>>
>>>>>>> terceptorManager.java:801)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:571)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.ejb.containers.interceptors.SystemInterceptorProxy.doAround(Sys
>>>>>>>
>>>>>>> temInterceptorProxy.java:162)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.ejb.containers.interceptors.SystemInterceptorProxy.aroundInvoke
>>>>>>>
>>>>>>> (SystemInterceptorProxy.java:144)
>>>>>>>
>>>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
>>>>>>> Method)
>>>>>>>
>>>>>>> at
>>>>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.ja
>>>>>>>
>>>>>>> va:39)
>>>>>>> at
>>>>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso
>>>>>>>
>>>>>>> rImpl.java:25)
>>>>>>>
>>>>>>> at java.lang.reflect.Method.invoke(Method.java:597)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(I
>>>>>>>
>>>>>>> nterceptorManager.java:862)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(In
>>>>>>>
>>>>>>> terceptorManager.java:801)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.ejb.containers.interceptors.InterceptorManager.intercept(Interc
>>>>>>>
>>>>>>> eptorManager.java:371)
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.ejb.containers.BaseContainer.__intercept(BaseContainer.java:533
>>>>>>>
>>>>>>> 9)
>>>>>>> at
>>>>>>> com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:5327)
>>>>>>>
>>>>>>>
>>>>>>> at
>>>>>>> com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalO
>>>>>>>
>>>>>>> bjectInvocationHandler.java:214)
>>>>>>>
>>>>>>> ... 78 more
>>>>>>>
>>>>>>> Caused by:
>>>>>>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
>>>>>>> Unknown column 'APPLICATIONID' in 'field list'
>>>>>>>
>>>>>>> at
>>>>>>> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>>>>>>>
>>>>>>> at
>>>>>>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructor
>>>>>>>
>>>>>>> AccessorImpl.java:39)
>>>>>>>
>>>>>>> at
>>>>>>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCon
>>>>>>>
>>>>>>> structorAccessorImpl.java:27)
>>>>>>>
>>>>>>> at
>>>>>>> java.lang.reflect.Constructor.newInstance(Constructor.java:513)
>>>>>>>
>>>>>>> at
>>>>>>> com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
>>>>>>>
>>>>>>> at
>>>>>>> com.mysql.jdbc.Util.getInstance(Util.java:382)
>>>>>>>
>>>>>>> at
>>>>>>> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
>>>>>>>
>>>>>>> at
>>>>>>> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
>>>>>>>
>>>>>>> at
>>>>>>> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
>>>>>>>
>>>>>>> at
>>>>>>> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
>>>>>>>
>>>>>>> at
>>>>>>> com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
>>>>>>>
>>>>>>> at
>>>>>>> com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
>>>>>>>
>>>>>>> at
>>>>>>> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java
>>>>>>>
>>>>>>> :2111)
>>>>>>> at
>>>>>>> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:22
>>>>>>>
>>>>>>> 73)
>>>>>>> at
>>>>>>> com.sun.gjc.spi.jdbc40.PreparedStatementWrapper40.executeQuery(Prepared
>>>>>>>
>>>>>>> StatementWrapper40.java:646)
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.execut
>>>>>>>
>>>>>>> eSelect(DatabaseAccessor.java:889)
>>>>>>>
>>>>>>> at
>>>>>>> org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicE
>>>>>>>
>>>>>>> xecuteCall(DatabaseAccessor.java:598)
>>>>>>>
>>>>>>> ... 124 more
>>>>>>>
>>>>>>> |#]
>>>>>>>
>
>
>