hai

when i am trying to run ejb-ql in jboss i am getting runtime exception..........

this is the query

CDATA[SELECT OBJECT(a) FROM PartnerCpaStatBean AS a WHERE a.userName = ?1 AND a.depositTime > ?2 AND a.signUpTime < ?3]

and i am getting this exception.................


09:12:48,343 INFO [STDOUT] org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered ">" at
line 1, column 87.
Was expecting one of:
"=" ...
"<>" ...

09:12:48,343 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.generateParseEx
ception(EJBQLParser.java:4485)
09:12:48,343 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.jj_consume_toke
n(EJBQLParser.java:4366)
09:12:48,343 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.ComparisonExpre
ssion(EJBQLParser.java:1257)
09:12:48,343 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.SimpleCondExpre
ssion(EJBQLParser.java:854)
09:12:48,343 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.ConditionalPrim
ary(EJBQLParser.java:811)
09:12:48,343 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.ConditionalTest
(EJBQLParser.java:779)
09:12:48,343 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.ConditionalFact
or(EJBQLParser.java:756)
09:12:48,343 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.WhereConditiona
lTerm(EJBQLParser.java:615)
09:12:48,359 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.WhereExpression
(EJBQLParser.java:558)
09:12:48,359 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.WhereClause(EJB
QLParser.java:522)
09:12:48,359 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.EJBQL(EJBQLPars
er.java:107)
09:12:48,359 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.parse(EJBQLPars
er.java:65)
09:12:48,359 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler.compileEJB
QL(JDBCEJBQLCompiler.java:151)
09:12:48,359 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.(JDBCEJ
BQLQuery.java:43)
09:12:48,359 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJB
QLQuery(JDBCCommandFactory.java:60)
09:12:48,359 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQ
ueryManager.java:266)
09:12:48,359 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreM
anager(JDBCStoreManager.java:498)
09:12:48,359 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCS
toreManager.java:396)
09:12:48,359 INFO [STDOUT] at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersis
tenceManager.java:147)
09:12:48,359 INFO [STDOUT] at org.jboss.ejb.EntityContainer.startService(EntityContainer.
java:337)
09:12:48,359 INFO [STDOUT] at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(Ser
viceMBeanSupport.java:271)
09:12:48,359 INFO [STDOUT] at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle
(ServiceMBeanSupport.java:221)
09:12:48,359 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source
)
09:12:48,359 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingM
ethodAccessorImpl.java:25)
09:12:48,359 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedD
ispatcher.java:60)
09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)

09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)

09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBe
anInvoker.java:185)
09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.
java:473)
09:12:48,359 INFO [STDOUT] at org.jboss.system.ServiceController$ServiceProxy.invoke(Serv
iceController.java:837)
09:12:48,359 INFO [STDOUT] at $Proxy17.start(Unknown Source)
09:12:48,359 INFO [STDOUT] at org.jboss.system.ServiceController.start(ServiceController.
java:367)
09:12:48,359 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)

09:12:48,359 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingM
ethodAccessorImpl.java:25)
09:12:48,359 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedD
ispatcher.java:60)
09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)

09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)

09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBe
anInvoker.java:185)
09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.
java:473)
09:12:48,359 INFO [STDOUT] at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:1
76)
09:12:48,359 INFO [STDOUT] at $Proxy36.start(Unknown Source)
09:12:48,359 INFO [STDOUT] at org.jboss.ejb.EjbModule.startService(EjbModule.java:367)
09:12:48,359 INFO [STDOUT] at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(Ser
viceMBeanSupport.java:271)
09:12:48,359 INFO [STDOUT] at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle
(ServiceMBeanSupport.java:221)
09:12:48,359 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source
)
09:12:48,359 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingM
ethodAccessorImpl.java:25)
09:12:48,359 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedD
ispatcher.java:60)
09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)

09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)

