Websphere 7 and OpenJPA

[Kevin P Smith]

Hi

I have been developing an application under Glassfish for the past few weeks, but have recently decided to change to Websphere 7.

But when I deplyed my app, whilst everthing seemed fine, I have found that when I INSERT into a table, whilst teh app creates a new row, it is populating all the fields with 'NULL', even though the values of the properties are in the DAO right upto the em.persist(dao) line.

Some looking into it and I have seen that under Glassfish I was using Toplink for my JPA but WAS7 seems to use OpenJPA.

I have tried to get this working but still I just get the same NULL value rows, I have included my persistence.xml and DAO for viewing and was hoping someone could tell me where I'm going wrong, is it the XML, DAO or are there JARs I need?

<?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="users" transaction-type="JTA">
		<jta-data-source>jdbc/users</jta-data-source>
		<properties>
		  <property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema(ForeignKeys=true)"/>
		</properties>
	</persistence-unit>
	<persistence-unit name="products" transaction-type="JTA">
		<jta-data-source>jdbc/products</jta-data-source>
		<properties>
		  <property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema(ForeignKeys=true)"/>
		</properties>
	</persistence-unit>
</persistence>

package com.myapp.business.beans;

import java.util.Map;

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

import com.myapp.business.dao.UserRegistrationDao;
import com.myapp.business.encryption.TripleDesDataEncryption;
import com.myapp.business.interfaces.UserRegistration;

@Stateless
public class UserRegistrationBean implements UserRegistration {

	TripleDesDataEncryption encrypt;
	
	@PersistenceContext(unitName = "users")
	private EntityManager _em;
	
	@Override
	public boolean create(Map<String, Object> args) {
		try {
			//Map<String, Object> newArgs = encrypt.encryption(args);
			UserRegistrationDao dao = new UserRegistrationDao(args);
			_em.persist(dao);
			return true;
		} catch (Exception ex) {
			ex.printStackTrace();
			return false;
		}
	}
}

package com.myapp.business.dao;

import static javax.persistence.GenerationType.IDENTITY;

import java.util.Map;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.PrimaryKeyJoinColumn;
import javax.persistence.SecondaryTable;
import javax.persistence.Table;

@Entity
@Table(name = "tbl_user_details")
@SecondaryTable(name = "tbl_secure_details", pkJoinColumns = @PrimaryKeyJoinColumn(name = "id"))
public class UserRegistrationDao implements java.io.Serializable {
	
	private static final long serialVersionUID = 4186345468121987543L;
	
	// user_details
	private int id;
	private String firstname;
	private String surname;
	private String email;

	// secure_details
	private String username;
	private String password;
	
	public UserRegistrationDao() {
		super();
	}
	public UserRegistrationDao(Map<String, Object> args) {
		super();
		this.firstname = (String)args.get("firstname");
		this.surname = (String)args.get("surname");
		this.email = (String)args.get("email");
		this.username = (String)args.get("username");
		this.password = (String)args.get("password");
	}
	
	@Id
	@GeneratedValue(strategy = GenerationType.AUTO)
	@Column(name="id")
	public int getId() {
		return this.id;
	}
	public void setId(int id) {
		this.id = id;
	}
	
	@Column(name="firstname")
	public synchronized final String getFirstname() {
		return this.firstname;
	}
	public synchronized final void setFirstname(String firstname) {
		this.firstname = firstname;
	}
	
	@Column(name="surname")
	public synchronized final String getSurname() {
		return this.surname;
	}
	public synchronized final void setSurname(String surname) {
		this.surname = surname;
	}
	
	@Column(name="email")
	public synchronized final String getEmail() {
		return this.email;
	}
	public synchronized final void setEmail(String email) {
		this.email = email;
	}
	
	@Column(name="username", table="secure_details")
	public synchronized final String getUsername() {
		return this.username;
	}
	public synchronized final void setUsername(String username) {
		this.username = username;
	}
	
	@Column(name="password", table="secure_details")
	public synchronized final String getPassword() {
		return this.password;
	}
	public synchronized final void setPassword(String password) {
		this.password = password;
	}
}

Cheers

KS