persistence.xml file for MS SQL Server 2000

[Aneesh Gopalan]

Currently i am reading a book "Pro EJB 3 Java persistence API". In chapter 2 of that book authors written a simple java persistence code to run in a Java SE environment. But i don't know how to run that code..I am using SQL Server 2000 for persistence.. Could you please tell me how run that code in Java SE...
please tell me the details of how to create persistence.xml file for SQL Server 2000...

Employee.java

 
import javax.persistence.*;
@Entity
public class  Employee
{
@Id private int id;
private String name;
private long salary;
public Employee(){}
public Employee(int id)
{ 
this.id = id;
}
public int getId()
{
return id;
}
public void setId(int id)
{
this.id=id;
}
public String getName()
{
return name;
}
public void setName(String name)
{
this.name=name;
}
public long getSalary()
{
return salary;
}
public void setSalary(long salary)
{
this.salary=salary;
}
}
 

EmployeeService.java

  
import javax.persistence.*;
import java.util.Collection;
public class EmployeeService
{
protected EntityManager em;
public EmployeeService(EntityManager em)
{
this.em=em;
}
public Employee createEmployee(int id,String name,long salary)
{
Employee emp = new Employee(id);
emp.setName(name);
emp.setSalary(salary);
em.persist(emp);
return emp;
}
public Employee findEmployee(int id)
{
return em.find(Employee.class,id);
}
public void removeEmployee(int id)
{
Employee emp = findEmployee(id);
if (emp != null)
{
em.remove(emp);
}
}
public Employee raiseEmployeeSalary(int id,long raise)
{
Employee emp = findEmployee(id);
if (emp != null)
{
emp.setSalary(emp.getSalary() + raise);
}
return emp;
}
public Collection<Employee> findAllEmployees()
{
Query query = em.createQuery("select e from Employee e");
return (Collection<Employee> :wink: query.getResultList();
}
}
 
 

EmployeeTest.java

  
import javax.persistence.*;
import java.util.Collection;
public class EmployeeTest
{
public static void main(String[] args) 
{
EntityManagerFactory emf = Persistence.createEntityManagerFactory("EmployeeService");
EntityManager em = emf.createEntityManager();
EmployeeService service = new EmployeeService(em);
em.getTransaction().begin();
Employee emp = service.createEmployee(158,"Sreeraj",45000);
em.getTransaction().commit();
System.out.println("Persisted " + emp);
 
emp = service.findEmployee(158);
System.out.println("Found " + emp);
 
Collection<Employee> emps = service.findAllEmployees();
for (Employee e : emps)
{
System.out.println("Found employee " +e);
}
 
em.getTransaction().begin();
emp = service.raiseEmployeeSalary(158, 1000);
em.getTransaction().commit();
System.out.println("Updated " + emp);
// remove an employee
em.getTransaction().begin();
service.removeEmployee(158);
em.getTransaction().commit();
System.out.println("Removed Employee 158");
// close the EM and EMF when done
em.close();
emf.close();
}
}
 

[Paul Sturrock]

Which JPA implementation are you using?

[Ray Johnson]

If you are using hibernate this link might be helpful..

http://www.hibernate.org/hib_docs/entitymanager/reference/en/html/configuration.html

If you are using other implementations, the values will vary but the structure of you persistence.xml will be the same. Please post your findings if this information is useful.

[Aneesh Gopalan]

Thanks for your response...[ ]

I have installed glassfish on my system. I think glassfish contains a JPA library files..So i think i can use that jar files to run my java SE client code. Isn't glassfish cotains JPA?