Complex insertion data - NULL not allowed for column "CODEDEVISE";

Submitted by DrakunDry on Mon, 09/05/2016 - 19:55
1
0
-1

Bonjour,
j'ai un problème pour insérer des donnes dans un contract

LH6Zthp.png

XmCdkHT.png

Jai mis une liste déroulante mais quand j'essais d'insérer jai toujours un message d'erreur

Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement
        at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:129)
        at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
        at org.hibernate.internal.SessionImpl.merge(SessionImpl.java:821)
        at org.hibernate.ejb.AbstractEntityManagerImpl.merge(AbstractEntityManagerImpl.java:889)
        ... 119 more
Caused by: org.h2.jdbc.JdbcSQLException: NULL not allowed for column "CODEDEVISE"; SQL statement:
insert into SOCIETE (persistenceId, CONTACT, EMAIL, LIBELLE, persistenceVersion, ZONEGEO_PID) values (null, ?, ?, ?, ?, ?) [23502-170]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
        at org.h2.message.DbException.get(DbException.java:169)
        at org.h2.message.DbException.get(DbException.java:146)
        at org.h2.table.Column.validateConvertUpdateSequence(Column.java:293)
        at org.h2.table.Table.validateConvertUpdateSequence(Table.java:689)
        at org.h2.command.dml.Insert.insertRows(Insert.java:120)
        at org.h2.command.dml.Insert.update(Insert.java:84)
        at org.h2.command.CommandContainer.update(CommandContainer.java:75)
        at org.h2.command.Command.executeUpdate(Command.java:230)
        at org.h2.server.TcpServerThread.process(TcpServerThread.java:333)

Et pourtant ma variable société est bien initialisé
O4h0oKU.png

All BDM
SOCIETE
PoO1fvY.png

ZONEGEO
k4djNeB.png

DEVISE
8fr37Gi.png

complex
complex list to a widget

Comments

Submitted by DrakunDry on Tue, 09/06/2016 - 10:42

voila mon erreur , et je ne vois pas a quel moment il persiste les données en base de donnée

org.hibernate.ejb.AbstractEntityManagerImpl.merge(AbstractEntityManagerImpl.java:889)
        ... 121 more
Caused by: org.h2.jdbc.JdbcSQLException: NULL not allowed for column "CODEDEVISE"; SQL statement:
insert into SOCIETE (persistenceId, CONTACT, EMAIL, LIBELLE, persistenceVersion, ZONEGEO_PID) values (null, ?, ?, ?, ?, ?) [23502-170]
Permalink
1 answer

Submitted by DrakunDry on Sun, 09/18/2016 - 01:53
1
0
-1
This one is the BEST answer!

merci

Notifications