This is an automated email from the ASF dual-hosted git repository. struberg pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/openjpa.git
commit 64af85106ae52432c91ff6fa5bf0ed95323d457e Author: Mark Struberg <[email protected]> AuthorDate: Fri Apr 5 11:07:53 2019 +0200 fix random failing behaviour if id did already exist --- .../openjpa/persistence/jpql/functions/TestSetParameter.java | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) diff --git a/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jpql/functions/TestSetParameter.java b/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jpql/functions/TestSetParameter.java index 40a142f..cb61095 100644 --- a/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jpql/functions/TestSetParameter.java +++ b/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jpql/functions/TestSetParameter.java @@ -119,9 +119,16 @@ public class TestSetParameter extends SingleEMFTestCase { public void testNativeSQL() { EntityManager em = emf.createEntityManager(); em.getTransaction().begin(); + + // make sure that the ID we want to insert does not exist. + int proposedId; + do { + proposedId = (int) System.currentTimeMillis() % 10000; + } while (em.find(Address.class, proposedId) != null); + int count = em.createNativeQuery("INSERT INTO Address (id, city," + " country, streetAd, zipcode) VALUES (?,?,?,?,?)") - .setParameter(1, System.currentTimeMillis()%10000) + .setParameter(1, proposedId) .setParameter(2, "Some City") .setParameter(3, "Some Country") .setParameter(4, "Some Street")
