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