09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBe
anInvoker.java:185)
09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.
java:473)
09:12:48,359 INFO [STDOUT] at org.jboss.system.ServiceController$ServiceProxy.invoke(Serv
iceController.java:837)
09:12:48,359 INFO [STDOUT] at $Proxy17.start(Unknown Source)
09:12:48,359 INFO [STDOUT] at org.jboss.system.ServiceController.start(ServiceController.
java:367)
09:12:48,359 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)

09:12:48,359 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingM
ethodAccessorImpl.java:25)
09:12:48,359 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedD
ispatcher.java:60)
09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)

09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)

09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBe
anInvoker.java:185)
09:12:48,359 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.
java:473)
09:12:48,359 INFO [STDOUT] at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:1
76)
09:12:48,359 INFO [STDOUT] at $Proxy14.start(Unknown Source)
09:12:48,359 INFO [STDOUT] at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:570)
09:12:48,359 INFO [STDOUT] at org.jboss.deployment.MainDeployer.start(MainDeployer.java:8
36)
09:12:48,359 INFO [STDOUT] at org.jboss.deployment.MainDeployer.start(MainDeployer.java:8
28)
09:12:48,375 INFO [STDOUT] at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:
645)
09:12:48,375 INFO [STDOUT] at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:
608)
09:12:48,375 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor17.invoke(Unknown Source
)
09:12:48,375 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingM
ethodAccessorImpl.java:25)
09:12:48,375 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedD
ispatcher.java:60)
09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)

09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)

09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBe
anInvoker.java:185)
09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.
java:473)
09:12:48,375 INFO [STDOUT] at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:1
76)
09:12:48,375 INFO [STDOUT] at $Proxy7.deploy(Unknown Source)
09:12:48,375 INFO [STDOUT] at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(UR
LDeploymentScanner.java:304)
09:12:48,375 INFO [STDOUT] at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLD
eploymentScanner.java:478)
09:12:48,375 INFO [STDOUT] at org.jboss.deployment.scanner.AbstractDeploymentScanner$Scan
nerThread.doScan(AbstractDeploymentScanner.java:201)
09:12:48,375 INFO [STDOUT] at org.jboss.deployment.scanner.AbstractDeploymentScanner.star
tService(AbstractDeploymentScanner.java:274)
09:12:48,375 INFO [STDOUT] at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(Ser
viceMBeanSupport.java:271)
09:12:48,375 INFO [STDOUT] at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle
(ServiceMBeanSupport.java:221)
09:12:48,375 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

09:12:48,375 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcc
essorImpl.java:39)
09:12:48,375 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingM
ethodAccessorImpl.java:25)
09:12:48,375 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedD
ispatcher.java:60)
09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)

09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)

09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBe
anInvoker.java:185)
09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.
java:473)
09:12:48,375 INFO [STDOUT] at org.jboss.system.ServiceController$ServiceProxy.invoke(Serv
iceController.java:837)
09:12:48,375 INFO [STDOUT] at $Proxy0.start(Unknown Source)
09:12:48,375 INFO [STDOUT] at org.jboss.system.ServiceController.start(ServiceController.
java:367)
09:12:48,375 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)

09:12:48,375 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingM
ethodAccessorImpl.java:25)
09:12:48,375 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedD
ispatcher.java:60)
09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)

09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)

09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBe
anInvoker.java:185)
09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.
java:473)
09:12:48,375 INFO [STDOUT] at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:1
76)
09:12:48,375 INFO [STDOUT] at $Proxy4.start(Unknown Source)
09:12:48,375 INFO [STDOUT] at org.jboss.deployment.SARDeployer.start(SARDeployer.java:251
)
09:12:48,375 INFO [STDOUT] at org.jboss.deployment.MainDeployer.start(MainDeployer.java:8
36)
09:12:48,375 INFO [STDOUT] at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:
645)
09:12:48,375 INFO [STDOUT] at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:
608)
09:12:48,375 INFO [STDOUT] at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:
592)
09:12:48,375 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

