Getting error message - chapter 9 of ejb 3 in action using glassfish server 2.1

[nav katoch]

Hi all,

I am getting the following error message while running ant script after deploying:

 
C:\forGlassFishEJB3\glassfish\chapter9>ant run
Buildfile: build.xml

common:
     [echo] BuildName: chapter9
     [echo] BuildHome: C:\forGlassFishEJB3\glassfish\chapter9
     [echo] BuildFile: C:\forGlassFishEJB3\glassfish\chapter9\build.xml
     [echo] BuildJVM: 1.6

java-env-check:

init:
     [echo] -----> Initializing project properties

run:
     [echo] Executing client class using C:\EXAMPLES_HOME\glassfish/bin/appclient.bat
     [exec] Dec 26, 2009 6:57:36 PM com.sun.enterprise.appclient.MainWithModuleSupport <init>
     [exec] WARNING: ACC003: Application threw an exception.
     [exec] javax.ejb.EJBException: nested exception is: java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
     [exec]     java.rmi.RemoteException: null; nested exception is:
     [exec]     Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.1 (Build b31g-fcs (10/19/2009))): oracle.toplink.essentials.exceptions.DatabaseExce
ption
     [exec] Internal Exception: java.sql.SQLSyntaxErrorException: Table/View 'USERS' does not exist.
     [exec] Error Code: -1
     [exec] java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
     [exec]     java.rmi.RemoteException: null; nested exception is:
     [exec]     Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.1 (Build b31g-fcs (10/19/2009))): oracle.toplink.essentials.exceptions.DatabaseExce
ption
     [exec] Internal Exception: java.sql.SQLSyntaxErrorException: Table/View 'USERS' does not exist.
     [exec] Error Code: -1
     [exec]     at com.sun.corba.ee.impl.javax.rmi.CORBA.Util.mapSystemException(Util.java:243)
     [exec]     at com.sun.corba.ee.impl.presentation.rmi.StubInvocationHandlerImpl.privateInvoke(StubInvocationHandlerImpl.java:205)
     [exec]     at com.sun.corba.ee.impl.presentation.rmi.StubInvocationHandlerImpl.invoke(StubInvocationHandlerImpl.java:152)
     [exec]     at com.sun.corba.ee.impl.presentation.rmi.bcel.BCELStubBase.invoke(BCELStubBase.java:225)
     [exec]     at actionbazaar.buslogic.__ItemManager_Remote_DynamicStub.addItem(actionbazaar/buslogic/__ItemManager_Remote_DynamicStub.java)
     [exec]     at actionbazaar.buslogic._ItemManager_Wrapper.addItem(actionbazaar/buslogic/_ItemManager_Wrapper.java)
     [exec]     at actionbazaar.buslogic.ItemManagerClient.main(ItemManagerClient.java:14)
     [exec]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [exec]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     [exec]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [exec]     at java.lang.reflect.Method.invoke(Method.java:597)
     [exec]     at com.sun.enterprise.util.Utility.invokeApplicationMain(Utility.java:266)
     [exec]     at com.sun.enterprise.appclient.MainWithModuleSupport.<init>(MainWithModuleSupport.java:450)
     [exec]     at com.sun.enterprise.appclient.MainWithModuleSupport.<init>(MainWithModuleSupport.java:260)
     [exec]     at com.sun.enterprise.appclient.Main.main(Main.java:200)
     [exec] Caused by: java.rmi.RemoteException: null; nested exception is:
     [exec]     Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.1 (Build b31g-fcs (10/19/2009))): oracle.toplink.essentials.exceptions.DatabaseExce
