Qualified OneToMany-ManyToOne relation

[Toni Black]

Hi, i try to build a sample qualified relation and get an error.

Internal Exception: java.sql.SQLIntegrityConstraintViolationException: cannot insert NULL into 'TIRE_POSITION'

@Entity
public class Bike {
	
	@OneToMany(mappedBy = "bike", cascade=CascadeType.ALL)
	@MapKeyColumn(name="TIRE_POSITION", nullable=false)
	private Map<String, Tire> tires;

	...
}

@Entity
public class Tire {
	
	@ManyToOne(cascade=CascadeType.ALL)
	@JoinColumn(name="BIKE_ID")
	private Bike bike;
	
	public enum TirePosition{
		FRONT("FRONT"), BACK("BACK");
		...
	}

}

public void testIt(){
		Bike bike = new Bike();

		Tire tireFront = new Tire();
		Tire tireBack = new Tire();
		Map<String, Tire> tires = new HashMap<String, Tire>();
		tires.put(Tire.TirePosition.BACK.getPosition(), tireBack);
		tires.put(Tire.TirePosition.FRONT.getPosition(), tireFront);
		bike.setTires(tires);
		
		EntityTransaction trans = em.getTransaction();
		trans.begin();
		em.persist(bike);
		trans.commit();
		
	}

Anyone an idea what is wrong here?

[H Paul]

Have some some settings (for example using hibernate)

  <property name="hibernate.show_sql">true</property>
  <property name="hibernate.format_sql">true</property>

to see all the DDL/Create Table statements and the DML/Insert statements
to see which Insert statment that cause the exception and go from there.

[Toni Black]

True, i should have posted it right at the beginning. But i was shure it is a very prevalent mistake The problem is that the column that should not be null is not inserted at all (visible in the second listing).

DDL create statments

CREATE TABLE BIKE (ID DECIMAL(15) NOT NULL, COLOUR VARCHAR(255), PRIMARY KEY (ID))
CREATE TABLE TIRE (ID VARCHAR(255) NOT NULL, BIKE_ID DECIMAL(15), TIRE_POSITION VARCHAR(255) NOT NULL, PRIMARY KEY (ID))
ALTER TABLE TIRE ADD CONSTRAINT FK_TIRE_BIKE_ID FOREIGN KEY (BIKE_ID) REFERENCES BIKE (ID)
CREATE TABLE SEQUENCE (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(15), PRIMARY KEY (SEQ_NAME))
INSERT INTO SEQUENCE(SEQ_NAME, SEQ_COUNT) values ('SEQ_GEN', 0)

and the insert statement

Call: INSERT INTO TIRE (ID, BIKE_ID) VALUES (?, ?)
	bind => [1, 2]

Anyone an idea?

[H Paul]

Come on, let's reason together. And see what we can learn.

Can you post the code entirely for 2 classes: Bike and Tire?

[Toni Black]

As you can see i tried different approaches (commented in Tire and Bike) but always with the same result of no value for the TIRE_POSITION column.

package myPckg.tests.qualifiedRelation;

import java.math.BigDecimal;
import java.util.Map;

import javax.persistence.CascadeType;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.MapKeyColumn;
import javax.persistence.OneToMany;
import javax.persistence.Table;

@Entity
@Table(name="BIKE")
public class Bike {
	@Id
	@GeneratedValue(strategy = GenerationType.AUTO)
	private BigDecimal id;

	private String colour;

	//coderanch state
	@OneToMany(mappedBy="bike", cascade=CascadeType.ALL)
	@MapKeyColumn(name="TIRE_POSITION", nullable=false)
	private Map<String, Tire> tires;
	
	/* 
	//last state
	@OneToMany(mappedBy="bike")
//	@JoinTable(name="BIKE_TIRES_", joinColumns=@JoinColumn(name="BIKE_ID", referencedColumnName="ID"), inverseJoinColumns=@JoinColumn(name="TIRE_ID", referencedColumnName="ID"))
	@MapKeyColumn(name="TIRE_POSITION", nullable=false)
	private Map<String, Tire> tires;
	 */

	public BigDecimal getId() {
		return id;
	}

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

	public String getColour() {
		return colour;
	}

	public void setColour(String colour) {
		this.colour = colour;
	}

	public Map<String, Tire> getTires() {
		return tires;
	}

	public void setTires(Map<String, Tire> tires) {
		this.tires = tires;
	}


}

package myPckg.tests.qualifiedRelation;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToOne;
import javax.persistence.Table;

@Entity
@Table(name="TIRE")
public class Tire {
	@Id
	@GeneratedValue(strategy = GenerationType.AUTO)
	@Column(name="ID")
	private String id;

	@ManyToOne(cascade=CascadeType.ALL)
	@JoinColumn(name="BIKE_ID")
	private Bike bike;
	
