[jira] [Created] (OLINGO-48) jpa reference application issues wtih sample data population

["Georgi (JIRA)" <ji...@apache.org>]

Georgi created OLINGO-48:
----------------------------

             Summary: jpa reference application issues wtih sample data population
                 Key: OLINGO-48
                 URL: https://issues.apache.org/jira/browse/OLINGO-48
             Project: Olingo
          Issue Type: Bug
          Components: odata2-jpa
    Affects Versions: 1.0.0, 1.1.0
            Reporter: Georgi


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>



--
This message was sent by Atlassian JIRA
(v6.1#6144)