Hi, I think you have to write your query in the method List<StudentDto> getStudents() like this:
instead of: > “from StudentDao" write: “select sd from StudentDao sd” The reason is, even if you are using Hibernate, which accepts the query syntax you’re using, you are actually using it as a JPA implementation (it inherits from javax.persistence), thus you have to follow the JPQL syntax instead. Try this change, please. On 28 Nov 2013, at 16:49, softvijay <[email protected]> wrote: > Hi, > > I have been after this for last 3 days but not luck. > Actually i am making a simple crud for testing. > using these: > eclipse (helios) > Hibernate 3.x > Java 1.6 > Tomee 1.6.0 > MYSQL Connector 1.5.12 > > (1) datasource is in /tomee/conf as follows: > > <Resource id="Default JDBC Database" type="DataSource"> > JdbcDriver com.mysql.jdbc.Driver > JdbcUrl jdbc:mysql://localhost:3306/student > UserName root > Password > JtaManaged true > </Resource> > > <Resource id="Default Unmanaged JDBC Database" type="DataSource"> > JdbcDriver com.mysql.jdbc.Driver > JdbcUrl jdbc:mysql://localhost:3306/student > UserName root > Password > JtaManaged false > </Resource> > > (2) persistence.xml is in src\META-INF as follows: > > <persistence version="2.0" > xmlns="http://java.sun.com/xml/ns/persistence"; > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; > xsi:schemaLocation="http://java.sun.com/xml/ns/persistence > http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd";> > > <persistence-unit name="education_pu" transaction-type="JTA"> > <provider>org.hibernate.ejb.HibernatePersistence</provider> > <jta-data-source>Default JDBC Database</jta-data-source> > <non-jta-data-source>Default Unmanaged JDBC Database</non-jta-data-source> > <properties> > <property name="hibernate.transaction.manager_lookup_class" > > value="org.apache.openejb.hibernate.TransactionManagerLookup"/> > <property name="hibernate.show_sql" value="true"/> > <property name="hibernate.format_sql" value="true"/> > <property name="hibernate.use_sql_comments" value="true"/> > <property name="hibernate.dialect" > value="org.hibernate.dialect.MySQL5Dialect"/> > > </properties> > </persistence-unit> > </persistence> > > (3) i have created a persistent Entity as studendao: > package model; > > import java.io.Serializable; > > import javax.persistence.Entity; > import javax.persistence.GeneratedValue; > import javax.persistence.Id; > import javax.persistence.Table; > > @Entity > @Table(name="studentdao") > public class StudentDao implements Serializable > { > private static final long serialVersionUID = 1L; > private int stud_id; > private String stud_name; > > public StudentDao() > { > > } > > @Id @GeneratedValue > public int getStud_id() { > return stud_id; > } > > public void setStud_id(int stud_id) { > this.stud_id = stud_id; > } > > public String getStud_name() { > return stud_name; > } > > public void setStud_name(String stud_name) { > this.stud_name = stud_name; > } > > } > > > (4) my statless bean is accesssing this Entity bean > package model; > > import java.util.ArrayList; > import java.util.List; > import javax.ejb.Stateless; > import javax.persistence.PersistenceContext; > import javax.persistence.EntityManager; > > import dto.StudentDto; > > @Stateless > public class ManageStudentDao implements ManageStudentDaoLocal > { > @PersistenceContext > EntityManager em; > > public ManageStudentDao() > { > } > > @Override > public int generateStudentid() { > // TODO Auto-generated method stub > return 0; > } > > @Override > public void addStudent(StudentDto studentdto) { > > StudentDao studentdao = new StudentDao(); > studentdao.setStud_name(studentdto.getStud_name()); > > em.persist(studentdao); > } > > @Override > public StudentDto getStudent(int student_id) { > // TODO Auto-generated method stub > return null; > } > > @Override > public void updateStudent(StudentDto studentdto) { > // TODO Auto-generated method stub > > } > > @SuppressWarnings({ "unchecked" }) > @Override > public List<StudentDto> getStudents() { > List<StudentDto> studentdto_list = new ArrayList<StudentDto>(); > List<StudentDao> studentdao_list = > (List<StudentDao>)em.createQuery("from > StudentDao").getResultList(); > for (StudentDao studentdao:studentdao_list) > { > StudentDto studentdto = new StudentDto(); > studentdto.setStud_id(studentdao.getStud_id()); > studentdto.setStud_name(studentdao.getStud_name()); > studentdto_list.add(studentdto); > } > return studentdto_list; > } > > @Override > public void deleteStudent(int student_id) { > // TODO Auto-generated method stub > > } > > } > > (5) Client class is > package dto; > > import java.util.List; > import javax.naming.InitialContext; > import javax.naming.NamingException; > > > import model.ManageStudentDaoLocal; > > > public class EJBTester > { > private void testStatelessEjb() > { > try > { > ManageStudentDaoLocal managestudent > =(ManageStudentDaoLocal) > InitialContext.doLookup("ManageStudentDaoLocal"); > List<StudentDto> studentdto_list = > managestudent.getStudents(); > for (StudentDto studentdto:studentdto_list) > { > > System.out.println(studentdto.getStud_id()); > > System.out.println(studentdto.getStud_name()); > } > } > catch (NamingException e) > { > > e.printStackTrace(); > } > > } > > > public static void main(String[] s) > { > EJBTester ejbtester = new EJBTester(); > ejbtester.testStatelessEjb(); > } > > } > > > i have created the schema as student. > Created a table in this as studentdao > also manually feeded four rows in the table. > just wanted to list these students. > > > when i add this project to Tomee Server and start the server, i can see my > MYSQL DB detected as follows: > > 8-Nov-2013 21:13:12 org.apache.catalina.core.AprLifecycleListener init > INFO: The APR based Apache Tomcat Native library which allows optimal > performance in production environments was not found on the > java.library.path: C:\Program > Files\Java\jre6\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:/Program > Files/Java/jre7/bin/client;C:/Program Files/Java/jre7/bin;C:/Program > Files/Java/jre7/lib/i386;C:\Program Files\PC Connectivity > Solution\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program > Files\Intel\DMIX;C:\Program Files\NTRU Cryptosystems\NTRU TCG Software > Stack\bin\;C:\Program Files\Wave Systems Corp\Gemalto\Access > Client\v5\;C:\Program Files\Common Files\Roxio Shared\DLLShared\;C:\Program > Files\Common Files\Roxio Shared\9.0\DLLShared\;C:\Program > Files\Symantec\pcAnywhere\;C:\Program > Files\QuickTime\QTSystem\;C:\WINDOWS\system32\WindowsPowerShell\v1.0;%PROGRAMFILES%\Internet > Explorer;C:\vijay\eclipse-jee-helios-SR1-win32\eclipse; > 28-Nov-2013 21:13:12 org.apache.tomcat.util.digester.SetPropertiesRule begin > WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting > property 'source' to 'org.eclipse.jst.jee.server:education' did not find a > matching property. > 28-Nov-2013 21:13:12 org.apache.coyote.AbstractProtocol init > INFO: Initializing ProtocolHandler ["http-bio-8080"] > 28-Nov-2013 21:13:12 org.apache.coyote.AbstractProtocol init > INFO: Initializing ProtocolHandler ["ajp-bio-8009"] > 28-Nov-2013 21:13:12 org.apache.openejb.util.OptionsLog info > INFO: Using > 'openejb.jdbc.datasource-creator=org.apache.tomee.jdbc.TomEEDataSourceCreator' > 28-Nov-2013 21:13:13 org.apache.openejb.OpenEJB$Instance <init> > INFO: > ******************************************************************************** > 28-Nov-2013 21:13:13 org.apache.openejb.OpenEJB$Instance <init> > INFO: OpenEJB http://openejb.apache.org/ > 28-Nov-2013 21:13:13 org.apache.openejb.OpenEJB$Instance <init> > INFO: Startup: Thu Nov 28 21:13:13 IST 2013 > 28-Nov-2013 21:13:13 org.apache.openejb.OpenEJB$Instance <init> > INFO: Copyright 1999-2012 (C) Apache OpenEJB Project, All Rights Reserved. > 28-Nov-2013 21:13:13 org.apache.openejb.OpenEJB$Instance <init> > INFO: Version: 4.5.1 > 28-Nov-2013 21:13:13 org.apache.openejb.OpenEJB$Instance <init> > INFO: Build date: 20121209 > 28-Nov-2013 21:13:13 org.apache.openejb.OpenEJB$Instance <init> > INFO: Build time: 08:47 > 28-Nov-2013 21:13:13 org.apache.openejb.OpenEJB$Instance <init> > INFO: > ******************************************************************************** > 28-Nov-2013 21:13:13 org.apache.openejb.OpenEJB$Instance <init> > INFO: openejb.home = C:\Tomee > 1.5\apache-tomee-1.5.1-plus\apache-tomee-plus-1.5.1 > 28-Nov-2013 21:13:13 org.apache.openejb.OpenEJB$Instance <init> > INFO: openejb.base = C:\Tomee > 1.5\apache-tomee-1.5.1-plus\apache-tomee-plus-1.5.1 > 28-Nov-2013 21:13:13 org.apache.openejb.cdi.CdiBuilder initializeOWB > INFO: Created new singletonService > org.apache.openejb.cdi.ThreadSingletonServiceImpl@144752d > 28-Nov-2013 21:13:13 org.apache.openejb.cdi.CdiBuilder initializeOWB > INFO: Succeeded in installing singleton service > 28-Nov-2013 21:13:13 org.apache.openejb.config.ConfigurationFactory init > INFO: openejb configuration file is 'C:\Tomee > 1.5\apache-tomee-1.5.1-plus\apache-tomee-plus-1.5.1\conf\tomee.xml' > 28-Nov-2013 21:13:13 org.apache.openejb.util.OptionsLog info > INFO: Using 'openejb.provider.default=org.apache.tomee' > 28-Nov-2013 21:13:13 org.apache.openejb.config.ConfigurationFactory > configureService > INFO: Configuring Service(id=Tomcat Security Service, type=SecurityService, > provider-id=Tomcat Security Service) > 28-Nov-2013 21:13:13 org.apache.openejb.config.ConfigurationFactory > configureService > INFO: Configuring Service(id=Default Transaction Manager, > type=TransactionManager, provider-id=Default Transaction Manager) > 28-Nov-2013 21:13:13 org.apache.openejb.config.ConfigurationFactory > configureService > INFO: Configuring Service(id=Default JDBC Database, type=Resource, > provider-id=Default JDBC Database) > 28-Nov-2013 21:13:13 org.apache.openejb.config.ConfigurationFactory > configureService > INFO: Configuring Service(id=Default Unmanaged JDBC Database, type=Resource, > provider-id=Default JDBC Database) > 28-Nov-2013 21:13:13 org.apache.openejb.config.ConfigurationFactory > configureService > INFO: Configuring Service(id=My Singleton Container, type=Container, > provider-id=Default Singleton Container) > 28-Nov-2013 21:13:13 org.apache.openejb.config.ConfigurationFactory > configureService > INFO: Configuring Service(id=My Stateful Container, type=Container, > provider-id=Default Stateful Container) > 28-Nov-2013 21:13:13 org.apache.openejb.config.ConfigurationFactory > configureService > INFO: Configuring Service(id=My Stateless Container, type=Container, > provider-id=Default Stateless Container) > 28-Nov-2013 21:13:13 org.apache.openejb.config.DeploymentsResolver loadFrom > WARNING: <Deployments dir="null"> - Does not exist: C:\Tomee > 1.5\apache-tomee-1.5.1-plus\apache-tomee-plus-1.5.1\apps > 28-Nov-2013 21:13:13 org.apache.openejb.util.OptionsLog info > INFO: Using 'openejb.system.apps=true' > 28-Nov-2013 21:13:13 org.apache.openejb.config.ConfigurationFactory > configureApplication > INFO: Configuring enterprise application: null > 28-Nov-2013 21:13:13 org.apache.openejb.config.InitEjbDeployments deploy > INFO: Using openejb.deploymentId.format '{ejbName}' > 28-Nov-2013 21:13:13 org.apache.openejb.config.InitEjbDeployments deploy > INFO: Auto-deploying ejb openejb/User: > EjbDeployment(deployment-id=openejb/User) > 28-Nov-2013 21:13:13 org.apache.openejb.config.InitEjbDeployments deploy > INFO: Auto-deploying ejb openejb/Deployer: > EjbDeployment(deployment-id=openejb/Deployer) > 28-Nov-2013 21:13:13 org.apache.openejb.config.InitEjbDeployments deploy > INFO: Auto-deploying ejb openejb/ConfigurationInfo: > EjbDeployment(deployment-id=openejb/ConfigurationInfo) > 28-Nov-2013 21:13:13 org.apache.openejb.config.InitEjbDeployments deploy > INFO: Auto-deploying ejb MEJB: EjbDeployment(deployment-id=MEJB) > 28-Nov-2013 21:13:13 org.apache.openejb.config.AppInfoBuilder build > INFO: Enterprise application "openejb" loaded. > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.Assembler > createRecipe > INFO: Creating TransactionManager(id=Default Transaction Manager) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.Assembler > createRecipe > INFO: Creating SecurityService(id=Tomcat Security Service) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.Assembler > createRecipe > INFO: Creating Resource(id=Default JDBC Database) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.Assembler > createRecipe > INFO: Creating Resource(id=Default Unmanaged JDBC Database) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.Assembler > createRecipe > INFO: Creating Container(id=My Singleton Container) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.Assembler > createRecipe > INFO: Creating Container(id=My Stateful Container) > 28-Nov-2013 21:13:13 org.apache.openejb.core.stateful.SimplePassivater init > INFO: Using directory C:\DOCUME~1\VIJAYK~1.000\LOCALS~1\Temp for stateful > session passivation > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.Assembler > createRecipe > INFO: Creating Container(id=My Stateless Container) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.Assembler > createApplication > INFO: Assembling app: openejb > 28-Nov-2013 21:13:13 org.apache.openejb.util.OptionsLog info > INFO: Using > 'openejb.jndiname.format={deploymentId}{interfaceType.openejbLegacyName}' > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.JndiBuilder bind > INFO: Jndi(name=openejb/UserBusinessRemote) --> > Ejb(deployment-id=openejb/User) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.JndiBuilder bind > INFO: > Jndi(name=global/openejb/openejb/User!org.apache.openejb.assembler.util.User) > --> Ejb(deployment-id=openejb/User) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.JndiBuilder bind > INFO: Jndi(name=global/openejb/openejb/User) --> > Ejb(deployment-id=openejb/User) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.JndiBuilder bind > INFO: Jndi(name=openejb/DeployerBusinessRemote) --> > Ejb(deployment-id=openejb/Deployer) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.JndiBuilder bind > INFO: > Jndi(name=global/openejb/openejb/Deployer!org.apache.openejb.assembler.Deployer) > --> Ejb(deployment-id=openejb/Deployer) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.JndiBuilder bind > INFO: Jndi(name=global/openejb/openejb/Deployer) --> > Ejb(deployment-id=openejb/Deployer) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.JndiBuilder bind > INFO: Jndi(name=openejb/ConfigurationInfoBusinessRemote) --> > Ejb(deployment-id=openejb/ConfigurationInfo) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.JndiBuilder bind > INFO: > Jndi(name=global/openejb/openejb/ConfigurationInfo!org.apache.openejb.assembler.classic.cmd.ConfigurationInfo) > --> Ejb(deployment-id=openejb/ConfigurationInfo) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.JndiBuilder bind > INFO: Jndi(name=global/openejb/openejb/ConfigurationInfo) --> > Ejb(deployment-id=openejb/ConfigurationInfo) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.JndiBuilder bind > INFO: Jndi(name=MEJB) --> Ejb(deployment-id=MEJB) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.JndiBuilder bind > INFO: Jndi(name=global/openejb/MEJB!javax.management.j2ee.ManagementHome) > --> Ejb(deployment-id=MEJB) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.JndiBuilder bind > INFO: Jndi(name=global/openejb/MEJB) --> Ejb(deployment-id=MEJB) > 28-Nov-2013 21:13:13 org.apache.openejb.cdi.CdiBuilder initSingleton > INFO: Existing thread singleton service in SystemInstance() > org.apache.openejb.cdi.ThreadSingletonServiceImpl@144752d > 28-Nov-2013 21:13:13 org.apache.openejb.cdi.OpenEJBLifecycle > startApplication > INFO: OpenWebBeans Container is starting... > 28-Nov-2013 21:13:13 org.apache.webbeans.plugins.PluginLoader startUp > INFO: Adding OpenWebBeansPlugin : [CdiPlugin] > 28-Nov-2013 21:13:13 org.apache.webbeans.plugins.PluginLoader startUp > INFO: Adding OpenWebBeansPlugin : [OpenWebBeansJsfPlugin] > 28-Nov-2013 21:13:13 org.apache.openejb.cdi.BeansDeployer > validateInjectionPoints > INFO: All injection points are validated successfully. > 28-Nov-2013 21:13:13 org.apache.openejb.cdi.OpenEJBLifecycle > startApplication > INFO: OpenWebBeans Container has started, it took 125 ms. > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.Assembler > createApplication > INFO: Created Ejb(deployment-id=openejb/Deployer, ejb-name=openejb/Deployer, > container=My Stateless Container) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.Assembler > createApplication > INFO: Created Ejb(deployment-id=MEJB, ejb-name=MEJB, container=My Stateless > Container) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.Assembler > createApplication > INFO: Created Ejb(deployment-id=openejb/ConfigurationInfo, > ejb-name=openejb/ConfigurationInfo, container=My Stateless Container) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.Assembler > createApplication > INFO: Created Ejb(deployment-id=openejb/User, ejb-name=openejb/User, > container=My Stateless Container) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.Assembler > createApplication > INFO: Started Ejb(deployment-id=openejb/Deployer, ejb-name=openejb/Deployer, > container=My Stateless Container) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.Assembler > createApplication > INFO: Started Ejb(deployment-id=MEJB, ejb-name=MEJB, container=My Stateless > Container) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.Assembler > createApplication > INFO: Started Ejb(deployment-id=openejb/ConfigurationInfo, > ejb-name=openejb/ConfigurationInfo, container=My Stateless Container) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.Assembler > createApplication > INFO: Started Ejb(deployment-id=openejb/User, ejb-name=openejb/User, > container=My Stateless Container) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.Assembler > deployMBean > INFO: Deployed > MBean(openejb.user.mbeans:application=openejb,group=org.apache.openejb.assembler.monitoring,name=JMXDeployer) > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.Assembler > createApplication > INFO: Deployed Application(path=openejb) > 28-Nov-2013 21:13:13 org.apache.openejb.util.OptionsLog info > INFO: Using 'openejb.profile.custom=false' > 28-Nov-2013 21:13:13 org.apache.openejb.server.ServiceManager initServer > INFO: Creating ServerService(id=cxf) > 28-Nov-2013 21:13:13 org.apache.openejb.server.ServiceManager initServer > INFO: Creating ServerService(id=cxf-rs) > 28-Nov-2013 21:13:13 org.apache.openejb.server.SimpleServiceManager start > INFO: Starting service cxf > 28-Nov-2013 21:13:13 org.apache.openejb.server.SimpleServiceManager start > INFO: Started service cxf > 28-Nov-2013 21:13:13 org.apache.openejb.server.SimpleServiceManager start > INFO: Starting service cxf-rs > 28-Nov-2013 21:13:13 org.apache.openejb.server.SimpleServiceManager start > INFO: Started service cxf-rs > 28-Nov-2013 21:13:13 org.apache.openejb.server.SimpleServiceManager start > INFO: ** Bound Services ** > 28-Nov-2013 21:13:13 org.apache.openejb.server.SimpleServiceManager printRow > INFO: NAME IP PORT > 28-Nov-2013 21:13:13 org.apache.openejb.server.SimpleServiceManager start > INFO: ------- > 28-Nov-2013 21:13:13 org.apache.openejb.server.SimpleServiceManager start > INFO: Ready! > 28-Nov-2013 21:13:13 org.apache.catalina.startup.Catalina load > INFO: Initialization processed in 2150 ms > 28-Nov-2013 21:13:13 org.apache.tomee.catalina.OpenEJBNamingContextListener > bindResource > INFO: Importing a Tomcat Resource with id 'UserDatabase' of type > 'org.apache.catalina.UserDatabase'. > 28-Nov-2013 21:13:13 org.apache.openejb.assembler.classic.Assembler > createRecipe > INFO: Creating Resource(id=UserDatabase) > 28-Nov-2013 21:13:13 org.apache.catalina.core.StandardService startInternal > INFO: Starting service Catalina > 28-Nov-2013 21:13:13 org.apache.catalina.core.StandardEngine startInternal > INFO: Starting Servlet Engine: Apache Tomcat (TomEE)/7.0.34 > 28-Nov-2013 21:13:13 org.apache.tomee.catalina.TomcatWebAppBuilder init > INFO: ------------------------- > TomcatWebAppBuilder.init /education > 28-Nov-2013 21:13:14 org.apache.tomee.catalina.TomEEClassLoaderEnricher > validateJarFile > WARNING: jar 'C:\Tomee > 1.5\apache-tomee-1.5.1-plus\apache-tomee-plus-1.5.1\wtpwebapps\education\WEB-INF\lib\hibernate-jpa-2.0-api-1.0.0.Final.jar' > contains offending class: javax.persistence.Entity. It will be ignored. > 28-Nov-2013 21:13:14 org.apache.tomee.catalina.TomEEClassLoaderEnricher > validateJarFile > WARNING: jar 'C:\Tomee > 1.5\apache-tomee-1.5.1-plus\apache-tomee-plus-1.5.1\wtpwebapps\education\WEB-INF\lib\jta-1.1.jar' > contains offending class: javax.transaction.Transaction. It will be ignored. > 28-Nov-2013 21:13:14 org.apache.openejb.config.ConfigurationFactory > configureApplication > INFO: Configuring enterprise application: C:\Tomee > 1.5\apache-tomee-1.5.1-plus\apache-tomee-plus-1.5.1\wtpwebapps\education > 28-Nov-2013 21:13:14 org.apache.openejb.config.InitEjbDeployments deploy > INFO: Auto-deploying ejb ManageStudentDao: > EjbDeployment(deployment-id=ManageStudentDao) > 28-Nov-2013 21:13:14 org.apache.openejb.config.AutoConfig deploy > INFO: Configuring PersistenceUnit(name=education_pu, > provider=org.hibernate.ejb.HibernatePersistence) > 28-Nov-2013 21:13:14 org.apache.openejb.config.AppInfoBuilder build > INFO: Enterprise application "C:\Tomee > 1.5\apache-tomee-1.5.1-plus\apache-tomee-plus-1.5.1\wtpwebapps\education" > loaded. > 28-Nov-2013 21:13:14 org.apache.openejb.assembler.classic.Assembler > createApplication > INFO: Assembling app: C:\Tomee > 1.5\apache-tomee-1.5.1-plus\apache-tomee-plus-1.5.1\wtpwebapps\education > 28-Nov-2013 21:13:14 org.hibernate.annotations.common.Version <clinit> > INFO: Hibernate Commons Annotations 3.2.0.Final > 28-Nov-2013 21:13:14 org.hibernate.cfg.Environment <clinit> > INFO: Hibernate 3.6.0.Final > 28-Nov-2013 21:13:14 org.hibernate.cfg.Environment <clinit> > INFO: hibernate.properties not found > 28-Nov-2013 21:13:14 org.hibernate.cfg.Environment buildBytecodeProvider > INFO: Bytecode provider name : javassist > 28-Nov-2013 21:13:14 org.hibernate.cfg.Environment <clinit> > INFO: using JDK 1.4 java.sql.Timestamp handling > 28-Nov-2013 21:13:14 org.hibernate.ejb.Version <clinit> > INFO: Hibernate EntityManager 3.6.0.Final > 28-Nov-2013 21:13:14 org.hibernate.ejb.Ejb3Configuration configure > INFO: Processing PersistenceUnitInfo [ > name: education_pu > ...] > 28-Nov-2013 21:13:14 org.hibernate.cfg.AnnotationBinder bindClass > INFO: Binding entity from annotated class: model.StudentDao > 28-Nov-2013 21:13:14 org.hibernate.cfg.annotations.EntityBinder bindTable > INFO: Bind entity model.StudentDao on table studentdao > 28-Nov-2013 21:13:14 org.hibernate.cfg.Configuration > applyHibernateValidatorLegacyConstraintsOnDDL > INFO: Hibernate Validator not found: ignoring > 28-Nov-2013 21:13:14 > org.hibernate.cfg.search.HibernateSearchEventListenerRegister > enableHibernateSearch > INFO: Unable to find org.hibernate.search.event.FullTextIndexEventListener > on the classpath. Hibernate Search is not enabled. > 28-Nov-2013 21:13:14 org.hibernate.connection.ConnectionProviderFactory > initializeConnectionProviderFromConfig > INFO: Initializing connection provider: > org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider > 28-Nov-2013 21:13:14 > org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider configure > INFO: Using provided datasource > 28-Nov-2013 21:13:15 org.hibernate.cfg.SettingsFactory buildSettings > *INFO: Database -> > name : MySQL > version : 5.1.49-community > major : 5 > minor : 1 > 28-Nov-2013 21:13:15 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Driver -> > name : MySQL-AB JDBC Driver > version : mysql-connector-java-5.1.12 ( Revision: ${bzr.revision-id} ) > major : 5 > minor : 1* > 28-Nov-2013 21:13:15 org.hibernate.dialect.Dialect <init> > INFO: Using dialect: org.hibernate.dialect.MySQL5Dialect > 28-Nov-2013 21:13:15 org.hibernate.engine.jdbc.JdbcSupportLoader > useContextualLobCreation > INFO: Disabling contextual LOB creation as JDBC driver reported JDBC version > [3] less than 4 > 28-Nov-2013 21:13:15 org.hibernate.transaction.TransactionFactoryFactory > buildTransactionFactory > INFO: Transaction strategy: > org.hibernate.ejb.transaction.JoinableCMTTransactionFactory > 28-Nov-2013 21:13:15 > org.hibernate.transaction.TransactionManagerLookupFactory > getTransactionManagerLookup > INFO: instantiating TransactionManagerLookup: > org.apache.openejb.hibernate.TransactionManagerLookup > 28-Nov-2013 21:13:15 > org.hibernate.transaction.TransactionManagerLookupFactory > getTransactionManagerLookup > INFO: instantiated TransactionManagerLookup > 28-Nov-2013 21:13:15 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Automatic flush during beforeCompletion(): disabled > 28-Nov-2013 21:13:15 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Automatic session close at end of transaction: disabled > 28-Nov-2013 21:13:15 org.hibernate.cfg.SettingsFactory buildSettings > INFO: JDBC batch size: 15 > 28-Nov-2013 21:13:15 org.hibernate.cfg.SettingsFactory buildSettings > INFO: JDBC batch updates for versioned data: disabled > 28-Nov-2013 21:13:15 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Scrollable result sets: enabled > 28-Nov-2013 21:13:15 org.hibernate.cfg.SettingsFactory buildSettings > INFO: JDBC3 getGeneratedKeys(): enabled > 28-Nov-2013 21:13:15 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Connection release mode: auto > 28-Nov-2013 21:13:15 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Maximum outer join fetch depth: 2 > 28-Nov-2013 21:13:15 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Default batch fetch size: 1 > 28-Nov-2013 21:13:15 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Generate SQL with comments: enabled > 28-Nov-2013 21:13:15 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Order SQL updates by primary key: disabled > 28-Nov-2013 21:13:15 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Order SQL inserts for batching: disabled > 28-Nov-2013 21:13:15 org.hibernate.cfg.SettingsFactory > createQueryTranslatorFactory > INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory > 28-Nov-2013 21:13:15 org.hibernate.hql.ast.ASTQueryTranslatorFactory <init> > > > > But when i execute my client class EJBTester > > I see that HSQL DB is injected by TOMEE & i get permission error > Details as follows: > > 28-Nov-2013 21:15:36 org.apache.openejb.OpenEJB$Instance <init> > INFO: > ******************************************************************************** > 28-Nov-2013 21:15:36 org.apache.openejb.OpenEJB$Instance <init> > INFO: OpenEJB http://openejb.apache.org/ > 28-Nov-2013 21:15:36 org.apache.openejb.OpenEJB$Instance <init> > INFO: Startup: Thu Nov 28 21:15:36 IST 2013 > 28-Nov-2013 21:15:36 org.apache.openejb.OpenEJB$Instance <init> > INFO: Copyright 1999-2012 (C) Apache OpenEJB Project, All Rights Reserved. > 28-Nov-2013 21:15:36 org.apache.openejb.OpenEJB$Instance <init> > INFO: Version: 4.5.1 > 28-Nov-2013 21:15:36 org.apache.openejb.OpenEJB$Instance <init> > INFO: Build date: 20121209 > 28-Nov-2013 21:15:36 org.apache.openejb.OpenEJB$Instance <init> > INFO: Build time: 08:47 > 28-Nov-2013 21:15:36 org.apache.openejb.OpenEJB$Instance <init> > INFO: > ******************************************************************************** > 28-Nov-2013 21:15:36 org.apache.openejb.OpenEJB$Instance <init> > INFO: openejb.home = C:\vijay\vj\workspace\education > 28-Nov-2013 21:15:36 org.apache.openejb.OpenEJB$Instance <init> > INFO: openejb.base = C:\vijay\vj\workspace\education > 28-Nov-2013 21:15:36 org.apache.openejb.cdi.CdiBuilder initializeOWB > INFO: Created new singletonService > org.apache.openejb.cdi.ThreadSingletonServiceImpl@122cdb6 > 28-Nov-2013 21:15:36 org.apache.openejb.cdi.CdiBuilder initializeOWB > INFO: Succeeded in installing singleton service > 28-Nov-2013 21:15:36 org.apache.openejb.config.ConfigUtils > searchForConfiguration > INFO: Cannot find the configuration file [conf/openejb.xml]. Will attempt > to create one for the beans deployed. > 28-Nov-2013 21:15:36 org.apache.openejb.config.ConfigurationFactory > configureService > INFO: Configuring Service(id=Default Security Service, type=SecurityService, > provider-id=Default Security Service) > 28-Nov-2013 21:15:36 org.apache.openejb.config.ConfigurationFactory > configureService > INFO: Configuring Service(id=Default Transaction Manager, > type=TransactionManager, provider-id=Default Transaction Manager) > 28-Nov-2013 21:15:36 org.apache.openejb.config.DeploymentsResolver > processUrls > INFO: Found EjbModule in classpath: > c:\vijay\vj\workspace\education\build\classes > 28-Nov-2013 21:15:37 org.apache.openejb.config.DeploymentsResolver > loadFromClasspath > INFO: Searched 13 classpath urls in 1030 milliseconds. Average 79 > milliseconds per url. > 28-Nov-2013 21:15:37 org.apache.openejb.config.ConfigurationFactory > loadApplication > INFO: Beginning load: c:\vijay\vj\workspace\education\build\classes > 28-Nov-2013 21:15:37 org.apache.openejb.config.ConfigurationFactory > configureApplication > INFO: Configuring enterprise application: > C:\vijay\vj\workspace\education\classpath.ear > 28-Nov-2013 21:15:37 org.apache.openejb.config.InitEjbDeployments deploy > INFO: Auto-deploying ejb ManageStudentDao: > EjbDeployment(deployment-id=ManageStudentDao) > 28-Nov-2013 21:15:37 org.apache.openejb.config.ConfigurationFactory > configureService > INFO: Configuring Service(id=Default Stateless Container, type=Container, > provider-id=Default Stateless Container) > 28-Nov-2013 21:15:37 org.apache.openejb.config.AutoConfig createContainer > INFO: Auto-creating a container for bean ManageStudentDao: > Container(type=STATELESS, id=Default Stateless Container) > 28-Nov-2013 21:15:37 org.apache.openejb.config.AutoConfig deploy > INFO: Configuring PersistenceUnit(name=education_pu, > provider=org.hibernate.ejb.HibernatePersistence) > 28-Nov-2013 21:15:37 org.apache.openejb.config.ConfigurationFactory > configureService > INFO: Configuring Service(id=Default JDBC Database, type=Resource, > provider-id=Default JDBC Database) > 28-Nov-2013 21:15:37 org.apache.openejb.config.ConfigurationFactory > configureService > INFO: Configuring Service(id=Default Unmanaged JDBC Database, type=Resource, > provider-id=Default Unmanaged JDBC Database) > 28-Nov-2013 21:15:37 org.apache.openejb.config.AutoConfig > logAutoCreateResource > INFO: Auto-creating a Resource with id 'Default JDBC Database' of type > 'DataSource for 'education_pu'. > 28-Nov-2013 21:15:37 org.apache.openejb.config.AutoConfig > logAutoCreateResource > INFO: Auto-creating a Resource with id 'Default Unmanaged JDBC Database' of > type 'DataSource for 'education_pu'. > 28-Nov-2013 21:15:37 org.apache.openejb.config.AppInfoBuilder build > INFO: Enterprise application "C:\vijay\vj\workspace\education\classpath.ear" > loaded. > 28-Nov-2013 21:15:37 org.apache.openejb.assembler.classic.Assembler > createRecipe > INFO: Creating TransactionManager(id=Default Transaction Manager) > 28-Nov-2013 21:15:37 org.apache.openejb.assembler.classic.Assembler > createRecipe > INFO: Creating SecurityService(id=Default Security Service) > 28-Nov-2013 21:15:37 org.apache.openejb.assembler.classic.Assembler > createRecipe > INFO: Creating Resource(id=Default JDBC Database) > 28-Nov-2013 21:15:37 org.apache.openejb.assembler.classic.Assembler > createRecipe > INFO: Creating Resource(id=Default Unmanaged JDBC Database) > 28-Nov-2013 21:15:38 org.apache.openejb.assembler.classic.Assembler > createRecipe > INFO: Creating Container(id=Default Stateless Container) > 28-Nov-2013 21:15:38 org.apache.openejb.assembler.classic.Assembler > createApplication > INFO: Assembling app: C:\vijay\vj\workspace\education\classpath.ear > 28-Nov-2013 21:15:38 org.hibernate.annotations.common.Version <clinit> > INFO: Hibernate Commons Annotations 3.2.0.Final > 28-Nov-2013 21:15:38 org.hibernate.cfg.Environment <clinit> > INFO: Hibernate 3.6.0.Final > 28-Nov-2013 21:15:38 org.hibernate.cfg.Environment <clinit> > INFO: hibernate.properties not found > 28-Nov-2013 21:15:38 org.hibernate.cfg.Environment buildBytecodeProvider > INFO: Bytecode provider name : javassist > 28-Nov-2013 21:15:38 org.hibernate.cfg.Environment <clinit> > INFO: using JDK 1.4 java.sql.Timestamp handling > 28-Nov-2013 21:15:38 org.hibernate.ejb.Version <clinit> > INFO: Hibernate EntityManager 3.6.0.Final > 28-Nov-2013 21:15:38 org.hibernate.ejb.Ejb3Configuration configure > INFO: Processing PersistenceUnitInfo [ > name: education_pu > ...] > 28-Nov-2013 21:15:38 org.hibernate.cfg.AnnotationBinder bindClass > INFO: Binding entity from annotated class: model.StudentDao > 28-Nov-2013 21:15:38 org.hibernate.cfg.annotations.EntityBinder bindTable > INFO: Bind entity model.StudentDao on table studentdao > 28-Nov-2013 21:15:38 org.hibernate.cfg.Configuration > applyHibernateValidatorLegacyConstraintsOnDDL > INFO: Hibernate Validator not found: ignoring > 28-Nov-2013 21:15:38 > org.hibernate.cfg.search.HibernateSearchEventListenerRegister > enableHibernateSearch > INFO: Unable to find org.hibernate.search.event.FullTextIndexEventListener > on the classpath. Hibernate Search is not enabled. > 28-Nov-2013 21:15:38 org.hibernate.connection.ConnectionProviderFactory > initializeConnectionProviderFromConfig > I*NFO: Initializing connection provider: > org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider > 28-Nov-2013 21:15:38 > org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider configure > INFO: Using provided datasource > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Database -> > name : HSQL Database Engine > version : 2.2.8 > major : 2 > minor : 2 > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Driver -> > name : HSQL Database Engine Driver > version : 2.2.8 > major : 2 > minor : 2 > 28-Nov-2013 21:15:38 org.hibernate.dialect.Dialect <init> > INFO: Using dialect: org.hibernate.dialect.MySQL5Dialect* > 28-Nov-2013 21:15:38 org.hibernate.engine.jdbc.JdbcSupportLoader > useContextualLobCreation > INFO: Disabling contextual LOB creation as createClob() method threw error : > java.lang.reflect.InvocationTargetException > 28-Nov-2013 21:15:38 org.hibernate.transaction.TransactionFactoryFactory > buildTransactionFactory > INFO: Transaction strategy: > org.hibernate.ejb.transaction.JoinableCMTTransactionFactory > 28-Nov-2013 21:15:38 > org.hibernate.transaction.TransactionManagerLookupFactory > getTransactionManagerLookup > INFO: instantiating TransactionManagerLookup: > org.apache.openejb.hibernate.TransactionManagerLookup > 28-Nov-2013 21:15:38 > org.hibernate.transaction.TransactionManagerLookupFactory > getTransactionManagerLookup > INFO: instantiated TransactionManagerLookup > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Automatic flush during beforeCompletion(): disabled > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Automatic session close at end of transaction: disabled > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: JDBC batch size: 15 > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: JDBC batch updates for versioned data: disabled > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Scrollable result sets: enabled > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: JDBC3 getGeneratedKeys(): enabled > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Connection release mode: auto > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Maximum outer join fetch depth: 2 > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Default batch fetch size: 1 > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Generate SQL with comments: enabled > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Order SQL updates by primary key: disabled > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Order SQL inserts for batching: disabled > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory > createQueryTranslatorFactory > INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory > 28-Nov-2013 21:15:38 org.hibernate.hql.ast.ASTQueryTranslatorFactory <init> > INFO: Using ASTQueryTranslatorFactory > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Query language substitutions: {} > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: JPA-QL strict compliance: enabled > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Second-level cache: enabled > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Query cache: disabled > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory createRegionFactory > INFO: Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Optimize cache for minimal puts: disabled > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Structured second-level cache entries: disabled > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Echoing all SQL to stdout > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Statistics: disabled > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Deleted entity synthetic identifier rollback: disabled > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Default entity-mode: pojo > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Named query checking : enabled > 28-Nov-2013 21:15:38 org.hibernate.cfg.SettingsFactory buildSettings > INFO: Check Nullability in Core (should be disabled when Bean Validation is > on): disabled > 28-Nov-2013 21:15:38 org.hibernate.impl.SessionFactoryImpl <init> > INFO: building session factory > 28-Nov-2013 21:15:38 org.hibernate.impl.SessionFactoryObjectFactory > addInstance > INFO: Not binding factory to JNDI, no JNDI name configured > 28-Nov-2013 21:15:39 org.apache.openejb.assembler.classic.PersistenceBuilder > createEntityManagerFactory > INFO: PersistenceUnit(name=education_pu, > provider=org.hibernate.ejb.HibernatePersistence) - provider time 930ms > 28-Nov-2013 21:15:39 org.apache.openejb.assembler.classic.JndiBuilder bind > INFO: Jndi(name=ManageStudentDaoLocal) --> > Ejb(deployment-id=ManageStudentDao) > 28-Nov-2013 21:15:39 org.apache.openejb.assembler.classic.JndiBuilder bind > INFO: > Jndi(name=global/classpath.ear/education/ManageStudentDao!model.ManageStudentDaoLocal) > --> Ejb(deployment-id=ManageStudentDao) > 28-Nov-2013 21:15:39 org.apache.openejb.assembler.classic.JndiBuilder bind > INFO: Jndi(name=global/classpath.ear/education/ManageStudentDao) --> > Ejb(deployment-id=ManageStudentDao) > 28-Nov-2013 21:15:39 org.apache.openejb.cdi.CdiBuilder initSingleton > INFO: Existing thread singleton service in SystemInstance() > org.apache.openejb.cdi.ThreadSingletonServiceImpl@122cdb6 > 28-Nov-2013 21:15:39 org.apache.openejb.cdi.OpenEJBLifecycle > startApplication > INFO: OpenWebBeans Container is starting... > 28-Nov-2013 21:15:39 org.apache.webbeans.plugins.PluginLoader startUp > INFO: Adding OpenWebBeansPlugin : [CdiPlugin] > 28-Nov-2013 21:15:39 org.apache.webbeans.plugins.PluginLoader startUp > INFO: Adding OpenWebBeansPlugin : [OpenWebBeansJsfPlugin] > 28-Nov-2013 21:15:39 org.apache.openejb.cdi.BeansDeployer > validateInjectionPoints > INFO: All injection points are validated successfully. > 28-Nov-2013 21:15:39 org.apache.openejb.cdi.OpenEJBLifecycle > startApplication > INFO: OpenWebBeans Container has started, it took 63 ms. > 28-Nov-2013 21:15:39 org.apache.openejb.assembler.classic.Assembler > createApplication > INFO: Created Ejb(deployment-id=ManageStudentDao, ejb-name=ManageStudentDao, > container=Default Stateless Container) > 28-Nov-2013 21:15:39 org.apache.openejb.assembler.classic.Assembler > createApplication > INFO: Started Ejb(deployment-id=ManageStudentDao, ejb-name=ManageStudentDao, > container=Default Stateless Container) > 28-Nov-2013 21:15:39 org.apache.openejb.assembler.classic.Assembler > createApplication > INFO: Deployed > Application(path=C:\vijay\vj\workspace\education\classpath.ear) > Hibernate: > /* > from > StudentDao */ select > studentdao0_.stud_id as stud1_0_, > studentdao0_.stud_name as stud2_0_ > from > studentdao studentdao0_ > 28-Nov-2013 21:15:39 org.hibernate.util.JDBCExceptionReporter logExceptions > WARNING: SQL Error: -5501, SQLState: 42501 > 28-Nov-2013 21:15:39 org.hibernate.util.JDBCExceptionReporter logExceptions > SEVERE: user lacks privilege or object not found: STUDENTDAO > Exception in thread "main" javax.ejb.EJBException: The bean encountered a > non-application exception; nested exception is: > javax.persistence.PersistenceException: > org.hibernate.exception.SQLGrammarException: could not execute query > at > org.apache.openejb.core.ivm.BaseEjbProxyHandler.convertException(BaseEjbProxyHandler.java:363) > at > org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:283) > at $Proxy45.getStudents(Unknown Source) > at dto.EJBTester.testStatelessEjb(EJBTester.java:18) > at dto.EJBTester.main(EJBTester.java:37) > Caused by: javax.persistence.PersistenceException: > org.hibernate.exception.SQLGrammarException: could not execute query > at > org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1214) > at > org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1147) > at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:255) > at model.ManageStudentDao.getStudents(ManageStudentDao.java:52) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) > at java.lang.reflect.Method.invoke(Unknown Source) > at > org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181) > at > org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163) > at org.apache.openejb.cdi.CdiInterceptor.invoke(CdiInterceptor.java:128) > at > org.apache.openejb.cdi.CdiInterceptor.access$000(CdiInterceptor.java:43) > at org.apache.openejb.cdi.CdiInterceptor$1.call(CdiInterceptor.java:64) > at > org.apache.openejb.cdi.CdiInterceptor.aroundInvoke(CdiInterceptor.java:70) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) > at java.lang.reflect.Method.invoke(Unknown Source) > at > org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181) > at > org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163) > at > org.apache.openejb.monitoring.StatsInterceptor.record(StatsInterceptor.java:176) > at > org.apache.openejb.monitoring.StatsInterceptor.invoke(StatsInterceptor.java:95) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) > at java.lang.reflect.Method.invoke(Unknown Source) > at > org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181) > at > org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163) > at > org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:138) > at > org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:237) > at > org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:189) > at > org.apache.openejb.core.ivm.EjbObjectProxyHandler.synchronizedBusinessMethod(EjbObjectProxyHandler.java:253) > at > org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:248) > at > org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:92) > at > org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:279) > ... 3 more > Caused by: org.hibernate.exception.SQLGrammarException: could not execute > query > at > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) > at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) > at org.hibernate.loader.Loader.doList(Loader.java:2536) > at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) > at org.hibernate.loader.Loader.list(Loader.java:2271) > at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452) > at > org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) > at > org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) > at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268) > at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) > at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:246) > ... 35 more > Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object > not found: STUDENTDAO > at org.hsqldb.jdbc.Util.sqlException(Unknown Source) > at org.hsqldb.jdbc.Util.sqlException(Unknown Source) > at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source) > at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source) > at > org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281) > at > org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281) > at > org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534) > at > org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452) > at > org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161) > at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700) > at org.hibernate.loader.Loader.doQuery(Loader.java:801) > at > org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) > at org.hibernate.loader.Loader.doList(Loader.java:2533) > ... 43 more > Caused by: org.hsqldb.HsqlException: user lacks privilege or object not > found: STUDENTDAO > at org.hsqldb.error.Error.error(Unknown Source) > at org.hsqldb.error.Error.error(Unknown Source) > at org.hsqldb.SchemaManager.getTable(Unknown Source) > at org.hsqldb.ParserDQL.readTableName(Unknown Source) > at org.hsqldb.ParserDQL.readTableOrSubquery(Unknown Source) > at org.hsqldb.ParserDQL.XreadTableReference(Unknown Source) > at org.hsqldb.ParserDQL.XreadFromClause(Unknown Source) > at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source) > at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source) > at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source) > at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source) > at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source) > at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source) > at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source) > at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source) > at org.hsqldb.ParserCommand.compilePart(Unknown Source) > at org.hsqldb.ParserCommand.compileStatement(Unknown Source) > at org.hsqldb.Session.compileStatement(Unknown Source) > at org.hsqldb.StatementManager.compile(Unknown Source) > at org.hsqldb.Session.execute(Unknown Source) > ... 54 more > > i have gone thru tones of pages in this context but could not solve it. > > Please help > > Regards > Vijay > > > > > > -- > View this message in context: > http://openejb.979440.n4.nabble.com/TOMEE-1-6-injects-HSQL-DB-Inspite-of-providing-MYSQL-SB-tp4666442.html > Sent from the OpenEJB User mailing list archive at Nabble.com. >
