Actually, I checked and realized that I had left out some default settings from standardjbosscmp.xml. Added <create-table> and other tags and then the tables teamejb, playerejb got created. But now I get following error
Starting failed jboss.j2ee:jndiName=local/LeagueEJB,service=EJB
org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'select distinct object(p) from Player p
where p.salary between ?1 and ?2'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "where" at line 2, column 1. Was expecting one of:
This is probably preventing schema creation for leagueejb.
This is a bug that was fixed in 3.2.6. Just put WHERE on the same line 1, i.e. no new lines in the query.
Thanks Alexey. I made changes as you suggested and it worked.
However I could not find a bug record at sourceforge on that problem. I did find bugs 874163 and 828845 but these do not seem related to the problem. Do you by any chance know the bug record, or want me to file a bug for the earlier problem (I have not tried 3.2.6 yet).
Also now I am getting the following error :
WARN [ServiceController] Problem starting service jboss.j2ee:jndiName=local/LeagueEJB,service=EJBRuntimeErrorException: java.lang.NoSuchMethodError Cause: java.lang.NoSuchMethodError at org.jboss.mx.server.ReflectedDispatcher.handleInvocationExceptions(ReflectedDispatcher.java:99)
Possibly this is some simple problem and I will try to look into the code - but please let me know if you know offhand the cause and/or solution.
Again, appreciate the help.
With a different search, was able to find the bug 984976 for the earlier EJB-QL problem.