ption
     [exec] Internal Exception: java.sql.SQLSyntaxErrorException: Table/View 'USERS' does not exist.
     [exec] Error Code: -1
     [exec]     at com.sun.enterprise.iiop.POAProtocolMgr.mapException(POAProtocolMgr.java:251)
     [exec]     at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1420)
     [exec]     at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1325)
     [exec]     at com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvocationHandler.java:210)
     [exec]     at com.sun.ejb.containers.EJBObjectInvocationHandlerDelegate.invoke(EJBObjectInvocationHandlerDelegate.java:117)
     [exec]     at $Proxy88.addItem(Unknown Source)
     [exec]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [exec]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     [exec]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [exec]     at java.lang.reflect.Method.invoke(Method.java:597)
     [exec]     at com.sun.corba.ee.impl.presentation.rmi.ReflectiveTie._invoke(ReflectiveTie.java:154)
     [exec]     at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:687)
     [exec]     at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:227)
     [exec]     at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1846)
     [exec]     at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:1706)
     [exec]     at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleInput(CorbaMessageMediatorImpl.java:1088)
     [exec]     at com.sun.corba.ee.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback(RequestMessage_1_2.java:223)
     [exec]     at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:806)
     [exec]     at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.dispatch(CorbaMessageMediatorImpl.java:563)
     [exec]     at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.doWork(CorbaMessageMediatorImpl.java:2567)
     [exec]     at com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:555)
     [exec] Caused by: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.1 (Build b31g-fcs (10/19/2009))): oracle.toplink.essentials.exceptions.Datab
aseException
     [exec] Internal Exception: java.sql.SQLSyntaxErrorException: Table/View 'USERS' does not exist.
     [exec] Error Code: -1
     [exec]     at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:319)
     [exec]     at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:566)
     [exec]     at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:452)
     [exec]     at oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSession.java:473)
     [exec]     at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
     [exec]     at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:214)
     [exec]     at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectOneRow(DatasourceCallQueryMechanism.java:635)
     [exec]     at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectOneRowFromTable(ExpressionQueryMechanism.java:2453)
     [exec]     at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectOneRow(ExpressionQueryMechanism.java:2428)
     [exec]     at oracle.toplink.essentials.queryframework.ReadObjectQuery.executeObjectLevelReadQuery(ReadObjectQuery.java:365)
     [exec]     at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:724)
     [exec]     at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:628)
     [exec]     at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:692)
     [exec]     at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:746)
     [exec]     at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2244)
     [exec]     at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:952)
     [exec]     at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:909)
     [exec]     at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerImpl.findInternal(EntityManagerImpl.java:354)
     [exec]     at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerImpl.findInternal(EntityManagerImpl.java:330)
     [exec]     at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerImpl.find(EntityManagerImpl.java:148)
     [exec]     at com.sun.enterprise.util.EntityManagerWrapper.find(EntityManagerWrapper.java:546)
     [exec]     at actionbazaar.buslogic.ItemManagerBean.addItem(ItemManagerBean.java:26)
     [exec]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [exec]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     [exec]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [exec]     at java.lang.reflect.Method.invoke(Method.java:597)
     [exec]     at com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1011)
     [exec]     at com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:175)
     [exec]     at com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2929)
     [exec]     at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:4020)
     [exec]     at com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvocationHandler.java:203)
     [exec]     ... 17 more
     [exec] Caused by: java.sql.SQLSyntaxErrorException: Table/View 'USERS' does not exist.
     [exec]     at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
     [exec]     at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
     [exec]     at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
     [exec]     at com.sun.gjc.spi.base.ConnectionHolder.prepareStatement(ConnectionHolder.java:475)
     [exec]     at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1162)
     [exec]     at oracle.toplink.essentials.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:612)
     [exec]     at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:485)
     [exec]     ... 46 more
     [exec] Caused by: org.apache.derby.client.am.SqlException: Table/View 'USERS' does not exist.
     [exec]     at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
     [exec]     at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
     [exec]     at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
     [exec]     at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
     [exec]     at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
     [exec]     at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
     [exec]     at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
     [exec]     at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source)
     [exec]     at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)
     [exec]     at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
     [exec]     at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
     [exec]     ... 51 more
     [exec] javax.ejb.EJBException: nested exception is: java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
     [exec]     java.rmi.RemoteException: null; nested exception is:
     [exec]     Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.1 (Build b31g-fcs (10/19/2009))): oracle.toplink.essentials.exceptions.DatabaseExce
