sauvegarder image en utilisant Hibernate

Version imprimable

Bonjour,
Je veux réaliser une application de sauvegarde d'image dans une base de données en utilisant le framework hiberate. Mais je me trouve bloqué à cause de l'exception suivante:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Exception in thread "AWT-EventQueue-0" java.lang.ClassCastException: [B cannot be cast to java.sql.Blob
        at org.hibernate.type.BlobType.set(BlobType.java:49)
        at org.hibernate.type.BlobType.nullSafeSet(BlobType.java:117)
        at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1997)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2243)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
        at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)

sachant que j'ai mis dans le mapping file la ligne suivante:

Code:

<property column="rowcarte" name="rowcarte" type="blob" />

Si vous avez des idées ou des propositions veuillez me les indiquer.

09/07/2009, 13h52
fr1man

Quel est le type de la propriété Java correspondante ?

Code:

1
2
@Column(name = "rowcarte")
    private byte[] rowcarte;

Je viens de rectifier le mapping file et j'ai mis byte[] au lieu de blob mais une autre exception s'est générée:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
INFO: Not binding factory to JNDI, no JNDI name configured
10 juil. 2009 06:20:35 org.hibernate.util.JDBCExceptionReporter logExceptions
ATTENTION: SQL Error: 0, SQLState: 22001
10 juil. 2009 06:20:35 org.hibernate.util.JDBCExceptionReporter logExceptions
GRAVE: Data truncation: Data too long for column 'rowcarte' at row 1
10 juil. 2009 06:20:35 org.hibernate.event.def.AbstractFlushingEventListener performExecutions
GRAVE: Could not synchronize database state with session
org.hibernate.exception.DataException: Could not execute JDBC batch update
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'rowcarte' at row 1
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1269)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:955)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
        ... 33 more