You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomee.apache.org by softvijay <so...@gmail.com> on 2013/11/28 16:49:53 UTC
TOMEE 1.6 injects HSQL DB Inspite of providing MYSQL SB
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.
Re: TOMEE 1.6 injects HSQL DB Inspite of providing MYSQL SB
Posted by Jean-Louis MONTEIRO <je...@gmail.com>.
Hi Vijay,
This is just because when you deploy your application on TomEE, it
automatically picks up the tomee.xml file on ${tomee.home}/conf
Extract from your logs
[]
*INFO: openejb.home =
C:\Tomee1.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:\Tomee1.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:\Tomee1.5\apache-tomee-1.5.1-plus\apache-tomee-plus-1.5.1\conf\tomee.xml'*
[]
When you run your simple java client, you are not running tomee, but the
OpenEJB embedded container.
First, maybe you don't know, but when initializing the InitialContext with
the Local context factory, OpenEJB lazily starts and deploy a classpath
application. Then the configuration file is found in the same place.
Second, you should instead use the Java EE 6 specific API (EJBContainer).
Finally, if you want to configure your datasource like in tomee, you can
either:
- change the file location or duplicate it in the right location
- use system properties to declare you datasource
- last, use the system property to specify where is you config file.
Here is the useful info from your logs
[]
*NFO: openejb.home = C:\vijay\vj\workspace\education28-Nov-2013 21:15:36
org.apache.openejb.OpenEJB$Instance <init>INFO: openejb.base =
C:\vijay\vj\workspace\education28-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
attemptto create one for the beans deployed.*
[]
As you can see, your config file is not used so default are used instead
and the default DS points to HSQL DB.
Hope that helps.
JLouis
2013/11/28 softvijay <so...@gmail.com>
> 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.
>
--
Jean-Louis
Re: TOMEE 1.6 injects HSQL DB Inspite of providing MYSQL SB
Posted by Romain Manni-Bucau <rm...@gmail.com>.
Dod you use tomee.xml? Can you reproduce it and share the project?
Le 28 nov. 2013 16:54, "softvijay" <so...@gmail.com> a écrit :
> 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.
>
Re: TOMEE 1.6 injects HSQL DB Inspite of providing MYSQL SB
Posted by Jean-Louis MONTEIRO <je...@gmail.com>.
Cool !
I guess you could also add the system property
*openejb.configuration=/your/tomee.xml
file*
*JLouis*
2013/11/29 softvijay <so...@gmail.com>
> Hi,
>
> Thanks a ton, by including openejb.xml in my project it is working as
> expected.
> details as follows:
>
> (1) /src/conf/openejb.xml
> <openejb>
> <Resource id="Default JDBC Database" type="DataSource">
> JdbcDriver com.mysql.jdbc.Driver
> JdbcUrl jdbc:mysql://localhost:3306/student
> UserName root
> Password
> JtaManaged true
> </Resource>
> </openejb>
>
> *OUTPUT*
> ------------------------
> INFO:
>
> ********************************************************************************
> 29-Nov-2013 12:48:23 org.apache.openejb.OpenEJB$Instance <init>
> INFO: openejb.home = C:\vijay\vj\workspace\education
> 29-Nov-2013 12:48:23 org.apache.openejb.OpenEJB$Instance <init>
> INFO: openejb.base = C:\vijay\vj\workspace\education
> 29-Nov-2013 12:48:23 org.apache.openejb.cdi.CdiBuilder initializeOWB
> INFO: Created new singletonService
> org.apache.openejb.cdi.ThreadSingletonServiceImpl@12f0999
> 29-Nov-2013 12:48:23 org.apache.openejb.cdi.CdiBuilder initializeOWB
> INFO: Succeeded in installing singleton service
> 29-Nov-2013 12:48:23 org.apache.openejb.config.ConfigurationFactory init
> INFO: openejb configuration file is
> 'C:\vijay\vj\workspace\education\conf\openejb.xml'
> 29-Nov-2013 12:48:23 org.apache.openejb.config.ConfigurationFactory
> configureService
> INFO: Configuring Service(id=Default Security Service,
> type=SecurityService,
> provider-id=Default Security Service)
> 29-Nov-2013 12:48:23 org.apache.openejb.config.ConfigurationFactory
> configureService
> INFO: Configuring Service(id=Default Transaction Manager,
> type=TransactionManager, provider-id=Default Transaction Manager)
> 29-Nov-2013 12:48:23 org.apache.openejb.config.ConfigurationFactory
> configureService
> INFO: Configuring Service(id=Default JDBC Database, type=Resource,
> provider-id=Default JDBC Database)
> 29-Nov-2013 12:48:23 org.apache.openejb.config.DeploymentsResolver
> processUrls
> INFO: Found EjbModule in classpath:
> c:\vijay\vj\workspace\education\build\classes
> 29-Nov-2013 12:48:25 org.apache.openejb.config.DeploymentsResolver
> loadFromClasspath
> INFO: Searched 13 classpath urls in 1577 milliseconds. Average 121
> milliseconds per url.
> 29-Nov-2013 12:48:25 org.apache.openejb.config.ConfigurationFactory
> loadApplication
> INFO: Beginning load: c:\vijay\vj\workspace\education\build\classes
> 29-Nov-2013 12:48:25 org.apache.openejb.config.ConfigurationFactory
> configureApplication
> INFO: Configuring enterprise application:
> C:\vijay\vj\workspace\education\classpath.ear
> 29-Nov-2013 12:48:25 org.apache.openejb.config.InitEjbDeployments deploy
> INFO: Auto-deploying ejb ManageStudentDao:
> EjbDeployment(deployment-id=ManageStudentDao)
> 29-Nov-2013 12:48:25 org.apache.openejb.config.ConfigurationFactory
> configureService
> INFO: Configuring Service(id=Default Stateless Container, type=Container,
> provider-id=Default Stateless Container)
> 29-Nov-2013 12:48:25 org.apache.openejb.config.AutoConfig createContainer
> INFO: Auto-creating a container for bean ManageStudentDao:
> Container(type=STATELESS, id=Default Stateless Container)
> 29-Nov-2013 12:48:25 org.apache.openejb.config.AutoConfig deploy
> INFO: Configuring PersistenceUnit(name=education_pu,
> provider=org.hibernate.ejb.HibernatePersistence)
> 29-Nov-2013 12:48:25 org.apache.openejb.config.AutoConfig
> logAutoCreateResource
> INFO: Auto-creating a Resource with id 'Default JDBC DatabaseNonJta' of
> type
> 'DataSource for 'education_pu'.
> 29-Nov-2013 12:48:25 org.apache.openejb.config.AutoConfig deploy
> INFO: Configuring Service(id=Default JDBC DatabaseNonJta, type=Resource,
> provider-id=Default JDBC Database)
> 29-Nov-2013 12:48:25 org.apache.openejb.config.AutoConfig
> setNonJtaDataSource
> INFO: Adjusting PersistenceUnit education_pu <non-jta-data-source> to
> Resource ID 'Default JDBC DatabaseNonJta' from 'null'
> 29-Nov-2013 12:48:25 org.apache.openejb.config.AppInfoBuilder build
> INFO: Enterprise application
> "C:\vijay\vj\workspace\education\classpath.ear"
> loaded.
> 29-Nov-2013 12:48:25 org.apache.openejb.assembler.classic.Assembler
> createRecipe
> INFO: Creating TransactionManager(id=Default Transaction Manager)
> 29-Nov-2013 12:48:25 org.apache.openejb.assembler.classic.Assembler
> createRecipe
> INFO: Creating SecurityService(id=Default Security Service)
> 29-Nov-2013 12:48:25 org.apache.openejb.assembler.classic.Assembler
> createRecipe
> INFO: Creating Resource(id=Default JDBC Database)
> 29-Nov-2013 12:48:26 org.apache.openejb.assembler.classic.Assembler
> createRecipe
> INFO: Creating Resource(id=Default JDBC DatabaseNonJta)
> 29-Nov-2013 12:48:26 org.apache.openejb.assembler.classic.Assembler
> createRecipe
> INFO: Creating Container(id=Default Stateless Container)
> 29-Nov-2013 12:48:26 org.apache.openejb.assembler.classic.Assembler
> createApplication
> INFO: Assembling app: C:\vijay\vj\workspace\education\classpath.ear
> 29-Nov-2013 12:48:26 org.hibernate.annotations.common.Version <clinit>
> INFO: Hibernate Commons Annotations 3.2.0.Final
> 29-Nov-2013 12:48:26 org.hibernate.cfg.Environment <clinit>
> INFO: Hibernate 3.6.0.Final
> 29-Nov-2013 12:48:26 org.hibernate.cfg.Environment <clinit>
> INFO: hibernate.properties not found
> 29-Nov-2013 12:48:26 org.hibernate.cfg.Environment buildBytecodeProvider
> INFO: Bytecode provider name : javassist
> 29-Nov-2013 12:48:26 org.hibernate.cfg.Environment <clinit>
> INFO: using JDK 1.4 java.sql.Timestamp handling
> 29-Nov-2013 12:48:26 org.hibernate.ejb.Version <clinit>
> INFO: Hibernate EntityManager 3.6.0.Final
> 29-Nov-2013 12:48:26 org.hibernate.ejb.Ejb3Configuration configure
> INFO: Processing PersistenceUnitInfo [
> name: education_pu
> ...]
> 29-Nov-2013 12:48:26 org.hibernate.cfg.AnnotationBinder bindClass
> INFO: Binding entity from annotated class: model.StudentDao
> 29-Nov-2013 12:48:26 org.hibernate.cfg.annotations.EntityBinder bindTable
> INFO: Bind entity model.StudentDao on table studentdao
> 29-Nov-2013 12:48:26 org.hibernate.cfg.Configuration
> applyHibernateValidatorLegacyConstraintsOnDDL
> INFO: Hibernate Validator not found: ignoring
> 29-Nov-2013 12:48:26
> org.hibernate.cfg.search.HibernateSearchEventListenerRegister
> enableHibernateSearch
> INFO: Unable to find org.hibernate.search.event.FullTextIndexEventListener
> on the classpath. Hibernate Search is not enabled.
> 29-Nov-2013 12:48:26 org.hibernate.connection.ConnectionProviderFactory
> initializeConnectionProviderFromConfig
> INFO: Initializing connection provider:
> org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider
> 29-Nov-2013 12:48:26
> org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider configure
> INFO: Using provided datasource
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: Database ->
> name : MySQL
> version : 5.1.49-community
> major : 5
> minor : 1
> 29-Nov-2013 12:48:26 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
> 29-Nov-2013 12:48:26 org.hibernate.dialect.Dialect <init>
> INFO: Using dialect: org.hibernate.dialect.MySQL5Dialect
> 29-Nov-2013 12:48:26 org.hibernate.engine.jdbc.JdbcSupportLoader
> useContextualLobCreation
> INFO: Disabling contextual LOB creation as JDBC driver reported JDBC
> version
> [3] less than 4
> 29-Nov-2013 12:48:26 org.hibernate.transaction.TransactionFactoryFactory
> buildTransactionFactory
> INFO: Transaction strategy:
> org.hibernate.ejb.transaction.JoinableCMTTransactionFactory
> 29-Nov-2013 12:48:26
> org.hibernate.transaction.TransactionManagerLookupFactory
> getTransactionManagerLookup
> INFO: instantiating TransactionManagerLookup:
> org.apache.openejb.hibernate.TransactionManagerLookup
> 29-Nov-2013 12:48:26
> org.hibernate.transaction.TransactionManagerLookupFactory
> getTransactionManagerLookup
> INFO: instantiated TransactionManagerLookup
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: Automatic flush during beforeCompletion(): disabled
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: Automatic session close at end of transaction: disabled
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: JDBC batch size: 15
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: JDBC batch updates for versioned data: disabled
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: Scrollable result sets: enabled
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: JDBC3 getGeneratedKeys(): enabled
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: Connection release mode: auto
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: Maximum outer join fetch depth: 2
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: Default batch fetch size: 1
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: Generate SQL with comments: enabled
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: Order SQL updates by primary key: disabled
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: Order SQL inserts for batching: disabled
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory
> createQueryTranslatorFactory
> INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
> 29-Nov-2013 12:48:26 org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
> INFO: Using ASTQueryTranslatorFactory
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: Query language substitutions: {}
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: JPA-QL strict compliance: enabled
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: Second-level cache: enabled
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: Query cache: disabled
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory createRegionFactory
> INFO: Cache region factory :
> org.hibernate.cache.impl.NoCachingRegionFactory
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: Optimize cache for minimal puts: disabled
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: Structured second-level cache entries: disabled
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: Echoing all SQL to stdout
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: Statistics: disabled
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: Deleted entity synthetic identifier rollback: disabled
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: Default entity-mode: pojo
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: Named query checking : enabled
> 29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
> INFO: Check Nullability in Core (should be disabled when Bean Validation is
> on): disabled
> 29-Nov-2013 12:48:26 org.hibernate.impl.SessionFactoryImpl <init>
> INFO: building session factory
> 29-Nov-2013 12:48:27 org.hibernate.impl.SessionFactoryObjectFactory
> addInstance
> INFO: Not binding factory to JNDI, no JNDI name configured
> 29-Nov-2013 12:48:27
> org.apache.openejb.assembler.classic.PersistenceBuilder
> createEntityManagerFactory
> INFO: PersistenceUnit(name=education_pu,
> provider=org.hibernate.ejb.HibernatePersistence) - provider time 910ms
> 29-Nov-2013 12:48:27 org.apache.openejb.assembler.classic.JndiBuilder bind
> INFO: Jndi(name=ManageStudentDaoLocal) -->
> Ejb(deployment-id=ManageStudentDao)
> 29-Nov-2013 12:48:27 org.apache.openejb.assembler.classic.JndiBuilder bind
> INFO:
>
> Jndi(name=global/classpath.ear/education/ManageStudentDao!model.ManageStudentDaoLocal)
> --> Ejb(deployment-id=ManageStudentDao)
> 29-Nov-2013 12:48:27 org.apache.openejb.assembler.classic.JndiBuilder bind
> INFO: Jndi(name=global/classpath.ear/education/ManageStudentDao) -->
> Ejb(deployment-id=ManageStudentDao)
> 29-Nov-2013 12:48:27 org.apache.openejb.cdi.CdiBuilder initSingleton
> INFO: Existing thread singleton service in SystemInstance()
> org.apache.openejb.cdi.ThreadSingletonServiceImpl@12f0999
> 29-Nov-2013 12:48:27 org.apache.openejb.cdi.OpenEJBLifecycle
> startApplication
> INFO: OpenWebBeans Container is starting...
> 29-Nov-2013 12:48:27 org.apache.webbeans.plugins.PluginLoader startUp
> INFO: Adding OpenWebBeansPlugin : [CdiPlugin]
> 29-Nov-2013 12:48:27 org.apache.webbeans.plugins.PluginLoader startUp
> INFO: Adding OpenWebBeansPlugin : [OpenWebBeansJsfPlugin]
> 29-Nov-2013 12:48:27 org.apache.openejb.cdi.BeansDeployer
> validateInjectionPoints
> INFO: All injection points are validated successfully.
> 29-Nov-2013 12:48:27 org.apache.openejb.cdi.OpenEJBLifecycle
> startApplication
> INFO: OpenWebBeans Container has started, it took 78 ms.
> 29-Nov-2013 12:48:27 org.apache.openejb.assembler.classic.Assembler
> createApplication
> INFO: Created Ejb(deployment-id=ManageStudentDao,
> ejb-name=ManageStudentDao,
> container=Default Stateless Container)
> 29-Nov-2013 12:48:27 org.apache.openejb.assembler.classic.Assembler
> createApplication
> INFO: Started Ejb(deployment-id=ManageStudentDao,
> ejb-name=ManageStudentDao,
> container=Default Stateless Container)
> 29-Nov-2013 12:48:27 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_
> 1
> vijay
> 2
> alka
> 3
> anubhav
> 4
> raghav
> -------------------------
>
>
> I am really grateful for quick clue, thanks guys.
>
> Regards
> Vijay
>
>
>
> --
> View this message in context:
> http://openejb.979440.n4.nabble.com/TOMEE-1-6-injects-HSQL-DB-Inspite-of-providing-MYSQL-SB-tp4666442p4666458.html
> Sent from the OpenEJB User mailing list archive at Nabble.com.
>
--
Jean-Louis
Re: TOMEE 1.6 injects HSQL DB Inspite of providing MYSQL SB
Posted by softvijay <so...@gmail.com>.
Hi,
Thanks a ton, by including openejb.xml in my project it is working as
expected.
details as follows:
(1) /src/conf/openejb.xml
<openejb>
<Resource id="Default JDBC Database" type="DataSource">
JdbcDriver com.mysql.jdbc.Driver
JdbcUrl jdbc:mysql://localhost:3306/student
UserName root
Password
JtaManaged true
</Resource>
</openejb>
*OUTPUT*
------------------------
INFO:
********************************************************************************
29-Nov-2013 12:48:23 org.apache.openejb.OpenEJB$Instance <init>
INFO: openejb.home = C:\vijay\vj\workspace\education
29-Nov-2013 12:48:23 org.apache.openejb.OpenEJB$Instance <init>
INFO: openejb.base = C:\vijay\vj\workspace\education
29-Nov-2013 12:48:23 org.apache.openejb.cdi.CdiBuilder initializeOWB
INFO: Created new singletonService
org.apache.openejb.cdi.ThreadSingletonServiceImpl@12f0999
29-Nov-2013 12:48:23 org.apache.openejb.cdi.CdiBuilder initializeOWB
INFO: Succeeded in installing singleton service
29-Nov-2013 12:48:23 org.apache.openejb.config.ConfigurationFactory init
INFO: openejb configuration file is
'C:\vijay\vj\workspace\education\conf\openejb.xml'
29-Nov-2013 12:48:23 org.apache.openejb.config.ConfigurationFactory
configureService
INFO: Configuring Service(id=Default Security Service, type=SecurityService,
provider-id=Default Security Service)
29-Nov-2013 12:48:23 org.apache.openejb.config.ConfigurationFactory
configureService
INFO: Configuring Service(id=Default Transaction Manager,
type=TransactionManager, provider-id=Default Transaction Manager)
29-Nov-2013 12:48:23 org.apache.openejb.config.ConfigurationFactory
configureService
INFO: Configuring Service(id=Default JDBC Database, type=Resource,
provider-id=Default JDBC Database)
29-Nov-2013 12:48:23 org.apache.openejb.config.DeploymentsResolver
processUrls
INFO: Found EjbModule in classpath:
c:\vijay\vj\workspace\education\build\classes
29-Nov-2013 12:48:25 org.apache.openejb.config.DeploymentsResolver
loadFromClasspath
INFO: Searched 13 classpath urls in 1577 milliseconds. Average 121
milliseconds per url.
29-Nov-2013 12:48:25 org.apache.openejb.config.ConfigurationFactory
loadApplication
INFO: Beginning load: c:\vijay\vj\workspace\education\build\classes
29-Nov-2013 12:48:25 org.apache.openejb.config.ConfigurationFactory
configureApplication
INFO: Configuring enterprise application:
C:\vijay\vj\workspace\education\classpath.ear
29-Nov-2013 12:48:25 org.apache.openejb.config.InitEjbDeployments deploy
INFO: Auto-deploying ejb ManageStudentDao:
EjbDeployment(deployment-id=ManageStudentDao)
29-Nov-2013 12:48:25 org.apache.openejb.config.ConfigurationFactory
configureService
INFO: Configuring Service(id=Default Stateless Container, type=Container,
provider-id=Default Stateless Container)
29-Nov-2013 12:48:25 org.apache.openejb.config.AutoConfig createContainer
INFO: Auto-creating a container for bean ManageStudentDao:
Container(type=STATELESS, id=Default Stateless Container)
29-Nov-2013 12:48:25 org.apache.openejb.config.AutoConfig deploy
INFO: Configuring PersistenceUnit(name=education_pu,
provider=org.hibernate.ejb.HibernatePersistence)
29-Nov-2013 12:48:25 org.apache.openejb.config.AutoConfig
logAutoCreateResource
INFO: Auto-creating a Resource with id 'Default JDBC DatabaseNonJta' of type
'DataSource for 'education_pu'.
29-Nov-2013 12:48:25 org.apache.openejb.config.AutoConfig deploy
INFO: Configuring Service(id=Default JDBC DatabaseNonJta, type=Resource,
provider-id=Default JDBC Database)
29-Nov-2013 12:48:25 org.apache.openejb.config.AutoConfig
setNonJtaDataSource
INFO: Adjusting PersistenceUnit education_pu <non-jta-data-source> to
Resource ID 'Default JDBC DatabaseNonJta' from 'null'
29-Nov-2013 12:48:25 org.apache.openejb.config.AppInfoBuilder build
INFO: Enterprise application "C:\vijay\vj\workspace\education\classpath.ear"
loaded.
29-Nov-2013 12:48:25 org.apache.openejb.assembler.classic.Assembler
createRecipe
INFO: Creating TransactionManager(id=Default Transaction Manager)
29-Nov-2013 12:48:25 org.apache.openejb.assembler.classic.Assembler
createRecipe
INFO: Creating SecurityService(id=Default Security Service)
29-Nov-2013 12:48:25 org.apache.openejb.assembler.classic.Assembler
createRecipe
INFO: Creating Resource(id=Default JDBC Database)
29-Nov-2013 12:48:26 org.apache.openejb.assembler.classic.Assembler
createRecipe
INFO: Creating Resource(id=Default JDBC DatabaseNonJta)
29-Nov-2013 12:48:26 org.apache.openejb.assembler.classic.Assembler
createRecipe
INFO: Creating Container(id=Default Stateless Container)
29-Nov-2013 12:48:26 org.apache.openejb.assembler.classic.Assembler
createApplication
INFO: Assembling app: C:\vijay\vj\workspace\education\classpath.ear
29-Nov-2013 12:48:26 org.hibernate.annotations.common.Version <clinit>
INFO: Hibernate Commons Annotations 3.2.0.Final
29-Nov-2013 12:48:26 org.hibernate.cfg.Environment <clinit>
INFO: Hibernate 3.6.0.Final
29-Nov-2013 12:48:26 org.hibernate.cfg.Environment <clinit>
INFO: hibernate.properties not found
29-Nov-2013 12:48:26 org.hibernate.cfg.Environment buildBytecodeProvider
INFO: Bytecode provider name : javassist
29-Nov-2013 12:48:26 org.hibernate.cfg.Environment <clinit>
INFO: using JDK 1.4 java.sql.Timestamp handling
29-Nov-2013 12:48:26 org.hibernate.ejb.Version <clinit>
INFO: Hibernate EntityManager 3.6.0.Final
29-Nov-2013 12:48:26 org.hibernate.ejb.Ejb3Configuration configure
INFO: Processing PersistenceUnitInfo [
name: education_pu
...]
29-Nov-2013 12:48:26 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: model.StudentDao
29-Nov-2013 12:48:26 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity model.StudentDao on table studentdao
29-Nov-2013 12:48:26 org.hibernate.cfg.Configuration
applyHibernateValidatorLegacyConstraintsOnDDL
INFO: Hibernate Validator not found: ignoring
29-Nov-2013 12:48:26
org.hibernate.cfg.search.HibernateSearchEventListenerRegister
enableHibernateSearch
INFO: Unable to find org.hibernate.search.event.FullTextIndexEventListener
on the classpath. Hibernate Search is not enabled.
29-Nov-2013 12:48:26 org.hibernate.connection.ConnectionProviderFactory
initializeConnectionProviderFromConfig
INFO: Initializing connection provider:
org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider
29-Nov-2013 12:48:26
org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider configure
INFO: Using provided datasource
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Database ->
name : MySQL
version : 5.1.49-community
major : 5
minor : 1
29-Nov-2013 12:48:26 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
29-Nov-2013 12:48:26 org.hibernate.dialect.Dialect <init>
INFO: Using dialect: org.hibernate.dialect.MySQL5Dialect
29-Nov-2013 12:48:26 org.hibernate.engine.jdbc.JdbcSupportLoader
useContextualLobCreation
INFO: Disabling contextual LOB creation as JDBC driver reported JDBC version
[3] less than 4
29-Nov-2013 12:48:26 org.hibernate.transaction.TransactionFactoryFactory
buildTransactionFactory
INFO: Transaction strategy:
org.hibernate.ejb.transaction.JoinableCMTTransactionFactory
29-Nov-2013 12:48:26
org.hibernate.transaction.TransactionManagerLookupFactory
getTransactionManagerLookup
INFO: instantiating TransactionManagerLookup:
org.apache.openejb.hibernate.TransactionManagerLookup
29-Nov-2013 12:48:26
org.hibernate.transaction.TransactionManagerLookupFactory
getTransactionManagerLookup
INFO: instantiated TransactionManagerLookup
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic flush during beforeCompletion(): disabled
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic session close at end of transaction: disabled
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch size: 15
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch updates for versioned data: disabled
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Scrollable result sets: enabled
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC3 getGeneratedKeys(): enabled
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Connection release mode: auto
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Maximum outer join fetch depth: 2
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default batch fetch size: 1
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Generate SQL with comments: enabled
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL updates by primary key: disabled
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL inserts for batching: disabled
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory
createQueryTranslatorFactory
INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
29-Nov-2013 12:48:26 org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
INFO: Using ASTQueryTranslatorFactory
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query language substitutions: {}
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JPA-QL strict compliance: enabled
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Second-level cache: enabled
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query cache: disabled
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory createRegionFactory
INFO: Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Optimize cache for minimal puts: disabled
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Structured second-level cache entries: disabled
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Echoing all SQL to stdout
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Statistics: disabled
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Deleted entity synthetic identifier rollback: disabled
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default entity-mode: pojo
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Named query checking : enabled
29-Nov-2013 12:48:26 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Check Nullability in Core (should be disabled when Bean Validation is
on): disabled
29-Nov-2013 12:48:26 org.hibernate.impl.SessionFactoryImpl <init>
INFO: building session factory
29-Nov-2013 12:48:27 org.hibernate.impl.SessionFactoryObjectFactory
addInstance
INFO: Not binding factory to JNDI, no JNDI name configured
29-Nov-2013 12:48:27 org.apache.openejb.assembler.classic.PersistenceBuilder
createEntityManagerFactory
INFO: PersistenceUnit(name=education_pu,
provider=org.hibernate.ejb.HibernatePersistence) - provider time 910ms
29-Nov-2013 12:48:27 org.apache.openejb.assembler.classic.JndiBuilder bind
INFO: Jndi(name=ManageStudentDaoLocal) -->
Ejb(deployment-id=ManageStudentDao)
29-Nov-2013 12:48:27 org.apache.openejb.assembler.classic.JndiBuilder bind
INFO:
Jndi(name=global/classpath.ear/education/ManageStudentDao!model.ManageStudentDaoLocal)
--> Ejb(deployment-id=ManageStudentDao)
29-Nov-2013 12:48:27 org.apache.openejb.assembler.classic.JndiBuilder bind
INFO: Jndi(name=global/classpath.ear/education/ManageStudentDao) -->
Ejb(deployment-id=ManageStudentDao)
29-Nov-2013 12:48:27 org.apache.openejb.cdi.CdiBuilder initSingleton
INFO: Existing thread singleton service in SystemInstance()
org.apache.openejb.cdi.ThreadSingletonServiceImpl@12f0999
29-Nov-2013 12:48:27 org.apache.openejb.cdi.OpenEJBLifecycle
startApplication
INFO: OpenWebBeans Container is starting...
29-Nov-2013 12:48:27 org.apache.webbeans.plugins.PluginLoader startUp
INFO: Adding OpenWebBeansPlugin : [CdiPlugin]
29-Nov-2013 12:48:27 org.apache.webbeans.plugins.PluginLoader startUp
INFO: Adding OpenWebBeansPlugin : [OpenWebBeansJsfPlugin]
29-Nov-2013 12:48:27 org.apache.openejb.cdi.BeansDeployer
validateInjectionPoints
INFO: All injection points are validated successfully.
29-Nov-2013 12:48:27 org.apache.openejb.cdi.OpenEJBLifecycle
startApplication
INFO: OpenWebBeans Container has started, it took 78 ms.
29-Nov-2013 12:48:27 org.apache.openejb.assembler.classic.Assembler
createApplication
INFO: Created Ejb(deployment-id=ManageStudentDao, ejb-name=ManageStudentDao,
container=Default Stateless Container)
29-Nov-2013 12:48:27 org.apache.openejb.assembler.classic.Assembler
createApplication
INFO: Started Ejb(deployment-id=ManageStudentDao, ejb-name=ManageStudentDao,
container=Default Stateless Container)
29-Nov-2013 12:48:27 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_
1
vijay
2
alka
3
anubhav
4
raghav
-------------------------
I am really grateful for quick clue, thanks guys.
Regards
Vijay
--
View this message in context: http://openejb.979440.n4.nabble.com/TOMEE-1-6-injects-HSQL-DB-Inspite-of-providing-MYSQL-SB-tp4666442p4666458.html
Sent from the OpenEJB User mailing list archive at Nabble.com.
Re: TOMEE 1.6 injects HSQL DB Inspite of providing MYSQL SB
Posted by Hildeberto Mendonça <hi...@yougi.org>.
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 <so...@gmail.com> 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.
>
Re: TOMEE 1.6 injects HSQL DB Inspite of providing MYSQL SB
Posted by Romain Manni-Bucau <rm...@gmail.com>.
${openejb.home}/conf/openejb.xml should work
Le 29 nov. 2013 05:41, "softvijay" <so...@gmail.com> a écrit :
> Hi Guys,
>
> Thanks for the valuable replies.
>
> I had specified datasource in tomee /conf/tomee.xml only also i had already
> copied this to eclipse workspace *server /conf/ *location
>
> one more thing, since i am executing it from normal java client file, is
> that means it is not using tomee.xml file or tomee infrastructure & hence
> looks for conf/openejb.xml file ?
>
> *
> INFO: Cannot find the configuration file [conf/openejb.xml]. Will
> attemptto create one for the beans deployed.*
> [] *
>
>
> Is that means, i need to define openejb.xml in my project locally. if that
> is the case, what would be it's location ?
>
> I am sorry for novoice questions, i am using it first time.
>
> Looking for your valuable inputs on this.
>
> Regards
> Vijay
>
>
>
> --
> View this message in context:
> http://openejb.979440.n4.nabble.com/TOMEE-1-6-injects-HSQL-DB-Inspite-of-providing-MYSQL-SB-tp4666442p4666455.html
> Sent from the OpenEJB User mailing list archive at Nabble.com.
>
Re: TOMEE 1.6 injects HSQL DB Inspite of providing MYSQL SB
Posted by softvijay <so...@gmail.com>.
Hi Guys,
Thanks for the valuable replies.
I had specified datasource in tomee /conf/tomee.xml only also i had already
copied this to eclipse workspace *server /conf/ *location
one more thing, since i am executing it from normal java client file, is
that means it is not using tomee.xml file or tomee infrastructure & hence
looks for conf/openejb.xml file ?
*
INFO: Cannot find the configuration file [conf/openejb.xml]. Will
attemptto create one for the beans deployed.*
[] *
Is that means, i need to define openejb.xml in my project locally. if that
is the case, what would be it's location ?
I am sorry for novoice questions, i am using it first time.
Looking for your valuable inputs on this.
Regards
Vijay
--
View this message in context: http://openejb.979440.n4.nabble.com/TOMEE-1-6-injects-HSQL-DB-Inspite-of-providing-MYSQL-SB-tp4666442p4666455.html
Sent from the OpenEJB User mailing list archive at Nabble.com.