error while deploying ejb3.0 in jboss 4.2

[Suresh Magi]

Hi,

I am learning EJB3.0 JPA and i tried deploying a sample bean on Jboss server and i am getting the following exception

ObjectName: persistence.units:jar=sampleEJB.jar,unitName=employeeDB
State: FAILED
Reason: java.lang.RuntimeException: You have not defined a jta-data-source for a JTA enabled persistence context named: employeeDB
Depends On Me:
jboss.j2ee:jar=sampleEJB.jar,name=SampleSessionBean,service=EJB3


how to resolve this problem and also tell me whether i need to configure datasource in jboss for this and whether any libraries i need to put for making this work.

I am trying to connect to oracle DB and also i am not sure whether my persistence.xml is right .. i am putting my persistence.xml over here and correct me by giving examples if there is anything wrong.

<persistence-unit name="employeeDB">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<class>com.edu.entity.EmployeeEntity</class>
<properties>
<property name="hibernate.connection.driver_class" value="oracle.jdbc.OracleDriver" />
<property name="hibernate.connection.url"
value="jdbc:oracle:thin:@localhost:1521:orcl" />
<property name="hibernate.connection.username" value="****" />
<property name="hibernate.connection.password" value="****" />
</properties>
</persistence-unit>

Thanks,
Suresh B

[Ankit Garg]

Well I am also working on a EJB 3 project and this is the type of persistance.xml that I use to access my MySQL database.

<?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="MySite-ejbPU" transaction-type="JTA">
    <provider>org.hibernate.ejb.HibernatePersistence</provider>
    <jta-data-source>java:MySqlDS</jta-data-source>
    <properties>
      <property name="hibernate.hbm2ddl.auto" value="update"/>
      <!--<property name="hibernate.show_sql" value="true"/>-->
    </properties>
  </persistence-unit>
</persistence>

In addition to this I use a mysql-ds.xml file which I put in the deploy folder of the jboss and mysql-connector.jar (which contains the MySql driver classes) in the lib folder of jboss

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
  <local-tx-datasource>
    <jndi-name>MySqlDS</jndi-name>
    <connection-url>jdbc:mysql://localhost:3306/databaseName</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>root</user-name>
    <password>root</password>
  </local-tx-datasource>
</datasources>

I don't know if this will work for oracle or not but I told you what I know. I Hope that this will help you...

[Suresh Magi]

Hi Ankit,

Thanks for the reply. It really helped me. I modified oracle-*.xml and dropped that file into deploy folder of JBOSS and changed my persistence.xml file a bit and then it started working.

Thanks,
Suresh B