ption
     [exec] Internal Exception: java.sql.SQLSyntaxErrorException: Table/View 'USERS' does not exist.
     [exec] Error Code: -1
     [exec]     at actionbazaar.buslogic._ItemManager_Wrapper.addItem(actionbazaar/buslogic/_ItemManager_Wrapper.java)
     [exec]     at actionbazaar.buslogic.ItemManagerClient.main(ItemManagerClient.java:14)
     [exec]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [exec]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     [exec]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [exec]     at java.lang.reflect.Method.invoke(Method.java:597)
     [exec]     at com.sun.enterprise.util.Utility.invokeApplicationMain(Utility.java:266)
     [exec]     at com.sun.enterprise.appclient.MainWithModuleSupport.<init>(MainWithModuleSupport.java:450)
     [exec]     at com.sun.enterprise.appclient.MainWithModuleSupport.<init>(MainWithModuleSupport.java:260)
     [exec]     at com.sun.enterprise.appclient.Main.main(Main.java:200)
     [exec] Exception in thread "main" java.lang.RuntimeException: java.lang.reflect.InvocationTargetException
     [exec]     at com.sun.enterprise.appclient.MainWithModuleSupport.<init>(MainWithModuleSupport.java:462)
     [exec]     at com.sun.enterprise.appclient.MainWithModuleSupport.<init>(MainWithModuleSupport.java:260)
     [exec]     at com.sun.enterprise.appclient.Main.main(Main.java:200)
     [exec] Caused by: java.lang.reflect.InvocationTargetException
     [exec]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [exec]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     [exec]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     [exec]     at java.lang.reflect.Method.invoke(Method.java:597)
     [exec]     at com.sun.enterprise.util.Utility.invokeApplicationMain(Utility.java:266)
     [exec]     at com.sun.enterprise.appclient.MainWithModuleSupport.<init>(MainWithModuleSupport.java:450)
     [exec]     ... 2 more
     [exec] Caused by: javax.ejb.EJBException: nested exception is: java.rmi.ServerException: RemoteException occurred in server thread; nested exception i
s:
     [exec]     java.rmi.RemoteException: null; nested exception is:
     [exec]     Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.1 (Build b31g-fcs (10/19/2009))): oracle.toplink.essentials.exceptions.DatabaseExce
ption
     [exec] Internal Exception: java.sql.SQLSyntaxErrorException: Table/View 'USERS' does not exist.
     [exec] Error Code: -1
     [exec]     at actionbazaar.buslogic._ItemManager_Wrapper.addItem(actionbazaar/buslogic/_ItemManager_Wrapper.java)
     [exec]     at actionbazaar.buslogic.ItemManagerClient.main(ItemManagerClient.java:14)
     [exec]     ... 8 more

BUILD SUCCESSFUL
Total time: 11 seconds  

Please guide me to fix this error message. I will appreciate your inputs.

Thanks,

Naveen

[Leonardo Carreira]

The message error told that :

Internal Exception: java.sql.SQLSyntaxErrorException: Table/View 'USERS' does not exist.

how do you configure your Entity class and persistence.xml?..

[nav katoch]

Hi Leonardo,

Thank you so much for your time and inputs. The following are the files for you to look at as I think I am missing something:-

persistence.xml

  
  <persistence>
 <persistence-unit name="actionBazaar">
<jta-data-source>jdbc/ActionBazaarDS</jta-data-source>b
</persistence-unit>
</persistence>

tables.sql

  
  
DROP TABLE CATEGORIES CASCADE CONSTRAINTS
/
DROP TABLE BILLING_DETAILS CASCADE CONSTRAINTS
/
DROP TABLE USERS CASCADE CONSTRAINTS
/
DROP TABLE CONTACT_DETAILS CASCADE CONSTRAINTS
/
DROP TABLE ITEMS CASCADE CONSTRAINTS
/
DROP TABLE CATEGORIES_ITEMS CASCADE CONSTRAINTS
/
DROP TABLE BIDS
/
DROP TABLE SEQUENCE
/

