saving a Blob in the CRUD admin.

[dimitri]

Hi everybody,

I'am a Plays! new user.

I try to save a Object with a Blob propertie in the Crud admin page
but it doesn't work. :(

I have this log:

Execution exception (In {module:crud}/app/controllers/CRUD.java around
line 135)
PersistenceException occured : org.hibernate.exception.DataException:
could not insert: [models.Candidat]

play.exceptions.JavaExecutionException:
org.hibernate.exception.DataException: could not insert:
[models.Candidat]
at play.mvc.ActionInvoker.invoke(ActionInvoker.java:290)
at Invocation.HTTP Request(Play!)
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.DataException: could not insert:
[models.Candidat]
at
org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:
1235)
at
org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:
1168)
at
org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:
1174)
at
org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:
674)
at play.db.jpa.JPABase._save(JPABase.java:37)
at controllers.CRUD.create(CRUD.java:135)
at
play.mvc.ActionInvoker.invokeControllerMethod(ActionInvoker.java:413)
at
play.mvc.ActionInvoker.invokeControllerMethod(ActionInvoker.java:408)
at play.mvc.ActionInvoker.invoke(ActionInvoker.java:182)
... 1 more
Caused by: org.hibernate.exception.DataException: could not insert:
[models.Candidat]
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:
102)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:
66)
at
org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:
64)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:
2329)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:
2836)
at
org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:
71)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:
267)
at
org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:
321)
at
org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:
204)
at
org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:
130)
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:
800)
at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:
774)
at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:
778)
at
org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:
668)
... 6 more
Caused by: java.sql.SQLException: Type Conversion not supported
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.setParameter(Unknown
Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.setString(Unknown
Source)
at play.db.jpa.Blob.nullSafeSet(Blob.java:101)
at org.hibernate.type.CustomType.nullSafeSet(CustomType.java:
173)
at
org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:
2168)
at
org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:
2145)
at org.hibernate.persister.entity.AbstractEntityPersister
$4.bindValues(AbstractEntityPersister.java:2323)
at
org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:
56)
... 21 more


Do you have any idea?

Thanks.

Dimitri.