09:12:48,375 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcc
essorImpl.java:39)
09:12:48,375 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingM
ethodAccessorImpl.java:25)
09:12:48,375 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedD
ispatcher.java:60)
09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)

09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)

09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBe
anInvoker.java:185)
09:12:48,375 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.
java:473)
09:12:48,375 INFO [STDOUT] at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:1
76)
09:12:48,375 INFO [STDOUT] at $Proxy5.deploy(Unknown Source)
09:12:48,375 INFO [STDOUT] at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:
407)
09:12:48,375 INFO [STDOUT] at org.jboss.system.server.ServerImpl.start(ServerImpl.java:31
1)
09:12:48,375 INFO [STDOUT] at org.jboss.Main.boot(Main.java:144)
09:12:48,375 INFO [STDOUT] at org.jboss.Main$1.run(Main.java:389)
09:12:48,375 INFO [STDOUT] at java.lang.Thread.run(Thread.java:534)
09:12:48,390 ERROR [EntityContainer] Starting failed jboss.j2ee:jndiName=ejb-SkillSegmenter,se
rvice=EJB
org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT OBJECT(a) F
ROM PartnerCpaStatBean AS a WHERE a.userName = ?1 AND a.depositTime > ?2 AND a.signUpTime < ?3
'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered ">" at lin
e 1, column 87.
Was expecting one of:
"=" ...
"<>" ...
)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.(JDBCEJBQLQuery.java:52)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJBQLQuery(JDBCCommandFacto
ry.java:60)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.java:266)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.
java:498)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:396)
at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:147)
at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:337)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:27
1)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.jav
a:221)
at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:2
5)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:837)
at $Proxy17.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:367)
at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:2
5)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
at $Proxy36.start(Unknown Source)
at org.jboss.ejb.EjbModule.startService(EjbModule.java:367)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:27
1)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.jav
a:221)
at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:2
5)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:837)
at $Proxy17.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:367)
at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:2
5)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
at $Proxy14.start(Unknown Source)
at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:570)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:836)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:828)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:645)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:608)
at sun.reflect.GeneratedMethodAccessor17.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:2
5)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
at $Proxy7.deploy(Unknown Source)
at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:
304)
at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:47
8)
at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(Abstrac
tDeploymentScanner.java:201)
at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploym
entScanner.java:274)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:27
1)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.jav
a:221)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:2
5)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:837)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:367)
at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:2
5)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
at $Proxy4.start(Unknown Source)
at org.jboss.deployment.SARDeployer.start(SARDeployer.java:251)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:836)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:645)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:608)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:592)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:2
5)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
at $Proxy5.deploy(Unknown Source)
at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:407)
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:311)
at org.jboss.Main.boot(Main.java:144)
at org.jboss.Main$1.run(Main.java:389)
at java.lang.Thread.run(Thread.java:534)
Caused by: org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered ">" at line 1, column 8
7.
Was expecting one of:
"=" ...
"<>" ...

at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.generateParseException(EJBQLParser.java
:4485)
at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.jj_consume_token(EJBQLParser.java:4366)

at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.ComparisonExpression(EJBQLParser.java:1
257)
at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.SimpleCondExpression(EJBQLParser.java:8
54)
at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.ConditionalPrimary(EJBQLParser.java:811
)
at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.ConditionalTest(EJBQLParser.java:779)
at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.ConditionalFactor(EJBQLParser.java:756)

