Eclipse Helios plus Jboss v5 plus Mysql. Database lesson online,
***********client


package Lesson.entities;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.rmi.PortableRemoteObject;


import java.util.Properties;
public class client {
    public static void main(String [] args){
        try {
             Properties env = new Properties();
             env.setProperty("java.naming.factory.initial", "org.jnp.interfaces.NamingContextFactory");
             env.setProperty("java.naming.provider.url", "localhost:1099");
             env.setProperty("java.naming.factory.url.pkgs", "org.jboss.naming");
            Context jndiContext = new InitialContext(env);
            Object ref = jndiContext.lookup("UserBean");
            UserRemote dao = (UserRemote)
            PortableRemoteObject.narrow(ref,UserRemote.class);
            Users user_1 = new Users();
            user_1.setId(1);
            user_1.setName("Name1");
            dao.createUser(user_1);
            Users cabin_2 = new Users();
            cabin_2.setId(2);
            cabin_2.setName("Name2");
            dao.createUser(cabin_2);
            System.out.println("Looking for user number 1...");
            user_1 = dao.findUser(1);
            System.out.println(user_1.getName());
            System.out.println("Looking for user number 2...");
            cabin_2 = dao.findUser(2);
            System.out.println(cabin_2.getName());
            }
            catch (javax.naming.NamingException ne){ne.printStackTrace();}
        }
}


**********UserBean
package Lesson.entities;

import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;

import Lesson.entities.Users;

import org.jboss.ejb3.annotation.*;


@Stateless
@RemoteBinding(jndiBinding="UserBean")
public class UserBean implements UserRemote {
@PersistenceContext(unitName="lesson")
private EntityManager manager;
public void createUser(Users user) {
    manager.persist(user);
}
public Users findUser(int pKey) {
    return manager.find(Users.class, pKey);
    }
}

****UserRemote
package Lesson.entities;

import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;

import Lesson.entities.Users;

import org.jboss.ejb3.annotation.*;


@Stateless
@RemoteBinding(jndiBinding="UserBean")
public class UserBean implements UserRemote {
@PersistenceContext(unitName="lesson")
private EntityManager manager;
public void createUser(Users user) {
    manager.persist(user);
}
public Users findUser(int pKey) {
    return manager.find(Users.class, pKey);
    }
}


****Users.Java

package Lesson.entities;
import javax.persistence.Entity;
import javax.persistence.Table;
import javax.persistence.Column;
import javax.persistence.Id;

@SuppressWarnings("serial")
@Entity
@Table(name="user")

public class Users implements java.io.Serializable {
    private int id;
    private String name;
    private String surname;
    private String pwd;
    private String email;
    private String priviledge;
    private String whose_ass;


@Id
@Column(name="user_id")
public int getId() {
    return id;
}

public void setId(int pk) {
    id=pk;
}
@Column(name="name")
public String getName() {
    return this.name;

}
public void setName(String str) {
    name=str;
}
@Column(name="surname")
public String getSurname() {
    return this.surname;
}
public void setSurname(String str) {
    surname=str;
}
@Column(name="pwd")
public String getPwd() {
    return this.pwd;
}
public void setPwd(String str) {
    pwd=str;
}
@Column(name="email")
public String getEmail() {
    return email;
}
public void setEmail(String str) {
    email=str;
}
@Column(name="priviledge")
public String getPriviledge() {
    return priviledge;
}
public void setPriviledge(String str) {
    priviledge=str;
}
@Column(name="whose_ass")
public String getAssistant() {
    return whose_ass;
}
public void setAssistant(String str) {
    whose_ass=str;
}
}

*****Persistence.xml

<?xml version="1.0" encoding="UTF-8"?>
<persistence>
<persistence-unit name="lesson">
<jta-data-source>java:/MySqlDS</jta-data-source>
<properties>
<property name="hibernate.hbm2ddl.auto" value="create-drop"/>
</properties>
</persistence-unit>
</persistence>


***lesson-ds.xml

<datasources>
    <local-tx-datasource>
        <jndi-name>lessonDS</jndi-name>
        <connection-url>jdbc:mysql://localhost:3306/lesson</connection-url>
        <driver-class>com.mysql.jdbc.Driver</driver-class>
        <user-name>jboss</user-name>
        <password>admin</password>
        <exception-sorter-class-name>
    org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter
    </exception-sorter-class-name>
        <metadata>
    <type-mapping>mySQL</type-mapping>
    </metadata>
    </local-tx-datasource>
</datasources>