	/*
	//last state
	@ManyToOne
	@JoinTable(name="BIKE_TIRES_", joinColumns=@JoinColumn(name="TIRE_ID", referencedColumnName="ID"), inverseJoinColumns=@JoinColumn(name="BIKE_ID", referencedColumnName="ID"))
	private Bike bike;
	*/

	public Bike getBike() {
		return bike;
	}

	public void setBike(Bike bike) {
		this.bike = bike;
	}

	public enum TirePosition {
		FRONT("FRONT"), BACK("BACK");

		private String position;

		private TirePosition(String pos) {
			this.position = pos;
		}

		public String getPosition() {
			return position;
		}

		public void setPosition(String position) {
			this.position = position;
		}
	}

}

And for the total completeness the test class.

package myPckg.tests.qualifiedRelation;

import java.util.HashMap;
import java.util.Map;

import javax.persistence.EntityTransaction;

import myPckg.tests.TestRoot;

import org.junit.Test;

public class MyTest extends TestRoot{

	
	@Test
	public void testIt(){
		Bike bike = new Bike();
		bike.setColour("red");

		Tire tireFront = new Tire();
		Tire tireBack = new Tire();
		
		Map<String, Tire> tires = new HashMap<String, Tire>();
		tires.put(Tire.TirePosition.BACK.getPosition(), tireBack);
		tires.put(Tire.TirePosition.FRONT.getPosition(), tireFront);
		tireFront.setBike(bike);
		tireBack.setBike(bike);
		bike.setTires(tires);
		
		EntityTransaction trans = em.getTransaction();
		trans.begin();
		em.persist(tireBack);
		em.persist(tireFront);
		em.persist(bike);
		
		trans.commit();
	}

}

[H Paul]

I depends 2 things:

DEBUGGER + DOC HIBERNATE - Relational Persistence for Idiomatic Java VERSION 4.3.6.Final
http://docs.jboss.org/hibernate/orm/4.3/manual/en-US/html_single/

7.2.2.2. Maps
Example 7.10. Use of target entity property as map key via @MapKey
Example 7.11. Map key as basic type using @MapKeyColumn


Most important:
Regardless of which of the above 2 ways,
the main cause of problem is that your Tire class is missing a critical piece of information:

	@Enumerated(EnumType.STRING)
	private TirePosition tirePosition;	/////// This is WHAT you do not have. This missing is the trouble.

Now can you adjust your code using below Option 1 or 2. Test and see how it is.
Do not forget to use the mentioned Hibernate documentation.

1. Option 1: using @MapKey

@Entity
public class Bike {

	@OneToMany(mappedBy="bike", cascade = CascadeType.ALL) 
	@MapKey(name = "tirePosition")
	private Map<String, Tire> tires=new HashMap<String, Tire>();

@Entity
public class Tire {

	@ManyToOne(cascade = CascadeType.ALL)
	@JoinColumn(name = "BIKE_ID")
	private Bike bike;

	@Enumerated(EnumType.STRING)
	private TirePosition tirePosition;  /////// This is WHAT you do not have. This missing is the trouble.


 2. Option 2: using @MapKeyColumn
@Entity
public class Bike {

	@Id
	@GeneratedValue
	private Integer id;

	//remove mappedBy="bike"
	//reason: org.hibernate.AnnotationException: Associations marked as mappedBy must not define database mappings like @JoinTable or @JoinColumn: 
	@OneToMany(cascade = CascadeType.ALL) 
	@JoinTable(name = "Bike_Tire")
	@MapKeyColumn(name = "TIRE_POSITION", nullable = false)
	private Map<String, Tire> tires=new HashMap<String, Tire>();

@Entity
public class Tire {

	@ManyToOne(cascade = CascadeType.ALL)
	@JoinColumn(name = "BIKE_ID")
	private Bike bike;

	@Enumerated(EnumType.STRING)
	private TirePosition tirePosition;  /////// This is WHAT you do not have. This missing is the trouble.

[Toni Black]

Hi,
i tried both suggestions and this are the results.

The test itself is the same for both options.

@Test
	public void testIt(){
		System.err.println("-");
		Bike bike = new Bike();
		bike.setColour("red");

		Tire tireFront = new Tire();
		Tire tireBack = new Tire();
		
		Map<String, Tire> tires = new HashMap<String, Tire>();
		tires.put(Tire.TirePosition.BACK.getPosition(), tireBack);
		tires.put(Tire.TirePosition.FRONT.getPosition(), tireFront);
		tireFront.setBike(bike);
		tireBack.setBike(bike);
		bike.setTires(tires);
		
		EntityTransaction trans = em.getTransaction();
		trans.begin();
		em.persist(tireBack);
		em.persist(tireFront);
		em.persist(bike);
//		em.flush();
		
		trans.commit();
		System.err.println("+");
	}

OPTION 1
-> PROBLEM : Still have null inserts for the key values.

package myPckg.tests.qualifiedRelation;

import java.util.HashMap;
import java.util.Map;
import javax.persistence.CascadeType;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.MapKey;
import javax.persistence.OneToMany;
import javax.persistence.Table;

@Entity
@Table(name="BIKE")
public class Bike {
	@Id
	@GeneratedValue
	private Long id;