CREATE TABLE BILLING_DETAILS (
BILLING_ID NUMBER(19) NOT NULL,
 ACCOUNT_NO VARCHAR2(255) NULL, 
SECRET_CODE VARCHAR2(255) NULL, 
EXPIRY_DATE VARCHAR2(255) NULL, 
STREETNAME1 VARCHAR2(255) NULL, 
STREETNAME2 VARCHAR2(255) NULL, 
COUNTRY VARCHAR2(255) NULL, 
CITY VARCHAR2(255) NULL, 
STATE_CD VARCHAR2(255) NULL, 
ZIP_CD VARCHAR2(255) NULL, 
PRIMARY KEY (BILLING_ID))
/
CREATE TABLE CATEGORIES (
CATEGORY_ID NUMBER(19) NOT NULL, 
CATEGORY_NAME VARCHAR2(255) NULL, 
CREATE_DATE VARCHAR2(255) NULL, 
CREATED_BY VARCHAR2(255) NULL, 
PARENT_ID NUMBER(19) NULL, PRIMARY KEY (CATEGORY_ID))
/

CREATE TABLE USERS (
USER_ID VARCHAR2(255) NOT NULL, 
USER_TYPE VARCHAR2(1) NULL, 
BIRTH_DATE DATE NULL, 
FIRST_NAME VARCHAR2(255) NOT NULL, 
LAST_NAME VARCHAR2(255) NOT NULL, 
USER_BILLING_ID NUMBER(19) NULL, 
MAX_ITEMS NUMBER(19) NULL, 
COMM_RATE NUMBER(19,4) NULL, 
CREDIT_RATING NUMBER(19) NULL, 
BIDDER_STATUS VARCHAR2(255) NULL, 
PRIMARY KEY (USER_ID))
/     
CREATE TABLE CONTACT_DETAILS (
CONTACT_USER_ID VARCHAR2(255) NOT NULL, 
EMAIL VARCHAR2(255) NULL, 
PHONE VARCHAR2(10) NULL, 
STREETNAME1 VARCHAR2(255) NULL, 
STREETNAME2 VARCHAR2(255) NULL, 
COUNTRY VARCHAR2(255) NULL, 
CITY VARCHAR2(255) NULL, 
STATE_CODE VARCHAR2(255) NULL, 
ZIP_CODE VARCHAR2(255) NULL, 
PRIMARY KEY (CONTACT_USER_ID))
/
CREATE TABLE ITEMS (
ITEM_ID NUMBER(19) NOT NULL, 
INITIAL_PRICE NUMBER(19,4) NULL, 
ITEM_NAME VARCHAR2(255) NULL,
BID_START_DATE TIMESTAMP NULL, 
BID_END_DATE TIMESTAMP NULL, 
CREATED_DATE TIMESTAMP NULL, 
SELLER_ID VARCHAR2(255) NULL, 
PRIMARY KEY (ITEM_ID))
/ 
CREATE TABLE BIDS (BID_ID NUMBER(19) NOT NULL, 
BID_PRICE NUMBER(19,4) NULL, 
BID_STATUS VARCHAR2(255) NULL, 
BID_DATE DATE NULL, 
BID_ITEM_ID NUMBER(19) NULL, 
BID_BIDDER VARCHAR2(255) NULL, 
PRIMARY KEY (BID_ID))
/

CREATE TABLE CATEGORIES_ITEMS (
CI_CATEGORY_ID NUMBER(19) NOT NULL, 
CI_ITEM_ID NUMBER(19) NOT NULL, 
PRIMARY KEY
(CI_CATEGORY_ID, CI_ITEM_ID))
/
CREATE TABLE SEQUENCE (
SEQ_NAME VARCHAR2(50) NOT NULL, 
SEQ_COUNT NUMBER(38) NULL, 
PRIMARY KEY (SEQ_NAME))
/
CREATE SEQUENCE BILLING_SEQUENCE START WITH 1 INCREMENT BY 1
/

CREATE SEQUENCE CATEGORY_SEQ START WITH 1 INCREMENT BY 1
/
INSERT INTO SEQUENCE VALUES ('ITEM_SEQ', 3)
/
INSERT INTO SEQUENCE VALUES ('SEQ_GEN', 3)
/
commit
/

