JPA not working with EJB3

[Sam Woodard]

I have the following code in my ejb

@Stateless
public class UserServiceBean implements UserService {
 
    /**
     * Default constructor. 
     */
    public UserServiceBean() {
        // TODO Auto-generated constructor stub
    }
 
	@Override
	public User create(User user) {
		EntityManagerFactory emf = Persistence.createEntityManagerFactory("workingpoint-model");
		EntityManager em = emf.createEntityManager();
		
		em.getTransaction().begin();
		
		em.persist(user);
		
		em.getTransaction().commit();
		
		em.close();
		
		return user;
	}
 
}

i am getting,

javax.persistence.PersistenceException: No Persistence provider for EntityManager named workingpoint-model
	at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:96)
	at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:66)
	at com.wp.dal.service.UserServiceBean.create(UserServiceBean.java:25)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.glassfish.ejb.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1018)
	at org.glassfish.ejb.security.application.EJBSecurityManager.invoke(EJBSecurityManager.java:1090)
	at com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:3846)
	at com.sun.ejb.containers.BaseContainer.__intercept(BaseContainer.java:5005)
	at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:4985)
	at com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvocationHandler.java:201)

f have put both toplink jars in the lib directory of the server, of the domain, in the ear and in both projects, the java jpa project and the ejb project, with no success.

My persistence.xml looks like this:

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.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_1_0.xsd">
	<persistence-unit name="workingpoint-model">
		<provider>oracle.toplink.essentials.PersistenceProvider</provider>
		<jta-data-source>jdbc/mysql</jta-data-source>
		<class>com.wp.model.Subscriber</class>
		<class>com.wp.model.BaseEntity</class>
		<class>com.wp.model.User</class>
		<class>com.wp.model.MultitenantEntity</class>
		<properties>
			<property name="toplink.jdbc.driver" value="com.mysql.jdbc.Driver"/>
			<property name="toplink.jdbc.url" value="jdbc:mysql://localhost:3306/wp_development"/>
			<property name="toplink.jdbc.user" value="root"/>
			<property name="toplink.jdbc.password" value=""/>
			<property name="toplink.ddl-generation" value="drop-and-create-tables"/>
			<property name="toplink.logging.level" value="FINE"/> 
		</properties>
	</persistence-unit>
</persistence>

Any help would be greatly appreciated.

Thanks in advance,
Sam

[Sandeep Awasthi]

Why not inject EntityManager?
like following.

@PersistenceContext
private EntityManager manager;


Also use annotations for transactions.

@TransactionAttribute(TransactionAttributeType.REQUIRED)

[Sam Woodard]

I have tried it both ways. Same result.

Thanks,
Sam

[Sandeep Awasthi]

I have done this on JBOSS 4.2. It works with Hibernate as JPA provider.

[Sandeep Awasthi]

<persistence>
	<persistence-unit name="unit1" transaction-type="JTA">
		<jta-data-source>java:/DB</jta-data-source>
		<class>pojo.test1</class>
		<class>pojo.test2</class>
	        <class>pojo.test3</class>
		
		<properties>
			<property name="hibernate.show_sql" value="true" />
			<property name="hibernate.format_sql" value="true" />
			<property name="hibernate.dialect" value="org.hibernate.dialect.Oracle9Dialect" />
			<property name="hibernate.hbm2ddl.auto" value="create" />
		</properties>
	</persistence-unit>
</persistence>

My persistence.xml

[Sandeep Awasthi]

I am little confused, why are you using two seperate projects, ejb and JPA?

[Sam Woodard]

2 reasons:

1) To separate the model from the business logic.
2) Eclipse provides additional functionality for ddl generation, etc for jpa projects

[Sandeep Awasthi]

Which application server are you using?

[Sam Woodard]

Glassfish

[Sandeep Awasthi]

My suggestion is

1) First try with simple example to create a session bean (In one project, do not use two projects). For example sayHello.
2) If that works, then create one test pojo class which will map to a table.
3) create persistence.xml in META-INF directory
4) Inject EntityManager in your session bean and try to pesist pojo from session bean.

Search for simple tutorial, it will work.