	private String colour;
	
	@OneToMany(mappedBy="bike", cascade=CascadeType.ALL)
	@MapKey(name="tirePosition")
	private Map<String, Tire> tires = new HashMap<String, Tire>();

	public Long getId() {
		return id;
	}

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

	public String getColour() {
		return colour;
	}

	public void setColour(String colour) {
		this.colour = colour;
	}

	public Map<String, Tire> getTires() {
		return tires;
	}

	public void setTires(Map<String, Tire> tires) {
		this.tires = tires;
	}


}

package myPckg.tests.qualifiedRelation;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.EnumType;
import javax.persistence.Enumerated;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;

@Entity
@Table(name="TIRE")
public class Tire {
	@Id
	@GeneratedValue
	@Column(name="ID")
	private Long id;
	
	@ManyToOne(cascade=CascadeType.ALL)
	@JoinColumn(name="BIKE_ID")
	private Bike bike;
	
	@Enumerated(EnumType.STRING)
	private TirePosition tirePosition;

	public Bike getBike() {
		return bike;
	}

	public void setBike(Bike bike) {
		this.bike = bike;
	}

	public TirePosition getTirePosition() {
		return tirePosition;
	}

	public void setTirePosition(TirePosition tirePosition) {
		this.tirePosition = tirePosition;
	}

	public enum TirePosition {
		FRONT("FRONT"), BACK("BACK");

		private String position;

		private TirePosition(String pos) {
			this.position = pos;
		}

		public String getPosition() {
			return position;
		}

