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.
