# Error USERNAME=helen.kelly | javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement

**URL:** <https://community.ofelia.com/t/error-username-helen-kelly-javax-persistence-persistenceexception-org-hibernate-exception-constraintviolationexception-could-not-execute-statement/6192>\
**Category:** Q&A\
**Created:** [27 July 2015 14:31 UTC](https://community.ofelia.com/t/error-username-helen-kelly-javax-persistence-persistenceexception-org-hibernate-exception-constraintviolationexception-could-not-execute-statement/6192 "2015-07-27T14:31:14Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rodrigojcortes](https://avatars.discourse-cdn.com/v4/letter/r/e19adc/32.png) [@rodrigojcortes](https://community.ofelia.com/u/rodrigojcortes)\
**Post date:** [27 July 2015 14:31 UTC](https://community.ofelia.com/t/error-username-helen-kelly-javax-persistence-persistenceexception-org-hibernate-exception-constraintviolationexception-could-not-execute-statement/6192/1 "2015-07-27T14:31:14Z")

</div>

hola estoy intentando realizar el ejemplo de practica propuesto en la pagina en el cual uno persona reserva el viaje y otro revisa, el tutorial sugiere loquearse con helen y evniar variables pero cuando hago clic en inicio aparece el siguiente error. Alguien podria ayudarme gracias

USERNAME=helen.kelly | javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement

---

<div class="post-metadata">

**Author:** ![alanitaucv](https://avatars.discourse-cdn.com/v4/letter/a/50afbb/32.png) [@alanitaucv](https://community.ofelia.com/u/alanitaucv)\
**Post date:** [7 August 2015 17:12 UTC](https://community.ofelia.com/t/error-username-helen-kelly-javax-persistence-persistenceexception-org-hibernate-exception-constraintviolationexception-could-not-execute-statement/6192/2 "2015-08-07T17:12:22Z")

</div>

Hola, el error javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement es un error de base de datos debido a los indices de las tablas.

Una manera de solucionar este problema de forma rápida es utilizando otro actor en el proceso. Por ejemplo, podrías utilizar como actor Jan Fisher en lugar de Helen Kelly, su Manager es Favio Riviera. Ingresas al portal de forma análoga, solo cambias los usernames y listo! 🙂

---

<div class="post-metadata">

**Author:** ![aloknath15](https://avatars.discourse-cdn.com/v4/letter/a/ecccb3/32.png) [@aloknath15](https://community.ofelia.com/u/aloknath15)\
**Post date:** [29 June 2016 07:41 UTC](https://community.ofelia.com/t/error-username-helen-kelly-javax-persistence-persistenceexception-org-hibernate-exception-constraintviolationexception-could-not-execute-statement/6192/3 "2016-06-29T07:41:53Z")

</div>

It’s not working after that also kindly suggest me some other solution please

---

<div class="post-metadata">

**Author:** ![ee\_prasad\_1353433](https://avatars.discourse-cdn.com/v4/letter/e/e19adc/32.png) [@ee\_prasad\_1353433](https://community.ofelia.com/u/ee_prasad_1353433)\
**Post date:** [15 October 2017 14:45 UTC](https://community.ofelia.com/t/error-username-helen-kelly-javax-persistence-persistenceexception-org-hibernate-exception-constraintviolationexception-could-not-execute-statement/6192/4 "2017-10-15T14:45:39Z")

</div>

I had same problem when i start with tutorial…  
First check log file “C:\BonitaBPMCommunity-7.5.4\workspace\tomcat\server\logs”  
it will have log as “Caused by: org.h2.jdbc.JdbcSQLException: NULL not allowed for column “DEPARTUREDATE”; SQL statement:  
insert into TRAVELREQUEST (persistenceId, NAME, persistenceVersion, REASON) values (null, ?, ?, ?) [23502-175]”

I removed all in data model and re-setup the design. then it worked on first run. 🙂