		public void setPosition(String position) {
			this.position = position;
		}
	}
}

[EL Info]: 2014-09-04 11:15:35.394--ServerSession(1138193439)--EclipseLink, version: Eclipse Persistence Services - 2.5.0.v20130507-3faac2b
[EL Info]: connection: 2014-09-04 11:15:35.914--ServerSession(1138193439)--file:/C:/Users/Luftballon/Documents/dokumente/certPrep/workspaceKepler/JpaOnly/target/classes/_EmbeddedDerbyEclipseLink login successful
[EL Fine]: sql: 2014-09-04 11:15:35.924--ServerSession(1138193439)--Connection(1478797373)--ALTER TABLE TIRE DROP CONSTRAINT FK_TIRE_BIKE_ID
[EL Fine]: sql: 2014-09-04 11:15:36.075--ServerSession(1138193439)--Connection(1478797373)--DROP TABLE BIKE
[EL Fine]: sql: 2014-09-04 11:15:36.105--ServerSession(1138193439)--Connection(1478797373)--DROP TABLE TIRE
[EL Fine]: sql: 2014-09-04 11:15:36.125--ServerSession(1138193439)--Connection(1478797373)--CREATE TABLE BIKE (ID BIGINT NOT NULL, COLOUR VARCHAR(255), PRIMARY KEY (ID))
[EL Fine]: sql: 2014-09-04 11:15:36.155--ServerSession(1138193439)--Connection(1478797373)--CREATE TABLE TIRE (ID BIGINT NOT NULL, TIREPOSITION VARCHAR(255), BIKE_ID BIGINT, PRIMARY KEY (ID))
[EL Fine]: sql: 2014-09-04 11:15:36.185--ServerSession(1138193439)--Connection(1478797373)--ALTER TABLE TIRE ADD CONSTRAINT FK_TIRE_BIKE_ID FOREIGN KEY (BIKE_ID) REFERENCES BIKE (ID)
[EL Fine]: sql: 2014-09-04 11:15:36.215--ServerSession(1138193439)--Connection(1478797373)--SELECT SEQ_NAME FROM SEQUENCE WHERE SEQ_NAME <> SEQ_NAME
[EL Fine]: sql: 2014-09-04 11:15:36.285--ServerSession(1138193439)--Connection(1478797373)--DELETE FROM SEQUENCE WHERE SEQ_NAME = SEQ_GEN
[EL Fine]: sql: 2014-09-04 11:15:36.295--ServerSession(1138193439)--Connection(1478797373)--SELECT * FROM SEQUENCE WHERE SEQ_NAME = SEQ_GEN
[EL Fine]: sql: 2014-09-04 11:15:36.295--ServerSession(1138193439)--Connection(1478797373)--INSERT INTO SEQUENCE(SEQ_NAME, SEQ_COUNT) values (SEQ_GEN, 0)
-
[EL Fine]: sql: 2014-09-04 11:15:36.345--ClientSession(2058135834)--Connection(1478797373)--UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ?
	bind => [50, SEQ_GEN]
[EL Fine]: sql: 2014-09-04 11:15:36.356--ClientSession(2058135834)--Connection(1478797373)--SELECT SEQ_COUNT FROM SEQUENCE WHERE SEQ_NAME = ?
	bind => [SEQ_GEN]
[EL Fine]: sql: 2014-09-04 11:15:36.366--ClientSession(2058135834)--Connection(1478797373)--INSERT INTO BIKE (ID, COLOUR) VALUES (?, ?)
	bind => [2, red]
[EL Fine]: sql: 2014-09-04 11:15:36.366--ClientSession(2058135834)--Connection(1478797373)--INSERT INTO TIRE (ID, TIREPOSITION, BIKE_ID) VALUES (?, ?, ?)
	bind => [1, null, 2]
[EL Fine]: sql: 2014-09-04 11:15:36.376--ClientSession(2058135834)--Connection(1478797373)--INSERT INTO TIRE (ID, TIREPOSITION, BIKE_ID) VALUES (?, ?, ?)
	bind => [3, null, 2]
+

BTW i tried to use the Hibernate instead of eclipselink with the following result.

Configuration used: EmbeddedDerbyHibernate
Sep 04, 2014 11:27:51 AM org.hibernate.jpa.internal.util.LogHelper logPersistenceUnitInformation
INFO: HHH000204: Processing PersistenceUnitInfo [
	name: EmbeddedDerbyHibernate
	...]
Sep 04, 2014 11:27:51 AM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {4.3.6.Final}
Sep 04, 2014 11:27:51 AM org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
Sep 04, 2014 11:27:51 AM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
Sep 04, 2014 11:27:51 AM org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {4.0.5.Final}
Sep 04, 2014 11:27:51 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
WARN: HHH000402: Using Hibernate built-in connection pool (not for production use!)
Sep 04, 2014 11:27:51 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH000401: using driver [org.apache.derby.jdbc.EmbeddedDriver] at URL [jdbc:derby:C:\Users\Luftballon\MyDB;create=true]
Sep 04, 2014 11:27:51 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH000046: Connection properties: {}
Sep 04, 2014 11:27:51 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH000006: Autocommit mode: false
Sep 04, 2014 11:27:51 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000115: Hibernate connection pool size: 20 (min=1)
Sep 04, 2014 11:27:52 AM org.hibernate.dialect.Dialect <init>
INFO: HHH000400: Using dialect: org.hibernate.dialect.HSQLDialect
Sep 04, 2014 11:27:52 AM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init>
INFO: HHH000397: Using ASTQueryTranslatorFactory
Sep 04, 2014 11:27:52 AM org.hibernate.tool.hbm2ddl.SchemaExport execute
INFO: HHH000227: Running hbm2ddl schema export
Hibernate: alter table TIRE drop constraint FK_lkbt14aikipcosa42ffx61d14
Sep 04, 2014 11:27:52 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: HHH000389: Unsuccessful: alter table TIRE drop constraint FK_lkbt14aikipcosa42ffx61d14
Sep 04, 2014 11:27:52 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: ALTER TABLE failed. There is no constraint 'APP.FK_LKBT14AIKIPCOSA42FFX61D14' on table '"APP"."TIRE"'. 
Hibernate: drop table BIKE if exists
Sep 04, 2014 11:27:52 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: HHH000389: Unsuccessful: drop table BIKE if exists
Sep 04, 2014 11:27:52 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: Syntax error: Encountered "if" at line 1, column 17.
Hibernate: drop table TIRE if exists
Sep 04, 2014 11:27:52 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: HHH000389: Unsuccessful: drop table TIRE if exists
Sep 04, 2014 11:27:52 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: Syntax error: Encountered "if" at line 1, column 17.
Hibernate: create table BIKE (id bigint generated by default as identity (start with 1), colour varchar(255), primary key (id))
Sep 04, 2014 11:27:52 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: HHH000389: Unsuccessful: create table BIKE (id bigint generated by default as identity (start with 1), colour varchar(255), primary key (id))
Sep 04, 2014 11:27:52 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: Table/View 'BIKE' already exists in Schema 'APP'.
Hibernate: create table TIRE (ID bigint generated by default as identity (start with 1), tirePosition varchar(255), BIKE_ID bigint, primary key (ID))
Sep 04, 2014 11:27:52 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: HHH000389: Unsuccessful: create table TIRE (ID bigint generated by default as identity (start with 1), tirePosition varchar(255), BIKE_ID bigint, primary key (ID))
Sep 04, 2014 11:27:52 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: Table/View 'TIRE' already exists in Schema 'APP'.
Hibernate: alter table TIRE add constraint FK_lkbt14aikipcosa42ffx61d14 foreign key (BIKE_ID) references BIKE
Sep 04, 2014 11:27:53 AM org.hibernate.tool.hbm2ddl.SchemaExport execute
INFO: HHH000230: Schema export complete
-
Hibernate: insert into BIKE (id, colour) values (default, ?)
Sep 04, 2014 11:27:53 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
WARN: SQL Error: 20000, SQLState: 23502
Sep 04, 2014 11:27:53 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
ERROR: Column 'ID'  cannot accept a NULL value.

OPTION 2
-> PROBLEM : i still have null inserts for the key values + two further columns in the tire table (which should be managed only in the Bike_Tire table)

package myPckg.tests.qualifiedRelation;

import java.util.HashMap;
import java.util.Map;
import javax.persistence.CascadeType;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinTable;
import javax.persistence.MapKeyColumn;
import javax.persistence.OneToMany;
import javax.persistence.Table;

@Entity
@Table(name="BIKE")
public class Bike {
	@Id
	@GeneratedValue
	private Long id;

