[OLINGO-48] jpa reference application issues wtih sample data population

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: V2 1.0.0, V2 1.1.0
• Fix Version/s: V2 1.1.0
• Component/s: odata2-jpa
• Assignee: Chandan V.A
• Reporter: Georgi
• Created: 28/Oct/13 13:50
• Updated: 12/Nov/13 05:34
• Resolved: 01/Nov/13 16:25

Description

There's multiple issues in the jpa reference application:
1. Sample data is never populated - could be fixed with the following change in the org.apache.olingo.odata2.jpa.processor.ref.web.JPAReferenceServiceFactory

EntityManagerFactory emf = JPAEntityManagerFactory.getEntityManagerFactory(PUNIT_NAME);
DataGenerator generator = new DataGenerator(emf.createEntityManager());
generator.generate();
oDataJPAContext.setEntityManagerFactory(emf);

2. The sample data insert scripts have data constraint issues, e.g.:
Internal Exception: java.sql.SQLException: Violation of unique constraint SYS_PK_47: duplicate value(s) for column(s) SO_ID in statement [insert into T_SALESORDERHEADER (SO_ID, BUYER_ID, BUYER_NAME, CURRENCY_CODE, DELIVERY_STATUS, creationDate, HOUSE_NUMBER, STREET_NAME, CITY, COUNTRY) values(9, 9, 'buyerName_9', 'GBR', '02', '2013-01-01 00:00:00', 9, 'Test_Street_Name_9', 'Test_City_9', 'Test_Country_9');]
Error Code: -104
Call: insert into T_SALESORDERHEADER (SO_ID, BUYER_ID, BUYER_NAME, CURRENCY_CODE, DELIVERY_STATUS, creationDate, HOUSE_NUMBER, STREET_NAME, CITY, COUNTRY) values(9, 9, 'buyerName_9', 'GBR', '02', '2013-01-01 00:00:00', 9, 'Test_Street_Name_9', 'Test_City_9', 'Test_Country_9');
Query: DataModifyQuery(sql="insert into T_SALESORDERHEADER (SO_ID, BUYER_ID, BUYER_NAME, CURRENCY_CODE, DELIVERY_STATUS, creationDate, HOUSE_NUMBER, STREET_NAME, CITY, COUNTRY) values(9, 9, 'buyerName_9', 'GBR', '02', '2013-01-01 00:00:00', 9, 'Test_Street_Name_9', 'Test_City_9', 'Test_Country_9');")

3. (minor) In the pom file, there are leftover plugins from the initial SAP contribution:
<plugin>
<groupId>com.sap.research</groupId>
<artifactId>nwcloud-maven-plugin</artifactId>
<version>1.0.0.RELEASE</version>
</plugin>