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
>
>
>
>
> |#]