	private String colour;

	@OneToMany(cascade = CascadeType.ALL)   
    @JoinTable(name = "Bike_Tire")  
    @MapKeyColumn(name = "TIRE_POSITION", nullable = false)  
    private Map<String, Tire> tires=new HashMap<String, Tire>();

	public Long getId() {
		return id;
	}

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

	public String getColour() {
		return colour;
	}

	public void setColour(String colour) {
		this.colour = colour;
	}

	public Map<String, Tire> getTires() {
		return tires;
	}

	public void setTires(Map<String, Tire> tires) {
		this.tires = tires;
	}


}

package myPckg.tests.qualifiedRelation;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.EnumType;
import javax.persistence.Enumerated;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;

@Entity
@Table(name="TIRE")
public class Tire {
	@Id
	@GeneratedValue
	@Column(name="ID")
	private Long id;
	
	@ManyToOne(cascade = CascadeType.ALL)  
    @JoinColumn(name = "BIKE_ID")  
    private Bike bike;  
	
	@Enumerated(EnumType.STRING)
	private TirePosition tirePosition;

	public Bike getBike() {
		return bike;
	}

	public void setBike(Bike bike) {
		this.bike = bike;
	}

	public TirePosition getTirePosition() {
		return tirePosition;
	}

	public void setTirePosition(TirePosition tirePosition) {
		this.tirePosition = tirePosition;
	}

	public enum TirePosition {
		FRONT("FRONT"), BACK("BACK");

		private String position;

		private TirePosition(String pos) {
			this.position = pos;
		}

		public String getPosition() {
			return position;
		}

