OpenJPA 1.0.2 and PostgreSQL 8.2 - OneToMany-Problem

Sebastian Gauder Tue, 22 Apr 2008 01:37:37 -0700

Hey,

I'm trying to persist the following code:


Company c = new Company();
c.setId( (long)i );
c.setName( "Company "+i );
c.setCustomers( new HashSet<Customer>() );

for ( int j = 0; j < 5; j++ ) {

   Customer cus = new Customer();
   cus.setId( 100L*i+j );
   cus.setName( "Customer" + 100L*i+j );
   cus.setCompany(c);
   c.getCustomers().add(cus);
}

em.persist(c);

em.flush();


with these entities:

@Entity
@Table(name = "JBT_Company")
public class Company {

   protected Long id;

   public void setId(Long inId) {
       this.id = inId;
   }

   @Id
   public Long getId() {
       return id;
   }

   protected String name;

   public String getName() {
       return name;
   }

   public void setName(String name) {
       this.name = name;
   }

   protected Set<Customer> customerSet;

   @OneToMany(mappedBy = "company",cascade = CascadeType.ALL)
   public Set<Customer> getCustomers() {
       return customerSet;
   }

   public void setCustomers(Set<Customer> inCustomerSet) {
       this.customerSet = inCustomerSet;
   }
}


@Entity
@Table(name = "JBT_Customer")
public class Customer {

   protected Long id;

   public void setId(Long inId) {
       this.id = inId;
   }

   @Id
   public Long getId() {
       return id;
   }

   protected String name;

   public String getName() {
       return name;
   }

   public void setName(String name) {
       this.name = name;
   }

   protected Company company;

   @ManyToOne
   @JoinColumn(name = "company_id")
   public Company getCompany() {
       return company;
   }

   public void setCompany(Company inCompany) {
       this.company = inCompany;
   }
}

It works for MySQL, but not for PostgreSQL 8.2. The follwing Exceptionis thrown:

40235 postgres INFO [RMI TCP Connection(6)-10.0.10.88]openjpa.Runtime - Starting OpenJPA 1.0.240766 postgres TRACE [RMI TCP Connection(6)-10.0.10.88]openjpa.jdbc.SQL - <t 31001198, conn 3920972> executing prepstmnt5188636 SELECT NULL AS SEQUENCE_SCHEMA, relname AS SEQUENCE_NAME FROMpg_class WHERE relkind='S'40782 postgres TRACE [RMI TCP Connection(6)-10.0.10.88]openjpa.jdbc.SQL - <t 31001198, conn 3920972> [16 ms] spent41313 postgres TRACE [RMI TCP Connection(6)-10.0.10.88]openjpa.jdbc.SQL - <t 31001198, conn 24050576> executing prepstmnt17582220 DELETE FROM JBT_Customer41328 postgres TRACE [RMI TCP Connection(6)-10.0.10.88]openjpa.jdbc.SQL - <t 31001198, conn 24050576> [15 ms] spent41328 postgres TRACE [RMI TCP Connection(6)-10.0.10.88]openjpa.jdbc.SQL - <t 31001198, conn 24050576> executing prepstmnt3724097 DELETE FROM JBT_Company41328 postgres TRACE [RMI TCP Connection(6)-10.0.10.88]openjpa.jdbc.SQL - <t 31001198, conn 24050576> [0 ms] spent41422 postgres TRACE [RMI TCP Connection(6)-10.0.10.88]openjpa.jdbc.SQL - <t 31001198, conn 11834918> executing prepstmnt27655609 INSERT INTO JBT_Customer (id, name, company_id) VALUES (?, ?,?) [params=(long) 3, (String) Customer03, (long) 0]41438 postgres TRACE [RMI TCP Connection(6)-10.0.10.88]openjpa.jdbc.SQL - <t 31001198, conn 11834918> [16 ms] spent41438 postgres TRACE [RMI TCP Connection(6)-10.0.10.88]openjpa.jdbc.SQL - <t 31001198, conn 11834918> executing prepstmnt29204960 INSERT INTO JBT_Customer (id, name, company_id) VALUES (?, ?,?) [params=(long) 0, (String) Customer00, (long) 0]41453 postgres TRACE [RMI TCP Connection(6)-10.0.10.88]openjpa.jdbc.SQL - <t 31001198, conn 11834918> [15 ms] spent41453 postgres TRACE [RMI TCP Connection(6)-10.0.10.88]openjpa.jdbc.SQL - <t 31001198, conn 11834918> executing prepstmnt13540318 INSERT INTO JBT_Customer (id, name, company_id) VALUES (?, ?,?) [params=(long) 1, (String) Customer01, (long) 0]41453 postgres TRACE [RMI TCP Connection(6)-10.0.10.88]openjpa.jdbc.SQL - <t 31001198, conn 11834918> [0 ms] spent41453 postgres TRACE [RMI TCP Connection(6)-10.0.10.88]openjpa.jdbc.SQL - <t 31001198, conn 11834918> executing prepstmnt5978200 INSERT INTO JBT_Company (id, name) VALUES (?, ?) [params=(long)0, (String) Company 0]41469 postgres TRACE [RMI TCP Connection(6)-10.0.10.88]openjpa.jdbc.SQL - <t 31001198, conn 11834918> [16 ms] spent41469 postgres TRACE [RMI TCP Connection(6)-10.0.10.88]openjpa.jdbc.SQL - <t 31001198, conn 11834918> executing prepstmnt13640927 INSERT INTO JBT_Customer (id, name, company_id) VALUES (?, ?,?) [params=(long) 4, (String) Customer04, (long) 0]41469 postgres TRACE [RMI TCP Connection(6)-10.0.10.88]openjpa.jdbc.SQL - <t 31001198, conn 11834918> [0 ms] spent41469 postgres TRACE [RMI TCP Connection(6)-10.0.10.88]openjpa.jdbc.SQL - <t 31001198, conn 11834918> executing prepstmnt19188912 INSERT INTO JBT_Customer (id, name, company_id) VALUES (?, ?,?) [params=(long) 2, (String) Customer02, (long) 0]41485 postgres TRACE [RMI TCP Connection(6)-10.0.10.88]openjpa.jdbc.SQL - <t 31001198, conn 11834918> [16 ms] spent22.04.2008 10:12:26org.springframework.remoting.support.RemoteInvocationTraceInterceptor invokeWARNUNG: Processing of RmiServiceExporter remote call resulted in fatalexception: com.denkwerk.jbt.server.spring.SpringBenchmarkBean.buildUp<openjpa-1.0.2-r420667:627158 fatal general error>org.apache.openjpa.persistence.PersistenceException: The transaction hasbeen rolled back. See the nested exceptions for details on the errorsthat occurred.atorg.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2108)

   at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1955)
   at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1853)
   at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1624)

atorg.apache.openjpa.kernel.DelegatingBroker.flush(DelegatingBroker.java:973)atorg.apache.openjpa.persistence.EntityManagerImpl.flush(EntityManagerImpl.java:488)

   at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)