at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.WhereConditionalTerm(EJBQLParser.java:6
15)
at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.WhereExpression(EJBQLParser.java:558)
at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.WhereClause(EJBQLParser.java:522)
at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.EJBQL(EJBQLParser.java:107)
at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.parse(EJBQLParser.java:65)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler.compileEJBQL(JDBCEJBQLCompiler.jav
a:151)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.(JDBCEJBQLQuery.java:43)
... 125 more
09:12:48,406 WARN [ServiceController] Problem starting service jboss.j2ee:jndiName=ejb-SkillS
egmenter,service=EJB
MBeanException: org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SE
LECT OBJECT(a) FROM PartnerCpaStatBean AS a WHERE a.userName = ?1 AND a.depositTime > ?2 AND a
.signUpTime < ?3'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encoun
tered ">" at line 1, column 87.
Was expecting one of:
"=" ...
"<>" ...
)
Cause: org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT OBJE
CT(a) FROM PartnerCpaStatBean AS a WHERE a.userName = ?1 AND a.depositTime > ?2 AND a.signUpTi
me < ?3'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered ">"
at line 1, column 87.
Was expecting one of:
"=" ...
"<>" ...
)
at org.jboss.mx.server.ReflectedDispatcher.handleInvocationExceptions(ReflectedDispatc
her.java:91)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:64)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:837)
at $Proxy17.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:367)
at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:2
5)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
at $Proxy36.start(Unknown Source)
at org.jboss.ejb.EjbModule.startService(EjbModule.java:367)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:27
1)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.jav
a:221)
at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:2
5)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:837)
at $Proxy17.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:367)
at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:2
5)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
at $Proxy14.start(Unknown Source)
at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:570)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:836)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:828)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:645)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:608)
at sun.reflect.GeneratedMethodAccessor17.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:2
5)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
at $Proxy7.deploy(Unknown Source)
at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:
304)
at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:47
8)
at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(Abstrac
tDeploymentScanner.java:201)
at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploym
entScanner.java:274)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:27
1)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.jav
a:221)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:2
5)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:837)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:367)
at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:2
5)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
at $Proxy4.start(Unknown Source)
at org.jboss.deployment.SARDeployer.start(SARDeployer.java:251)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:836)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:645)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:608)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:592)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:2
5)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
at $Proxy5.deploy(Unknown Source)
at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:407)
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:311)
at org.jboss.Main.boot(Main.java:144)
at org.jboss.Main$1.run(Main.java:389)
at java.lang.Thread.run(Thread.java:534)
Caused by: org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT
OBJECT(a) FROM PartnerCpaStatBean AS a WHERE a.userName = ?1 AND a.depositTime > ?2 AND a.sign
UpTime < ?3'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered
">" at line 1, column 87.
Was expecting one of:
"=" ...
"<>" ...
)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.(JDBCEJBQLQuery.java:52)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJBQLQuery(JDBCCommandFacto
ry.java:60)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.java:266)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.
java:498)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:396)
at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:147)
at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:337)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:27
1)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.jav
a:221)
at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:2
5)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
... 113 more
Caused by: org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered ">" at line 1, column 8
7.
Was expecting one of:
"=" ...
"<>" ...

at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.generateParseException(EJBQLParser.java
:4485)
at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.jj_consume_token(EJBQLParser.java:4366)

at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.ComparisonExpression(EJBQLParser.java:1
257)
at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.SimpleCondExpression(EJBQLParser.java:8
54)
at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.ConditionalPrimary(EJBQLParser.java:811
)
at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.ConditionalTest(EJBQLParser.java:779)
at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.ConditionalFactor(EJBQLParser.java:756)

at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.WhereConditionalTerm(EJBQLParser.java:6
15)
at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.WhereExpression(EJBQLParser.java:558)
at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.WhereClause(EJBQLParser.java:522)
at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.EJBQL(EJBQLParser.java:107)
at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.parse(EJBQLParser.java:65)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler.compileEJBQL(JDBCEJBQLCompiler.jav
a:151)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.(JDBCEJBQLQuery.java:43)
... 125 more
09:12:48,781 INFO [EJBDeployer] Deployed: file:/D:/jboss-3.2.4/server/default/tmp/deploy/tmp6
0238pixelfixx.ear-contents/pixelfixx.jar
09:12:49,046 INFO [TomcatDeployer] deploy, ctxPath=, warUrl=file:/D:/jboss-3.2.4/server/defau
lt/tmp/deploy/tmp60238pixelfixx.ear-contents/pixelfixx.war/


any solution........

Thanks for your help
bill