		public void setPosition(String position) {
			this.position = position;
		}
	}
}

Configuration used: EmbeddedDerbyEclipseLink
[EL Info]: 2014-09-04 11:45:15.048--ServerSession(1601292138)--EclipseLink, version: Eclipse Persistence Services - 2.5.0.v20130507-3faac2b
[EL Info]: connection: 2014-09-04 11:45:15.458--ServerSession(1601292138)--file:/C:/Users/Luftballon/Documents/dokumente/certPrep/workspaceKepler/JpaOnly/target/classes/_EmbeddedDerbyEclipseLink login successful
[EL Fine]: sql: 2014-09-04 11:45:15.468--ServerSession(1601292138)--Connection(690052870)--ALTER TABLE TIRE DROP CONSTRAINT FK_TIRE_BIKE_ID
[EL Fine]: sql: 2014-09-04 11:45:15.559--ServerSession(1601292138)--VALUES(1)
[EL Fine]: sql: 2014-09-04 11:45:15.649--ServerSession(1601292138)--Connection(690052870)--ALTER TABLE Bike_Tire DROP CONSTRAINT Bike_Tire_Bike_ID
[EL Fine]: sql: 2014-09-04 11:45:15.659--ServerSession(1601292138)--VALUES(1)
[EL Fine]: sql: 2014-09-04 11:45:15.659--ServerSession(1601292138)--Connection(690052870)--ALTER TABLE Bike_Tire DROP CONSTRAINT Bike_Tire_tires_ID
[EL Fine]: sql: 2014-09-04 11:45:15.659--ServerSession(1601292138)--VALUES(1)
[EL Fine]: sql: 2014-09-04 11:45:15.659--ServerSession(1601292138)--Connection(690052870)--DROP TABLE BIKE
[EL Fine]: sql: 2014-09-04 11:45:15.659--ServerSession(1601292138)--VALUES(1)
[EL Fine]: sql: 2014-09-04 11:45:15.659--ServerSession(1601292138)--Connection(690052870)--DROP TABLE TIRE
[EL Fine]: sql: 2014-09-04 11:45:15.659--ServerSession(1601292138)--VALUES(1)
[EL Fine]: sql: 2014-09-04 11:45:15.659--ServerSession(1601292138)--Connection(690052870)--DROP TABLE Bike_Tire
[EL Fine]: sql: 2014-09-04 11:45:15.659--ServerSession(1601292138)--VALUES(1)
[EL Fine]: sql: 2014-09-04 11:45:15.659--ServerSession(1601292138)--Connection(690052870)--DROP TABLE BIKE
[EL Fine]: sql: 2014-09-04 11:45:15.659--ServerSession(1601292138)--VALUES(1)
[EL Fine]: sql: 2014-09-04 11:45:15.659--ServerSession(1601292138)--Connection(690052870)--DROP TABLE TIRE
[EL Fine]: sql: 2014-09-04 11:45:15.659--ServerSession(1601292138)--VALUES(1)
[EL Fine]: sql: 2014-09-04 11:45:15.659--ServerSession(1601292138)--Connection(690052870)--DROP TABLE Bike_Tire
[EL Fine]: sql: 2014-09-04 11:45:15.659--ServerSession(1601292138)--VALUES(1)
[EL Fine]: sql: 2014-09-04 11:45:15.659--ServerSession(1601292138)--Connection(690052870)--DROP TABLE BIKE
[EL Fine]: sql: 2014-09-04 11:45:15.659--ServerSession(1601292138)--VALUES(1)
[EL Fine]: sql: 2014-09-04 11:45:15.659--ServerSession(1601292138)--Connection(690052870)--DROP TABLE TIRE
[EL Fine]: sql: 2014-09-04 11:45:15.669--ServerSession(1601292138)--VALUES(1)
[EL Fine]: sql: 2014-09-04 11:45:15.669--ServerSession(1601292138)--Connection(690052870)--DROP TABLE Bike_Tire
[EL Fine]: sql: 2014-09-04 11:45:15.669--ServerSession(1601292138)--VALUES(1)
[EL Fine]: sql: 2014-09-04 11:45:15.669--ServerSession(1601292138)--Connection(690052870)--DROP TABLE BIKE
[EL Fine]: sql: 2014-09-04 11:45:15.669--ServerSession(1601292138)--VALUES(1)
[EL Fine]: sql: 2014-09-04 11:45:15.669--ServerSession(1601292138)--Connection(690052870)--DROP TABLE TIRE
[EL Fine]: sql: 2014-09-04 11:45:15.669--ServerSession(1601292138)--VALUES(1)
[EL Fine]: sql: 2014-09-04 11:45:15.669--ServerSession(1601292138)--Connection(690052870)--DROP TABLE Bike_Tire
[EL Fine]: sql: 2014-09-04 11:45:15.669--ServerSession(1601292138)--VALUES(1)
[EL Fine]: sql: 2014-09-04 11:45:15.669--ServerSession(1601292138)--Connection(690052870)--DROP TABLE BIKE
[EL Fine]: sql: 2014-09-04 11:45:15.669--ServerSession(1601292138)--VALUES(1)
[EL Fine]: sql: 2014-09-04 11:45:15.669--ServerSession(1601292138)--Connection(690052870)--DROP TABLE TIRE
[EL Fine]: sql: 2014-09-04 11:45:15.669--ServerSession(1601292138)--VALUES(1)
[EL Fine]: sql: 2014-09-04 11:45:15.669--ServerSession(1601292138)--Connection(690052870)--DROP TABLE Bike_Tire
[EL Fine]: sql: 2014-09-04 11:45:15.669--ServerSession(1601292138)--VALUES(1)
[EL Fine]: sql: 2014-09-04 11:45:15.669--ServerSession(1601292138)--Connection(690052870)--CREATE TABLE BIKE (ID BIGINT NOT NULL, COLOUR VARCHAR(255), PRIMARY KEY (ID))
[EL Fine]: sql: 2014-09-04 11:45:15.739--ServerSession(1601292138)--Connection(690052870)--CREATE TABLE TIRE (ID BIGINT NOT NULL, TIREPOSITION VARCHAR(255), BIKE_ID BIGINT, PRIMARY KEY (ID))
[EL Fine]: sql: 2014-09-04 11:45:15.759--ServerSession(1601292138)--Connection(690052870)--CREATE TABLE Bike_Tire (Bike_ID BIGINT NOT NULL, tires_ID BIGINT NOT NULL, TIRE_POSITION VARCHAR(255) NOT NULL, PRIMARY KEY (Bike_ID, tires_ID))
[EL Fine]: sql: 2014-09-04 11:45:15.779--ServerSession(1601292138)--Connection(690052870)--ALTER TABLE TIRE ADD CONSTRAINT FK_TIRE_BIKE_ID FOREIGN KEY (BIKE_ID) REFERENCES BIKE (ID)
[EL Fine]: sql: 2014-09-04 11:45:15.819--ServerSession(1601292138)--Connection(690052870)--ALTER TABLE Bike_Tire ADD CONSTRAINT Bike_Tire_Bike_ID FOREIGN KEY (Bike_ID) REFERENCES BIKE (ID)
[EL Fine]: sql: 2014-09-04 11:45:15.839--ServerSession(1601292138)--Connection(690052870)--ALTER TABLE Bike_Tire ADD CONSTRAINT Bike_Tire_tires_ID FOREIGN KEY (tires_ID) REFERENCES TIRE (ID)
[EL Fine]: sql: 2014-09-04 11:45:15.859--ServerSession(1601292138)--Connection(690052870)--SELECT SEQ_NAME FROM SEQUENCE WHERE SEQ_NAME <> SEQ_NAME
[EL Fine]: sql: 2014-09-04 11:45:15.879--ServerSession(1601292138)--Connection(690052870)--DELETE FROM SEQUENCE WHERE SEQ_NAME = SEQ_GEN
[EL Fine]: sql: 2014-09-04 11:45:15.899--ServerSession(1601292138)--Connection(690052870)--SELECT * FROM SEQUENCE WHERE SEQ_NAME = SEQ_GEN
[EL Fine]: sql: 2014-09-04 11:45:15.909--ServerSession(1601292138)--Connection(690052870)--INSERT INTO SEQUENCE(SEQ_NAME, SEQ_COUNT) values (SEQ_GEN, 0)
-
[EL Fine]: sql: 2014-09-04 11:45:15.949--ClientSession(1616359099)--Connection(690052870)--UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ?
	bind => [50, SEQ_GEN]
[EL Fine]: sql: 2014-09-04 11:45:15.969--ClientSession(1616359099)--Connection(690052870)--SELECT SEQ_COUNT FROM SEQUENCE WHERE SEQ_NAME = ?
	bind => [SEQ_GEN]
[EL Fine]: sql: 2014-09-04 11:45:15.97--ClientSession(1616359099)--Connection(690052870)--INSERT INTO BIKE (ID, COLOUR) VALUES (?, ?)
	bind => [2, red]
[EL Fine]: sql: 2014-09-04 11:45:15.98--ClientSession(1616359099)--Connection(690052870)--INSERT INTO TIRE (ID, TIREPOSITION, BIKE_ID) VALUES (?, ?, ?)
	bind => [1, null, 2]
[EL Fine]: sql: 2014-09-04 11:45:15.98--ClientSession(1616359099)--Connection(690052870)--INSERT INTO TIRE (ID, TIREPOSITION, BIKE_ID) VALUES (?, ?, ?)
	bind => [3, null, 2]
[EL Fine]: sql: 2014-09-04 11:45:15.98--ClientSession(1616359099)--Connection(690052870)--INSERT INTO Bike_Tire (tires_ID, Bike_ID) VALUES (?, ?)
	bind => [1, 2]
[EL Fine]: sql: 2014-09-04 11:45:15.99--ClientSession(1616359099)--VALUES(1)
[EL Warning]: 2014-09-04 11:45:15.99--ClientSession(1616359099)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.0.v20130507-3faac2b): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: Column 'TIRE_POSITION'  cannot accept a NULL value.
Error Code: 20000
Call: INSERT INTO Bike_Tire (tires_ID, Bike_ID) VALUES (?, ?)
	bind => [1, 2]
Query: DataModifyQuery(name="tires" sql="INSERT INTO Bike_Tire (tires_ID, Bike_ID) VALUES (?, ?)")

And the same test with hibernate

Configuration used: EmbeddedDerbyHibernate
Sep 04, 2014 11:44:00 AM org.hibernate.jpa.internal.util.LogHelper logPersistenceUnitInformation
INFO: HHH000204: Processing PersistenceUnitInfo [
	name: EmbeddedDerbyHibernate
	...]
Sep 04, 2014 11:44:00 AM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {4.3.6.Final}
Sep 04, 2014 11:44:00 AM org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
Sep 04, 2014 11:44:00 AM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
Sep 04, 2014 11:44:00 AM org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {4.0.5.Final}
Sep 04, 2014 11:44:00 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
WARN: HHH000402: Using Hibernate built-in connection pool (not for production use!)
Sep 04, 2014 11:44:00 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH000401: using driver [org.apache.derby.jdbc.EmbeddedDriver] at URL [jdbc:derby:C:\Users\Luftballon\MyDB;create=true]
Sep 04, 2014 11:44:00 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH000046: Connection properties: {}
Sep 04, 2014 11:44:00 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH000006: Autocommit mode: false
Sep 04, 2014 11:44:00 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000115: Hibernate connection pool size: 20 (min=1)
Sep 04, 2014 11:44:00 AM org.hibernate.dialect.Dialect <init>
INFO: HHH000400: Using dialect: org.hibernate.dialect.HSQLDialect
Sep 04, 2014 11:44:01 AM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init>
INFO: HHH000397: Using ASTQueryTranslatorFactory
Sep 04, 2014 11:44:01 AM org.hibernate.tool.hbm2ddl.SchemaExport execute
INFO: HHH000227: Running hbm2ddl schema export
Hibernate: alter table Bike_Tire drop constraint FK_5d111prgp84ubf3px31nfyu24
Sep 04, 2014 11:44:01 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: HHH000389: Unsuccessful: alter table Bike_Tire drop constraint FK_5d111prgp84ubf3px31nfyu24
Sep 04, 2014 11:44:01 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: 'ALTER TABLE' cannot be performed on 'BIKE_TIRE' because it does not exist.
Sep 04, 2014 11:44:01 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: HHH000389: Unsuccessful: alter table Bike_Tire drop constraint FK_jg25jkereeyvy575ds2430oh3
Sep 04, 2014 11:44:01 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: 'ALTER TABLE' cannot be performed on 'BIKE_TIRE' because it does not exist.
Sep 04, 2014 11:44:01 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: HHH000389: Unsuccessful: alter table TIRE drop constraint FK_lkbt14aikipcosa42ffx61d14
Sep 04, 2014 11:44:01 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: 'ALTER TABLE' cannot be performed on 'TIRE' because it does not exist.
Sep 04, 2014 11:44:01 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: HHH000389: Unsuccessful: drop table BIKE if exists
Sep 04, 2014 11:44:01 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: Syntax error: Encountered "if" at line 1, column 17.
Sep 04, 2014 11:44:01 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: HHH000389: Unsuccessful: drop table Bike_Tire if exists
Sep 04, 2014 11:44:01 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: Syntax error: Encountered "if" at line 1, column 22.
Sep 04, 2014 11:44:01 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: HHH000389: Unsuccessful: drop table TIRE if exists
Hibernate: alter table Bike_Tire drop constraint FK_jg25jkereeyvy575ds2430oh3
Hibernate: alter table TIRE drop constraint FK_lkbt14aikipcosa42ffx61d14
Hibernate: drop table BIKE if exists
Hibernate: drop table Bike_Tire if exists
Hibernate: drop table TIRE if exists
Sep 04, 2014 11:44:01 AM org.hibernate.tool.hbm2ddl.SchemaExport perform
ERROR: Syntax error: Encountered "if" at line 1, column 17.
Hibernate: create table BIKE (id bigint generated by default as identity (start with 1), colour varchar(255), primary key (id))
Hibernate: create table Bike_Tire (BIKE_id bigint not null, tires_ID bigint not null, TIRE_POSITION varchar(255) not null, primary key (BIKE_id, TIRE_POSITION))
Hibernate: create table TIRE (ID bigint generated by default as identity (start with 1), tirePosition varchar(255), BIKE_ID bigint, primary key (ID))
Hibernate: alter table Bike_Tire add constraint UK_5d111prgp84ubf3px31nfyu24  unique (tires_ID)
Hibernate: alter table Bike_Tire add constraint FK_5d111prgp84ubf3px31nfyu24 foreign key (tires_ID) references TIRE
Hibernate: alter table Bike_Tire add constraint FK_jg25jkereeyvy575ds2430oh3 foreign key (BIKE_id) references BIKE
Hibernate: alter table TIRE add constraint FK_lkbt14aikipcosa42ffx61d14 foreign key (BIKE_ID) references BIKE
Sep 04, 2014 11:44:01 AM org.hibernate.tool.hbm2ddl.SchemaExport execute
INFO: HHH000230: Schema export complete
-
Hibernate: insert into BIKE (id, colour) values (default, ?)
Hibernate: call identity()
Sep 04, 2014 11:44:01 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
WARN: SQL Error: 20000, SQLState: 42X01
Sep 04, 2014 11:44:01 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
ERROR: Syntax error: Encountered "identity" at line 1, column 6.

Other suggestions?

[H Paul]

For now, stick to the original issue, meaning stick with EclipseLink as your JPA provider.

Did you set the value for Tire position?

Instead of saying it does not work, use a DEBUGGER if you can't read the code and set a break at Map in your MyTest class, then examine
the state of tireFront and tireBack objects.

public class MyTest extends TestRoot{ 


