grimmpat
unread,Jun 11, 2012, 10:45:07 AM6/11/12Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to play-framework
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.