insert into users values ('idiot','B',null, 'Serious', 'Bidder', null,null, null, 40, 'NEW')
/
insert into users values ('idiot2','B',null, 'Very', 'Serious', null,null, null, 40, 'NEW')
/
insert into users values ('junkseller','S',null, 'Junk', 'Seller', null,null, 10, 20, null)
/
insert into users values ('viper','S',null, 'Viper', 'Admin', null,null, null, null, null)
/

insert into categories values (1000, 'Junk Cars', sysdate, 'viper', null)
/
insert into categories values (1001, 'House Hold Junks', sysdate, 'viper', null)
/
insert into categories_items values (1000, 1)
/
insert into categories_items values (1000, 2)
/
commit
/

User.java

  
package actionbazaar.persistence;

import java.io.Serializable;
import java.util.Date;
import java.util.Set;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.DiscriminatorColumn;
import javax.persistence.DiscriminatorType;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Inheritance;
import javax.persistence.InheritanceType;
import javax.persistence.JoinColumn;
import javax.persistence.OneToMany;
import javax.persistence.OneToOne;
import javax.persistence.PrimaryKeyJoinColumn;
import javax.persistence.Table;
import javax.persistence.Temporal;

@Entity
@Table(name = "USERS")
@Inheritance(strategy = InheritanceType.SINGLE_TABLE)
@DiscriminatorColumn(name = "USER_TYPE", discriminatorType = DiscriminatorType.STRING, length = 1)
public class User implements Serializable {
    private String firstName;

    private String lastName;

    private String userId;

    private byte[] picture;

    private Date birthDate;

    private BillingInfo billingInfo;

    private ContactInfo contactInfo;

    private Set<Category> categories;


    public User() {
    }


    public User(String firstName, String lastName, String userId) {
        this.firstName = firstName;
        this.lastName = lastName;
        this.userId = userId;
    }


    @Column(name = "FIRST_NAME", nullable = false)
    public String getFirstName() {
        return firstName;
    }


    public void setFirstName(String firstName) {
        this.firstName = firstName.toUpperCase();
    }


    @Column(name = "LAST_NAME", nullable = false)
    public String getLastName() {
        return lastName;
    }


    public void setLastName(String lastName) {
        this.lastName = lastName;
    }


    @Id
    @Column(name = "USER_ID", nullable = false)
    public String getUserId() {
        return userId;
    }


    public void setUserId(String userId) {
        this.userId = userId;
    }


    /*
     * @Column(name="PICTURE", table="USER_PICTURES") @Lob
     * @Basic(fetch=FetchType.LAZY) public byte[] getPicture() { return picture; }
     * 
     * public void setPicture(byte[] picture) { this.picture = picture; }
     */
    @Column(name = "BIRTH_DATE", nullable = false)
    @Temporal(javax.persistence.TemporalType.DATE)
    public Date getBirthDate() {
        return birthDate;
    }


    public void setBirthDate(Date birthDate) {
        this.birthDate = birthDate;
    }


    @OneToOne(cascade = CascadeType.ALL)
    @PrimaryKeyJoinColumn(name = "USER_ID", referencedColumnName = "CONTACT_USER_ID")
    public ContactInfo getContactInfo() {
        return contactInfo;
    }


    public void setContactInfo(ContactInfo contactInfo) {
        this.contactInfo = contactInfo;
    }


    @OneToOne(cascade = CascadeType.ALL)
    @JoinColumn(name = "USER_BILLING_ID", referencedColumnName = "BILLING_ID")
    public BillingInfo getBillingInfo() {
        return billingInfo;
    }


    public void setBillingInfo(BillingInfo billingInfo) {
        this.billingInfo = billingInfo;
    }


    @OneToMany(mappedBy = "user", cascade = CascadeType.ALL)
    public Set<Category> getcategories() {
        return categories;
    }


    public void setcategories(Set<Category> categories) {
        this.categories = categories;
    }


    public Category addCategory(Category category) {
        getcategories().add(category);
        category.setUser(this);
        return category;
    }


    public Category removeCategory(Category category) {
        getcategories().remove(category);
        category.setUser(null);
        return category;
    }
}

Thanks again for your time,

Naveen

[Leonardo Carreira]

Do you use Tables => Entity approach?..
i think you should define the User class in your persistence.xml..