        Tire tireFront = new Tire();  
        Tire tireBack = new Tire();  
          
        Map<String, Tire> tires = new HashMap<String, Tire>();  

[H Paul]

Toni,

1. For reference see my post dated posted September 1, 2014 10:34:47 AM PDT

For Option 2, you need this key piece of info: @Column(name="TIRE_POSITION")

	//EDITED 9/5/14: add @Column(name="TIRE_POSITION") 
	// @Column(name="TIRE_POSITION") is ABSOLUTELY NEEDED IF PERSISTED using EntityManager. 
	// (Some how it's not needed when persisted using SessionFactory). If @Column presents, it works for SessionFactory as well 
	@Column(name="TIRE_POSITION")  
	@Enumerated(EnumType.STRING)
	private TirePosition tirePosition;

2.

While testing using SessionFactory it worked fine without

@Column(name="TIRE_POSITION").

But with EntityManager, there is an exception.

Internal Exception: java.sql.SQLIntegrityConstraintViolationException: cannot insert NULL into 'TIRE_POSITION'  

To fix this, you need @Column(name="TIRE_POSITION")

3. Given you're using EntityManager, you need to copy the above code in point 1.

4. Should it OK now for your testing.

5. Mine worked perfectly in 2 cases using SessionFactory and EntityManager.

[Toni Black]

Big thanks for your effort to help me but i still don't get it . Could you post or upload the complete code (or probably the entire test project)?

[Dave Tolls]

A quick read through of this and the first question that pops into my head is, what is the actual name of the column in the database?
So far in this thread I've seen:
TIRE POSITION (I don't know if it's a sign of my age or something, but column names with spaces make me itch).
TIRE_POSITION
tirePosition