Hello all,
I had the same missing-datasource-problem due to the incorrect entry in 
hsqldb-ds.xml file.
After I fixed it, the deployment of the bank ear file worked. But I still got 
some errors. 
Here is a part of the log file:

 
  | 2005-11-02 17:04:54,613 ERROR [org.jboss.ejb.EntityContainer] Starting 
failed jboss.j2ee:jndiName=ebankNextId,service=EJB
  | org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 
'select object(t) from TxBean t 
  |                     where t.account.accountId = ?3 and (t.timeStamp >= ?1 
and  t.timeStamp <= ?2)'; - nested throwable: 
(org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "t.timeStamp >=" 
at line 2, column 59.
  | Was expecting one of:
  |     "ABS" ...
  |     "LENGTH" ...
  |     "LOCATE" ...
  |     "SQRT" ...
  |     "MOD" ...
  |     "(" ...
  |     "+" ...
  |     "-" ...
  |     <INTEGER_LITERAL> ...
  |     <FLOATING_POINT_LITERAL> ...
  |     <NUMERIC_VALUED_PARAMETER> ...
  |     <NUMERIC_VALUED_PATH> ...
  |     "NOT" ...
  |     <COLLECTION_VALUED_PATH> ...
  |     <STRING_VALUED_PATH> ...
  |     "CONCAT" ...
  |     "SUBSTRING" ...
  |     <BOOLEAN_VALUED_PATH> ...
  |     <DATETIME_VALUED_PATH> "=" ...
  |     <DATETIME_VALUED_PATH> ">" ...
  |     <DATETIME_VALUED_PATH> "<" ...
  |     <DATETIME_VALUED_PATH> "<>" ...
  |     <ENTITY_VALUED_PATH> ...
  |     <IDENTIFICATION_VARIABLE> ...
  |     )
  |     at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.<init>(JDBCEJBQLQuery.java:52)
  |     at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJBQLQuery(JDBCCommandFactory.java:60)
  |     at 
org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.java:271)
  |     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:157)
  |     at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:348)
  |     at 
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271)
  |     at 
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:221)
  |     at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
  |     at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  |     at java.lang.reflect.Method.invoke(Method.java:324)
  |     at 
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
  |     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
  |     at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
  |     at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:230)
  |     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
  |     at 
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:844)
  |     at $Proxy18.start(Unknown Source)
  |     at org.jboss.system.ServiceController.start(ServiceController.java:369)
  |     at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)
  |     at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  |     at java.lang.reflect.Method.invoke(Method.java:324)
  |     at 
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
  |     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
  |     at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
  |     at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:230)
  |     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
  |     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
  |     at $Proxy51.start(Unknown Source)
  |     at org.jboss.ejb.EjbModule.startService(EjbModule.java:394)
  |     at 
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271)
  |     at 
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:221)
  |     at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
  |     at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  |     at java.lang.reflect.Method.invoke(Method.java:324)
  |     at 
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
  |     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
  |     at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
  |     at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:230)
  |     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
  |     at 
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:844)
  |     at $Proxy18.start(Unknown Source)
  |     at org.jboss.system.ServiceController.start(ServiceController.java:369)
  |     at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)
  |     at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  |     at java.lang.reflect.Method.invoke(Method.java:324)
  |     at 
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
  |     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
  |     at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
  |     at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:230)
  |     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
  |     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
  |     at $Proxy15.start(Unknown Source)
  |     at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:605)
  |     at org.jboss.deployment.MainDeployer.start(MainDeployer.java:863)
  |     at org.jboss.deployment.MainDeployer.start(MainDeployer.java:855)
  |     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:674)
  |     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:637)
  |     at sun.reflect.GeneratedMethodAccessor15.invoke(Unknown Source)
  |     at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  |     at java.lang.reflect.Method.invoke(Method.java:324)
  |     at 
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
  |     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
  |     at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
  |     at 
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:230)
  |     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
  |     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:478)
  |     at 
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:201)
  |     at 
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:212)
  |     at 
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:191)
  | Caused by: org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered 
"t.timeStamp >=" at line 2, column 59.
  | Was expecting one of:
  |     "ABS" ...
  |     "LENGTH" ...
  |     "LOCATE" ...
  |     "SQRT" ...
  |     "MOD" ...
  |     "(" ...
  |     "+" ...
  |     "-" ...
  |     <INTEGER_LITERAL> ...
  |     <FLOATING_POINT_LITERAL> ...
  |     <NUMERIC_VALUED_PARAMETER> ...
  |     <NUMERIC_VALUED_PATH> ...
  |     "NOT" ...
  |     <COLLECTION_VALUED_PATH> ...
  |     <STRING_VALUED_PATH> ...
  |     "CONCAT" ...
  |     "SUBSTRING" ...
  |     <BOOLEAN_VALUED_PATH> ...
  |     <DATETIME_VALUED_PATH> "=" ...
  |     <DATETIME_VALUED_PATH> ">" ...
  |     <DATETIME_VALUED_PATH> "<" ...
  |     <DATETIME_VALUED_PATH> "<>" ...
  |     <ENTITY_VALUED_PATH> ...
  |     <IDENTIFICATION_VARIABLE> ...
  |     
  |     at 
org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.generateParseException(EJBQLParser.java:4495)
  |     at 
org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.jj_consume_token(EJBQLParser.java:4376)
  |     at 
org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.ArithmeticPrimary(EJBQLParser.java:1747)
  |     
  | 
  | 

Does anybody has an idea?
Thanks very much,
Philip

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3904923#3904923

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3904923


-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to