javax.persistence.PersistenceException

[grimmpat]

Hello,

I want to insert some data but I have some erros ...

---- My models :

@Entity
public class Service extends Model{

@Required
public String nomService;

@OrderBy("codeUF")
@OneToMany(cascade=CascadeType.ALL)
@Required
public List<UF> ufs = new ArrayList<UF>();
}

@Entity
public class UF extends Model{

@Required
@Unique
@MaxSize(5)
public String codeUF;

@ManyToOne(cascade = CascadeType.ALL)
@Required
public Utilisateur cadreRef;
}

@Entity
public class Utilisateur extends Model {

@Required
public String nomUtilisateur;

@Required
public String prenomUtilisateur;

public String pswd;

public String email;
}

I do that in my controller ;

UF u = UF.findById(idUf);
Service serv = new Service();
serv.nomService = "blablabla";
serv.ufs = new ArrayList<UF>();
serv.ufs.add(u);
System.out.println(serv.ufs);
System.out.println(serv.nomService);
System.out.println("***********************************************");
try {
serv._save();
} catch (Exception e) {
e.printStackTrace();
}


And I have this message :


[09311(roussel marion)]
genetique medicale
***********************************************
16:36:02,041 WARN ~ SQL Error: 90021, SQLState: 90021
16:36:02,041 ERROR ~ Data conversion error converting "'genetique
medicale' (ID BIGINT DEFAULT (NEXT VALUE FOR
PUBLIC.SYSTEM_SEQUENCE_41339D74_D54B_45DF_826E_B11EE8A6148E) NOT NULL
NULL_TO_DEFAULT SEQUENCE
PUBLIC.SYSTEM_SEQUENCE_41339D74_D54B_45DF_826E_B11EE8A6148E)"; SQL
statement:
insert into Service (id, nomService) values (null, ?) [90021-149]
javax.persistence.PersistenceException:
org.hibernate.exception.GenericJDBCException: could not insert:
[models.Service]
at
org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:
1214)
at
org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:
1147)
at
org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:
1153)
at
org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:
678)
at play.db.jpa.JPABase._save(JPABase.java:25)
at controllers.Services.addService(Services.java:119)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at play.mvc.ActionInvoker.invokeWithContinuation(ActionInvoker.java:
548)
at play.mvc.ActionInvoker.invoke(ActionInvoker.java:502)
at play.mvc.ActionInvoker.invokeControllerMethod(ActionInvoker.java:
478)
at play.mvc.ActionInvoker.invokeControllerMethod(ActionInvoker.java:
473)
at play.mvc.ActionInvoker.invoke(ActionInvoker.java:161)
at play.server.PlayHandler$NettyInvocation.execute(PlayHandler.java:
257)
at play.Invoker$Invocation.run(Invoker.java:278)
at play.server.PlayHandler$NettyInvocation.run(PlayHandler.java:235)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown
Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor
$ScheduledFutureTask.access$201(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor
$ScheduledFutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.hibernate.exception.GenericJDBCException: could not
insert: [models.Service]
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:
140)
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:
128)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:
66)
at
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:
64)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:
2345)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:
2852)
at
org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:
71)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
at
org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:
320)
at
org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:
203)
at
org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:
129)
at
org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:
69)
at
org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:
179)
at
org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:
135)
at
org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:
61)
at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:808)
at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:782)
at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:786)
at
org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:
672)
... 22 more
Caused by: org.h2.jdbc.JdbcSQLException: Data conversion error
converting "'genetique medicale' (ID BIGINT DEFAULT (NEXT VALUE FOR
PUBLIC.SYSTEM_SEQUENCE_41339D74_D54B_45DF_826E_B11EE8A6148E) NOT NULL
NULL_TO_DEFAULT SEQUENCE
PUBLIC.SYSTEM_SEQUENCE_41339D74_D54B_45DF_826E_B11EE8A6148E)"; SQL
statement:
insert into Service (id, nomService) values (null, ?) [90021-149]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:
327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.table.Column.convert(Column.java:149)
at
org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:
326)
at
org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:
271)
at org.h2.table.Table.fireConstraints(Table.java:812)
at org.h2.table.Table.fireAfterRow(Table.java:829)
at org.h2.command.dml.Insert.insertRows(Insert.java:128)
at org.h2.command.dml.Insert.update(Insert.java:86)
at org.h2.command.CommandContainer.update(CommandContainer.java:69)
at org.h2.command.Command.executeUpdate(Command.java:209)
at
org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:
143)
at
org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:
129)
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:
105)
at org.hibernate.id.IdentityGenerator
$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:94)
at
org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:
57)
... 37 more



Thks for your help !!!
Tom.