Regarding Entirty relationships...

[Bala Gangadhar]

Hi I am new to EJB 3.0
While working with Entity relationships i am getting the fallwoing error...
I have created a

customer

class and a

Address

calss and add one to one unidirectional relationship as fallwos...

@Entity

public class Customer implements Serializable {
......
......
/**
	 * @return the addr
	 */
	@OneToOne (cascade={CascadeType.ALL} )
	public Address getAddr() {
		return addr;
	}
....

and Address class as...

@Entity
public class Address implements Serializable{

	private static final long serialVersionUID = 471492011128278456L;
	private long addid;
....
....

And I am using the TravelAgent session bean to maintain the entities...

@Stateless
public class TravelAgent implements TravelAgentRemote {

	/**
	 * Default constructor.
	 */
	public TravelAgent() {
		System.out.println("-->>>>In the Constructor");
	}
@PersistenceContext(unitName = "titan")
	private EntityManager manager;
...
...
public long createCustomer(Customer cust){
		
		manager.persist(cust);
		
		return cust.getId();
	}
....

And the client code is as

Context jndiContext = getInitialContext( );
            Object ref = jndiContext.lookup("TravelAgent/remote");
            TravelAgentRemote dao = (TravelAgentRemote)
                PortableRemoteObject.narrow(ref,TravelAgentRemote.class);            
           
            Customer cust = new Customer();
            
            cust.setFirstName("Bala");
            cust.setLastName("Gangadhar");
            Address addr = new Address();
            addr.setStreet("KPHB");
            addr.setCity("Hyderabad");
            addr.setState("AP");
            cust.setAddr(addr);
             dao.createCustomer(cust);

And the problem is when i execute the client program for the first time it is adding the customer and address entities in the db successfully but for the second time i am getting an error. I could add another entity only after restarting the server....please let me know where i went wrong....
The error is...
Caused by: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:515)
... 29 more
Caused by: java.sql.BatchUpdateException: failed batch

[Bala Gangadhar]

Any one please reply....or let me know if you need more information.....

[Omar Al Kababji]

It fails to update/insert the values to the database, i would suggest double checking if there are some missing constraints. get the generated SQL commands and try executing them using a DB client. in addition SQL exceptions are wrapped inside another exception so I would suggest to get the original cause of the exception, which will explain the cause.

[Bala Gangadhar]

Thanks for the reply.... I got it now...thanks a alot...