Bug in Hibernate Slide storage on 2.0.1RC3?

[sverker]

I noticed that when using the Hibernate storage all files that I upload through WebDAV only have correct data up to the first 8192 bytes, the rest is zero up to the correct length. With the file storage it works fine.

JBoss AS: 4.0.3SP1
JBoss Portal: 2.0.1RC3
Java version: 1.5.0_05
DB: MySQL 4.1.7

Is this a bug or some missconfiguration?
/Sverker

[roy.russo]

Have you checked your mysql log for errors? Check what your max_allowed_packet variable is set to in the mysql config. If you're uploading 8MB files, it should be AT LEAST that.

[sverker]

Hi
no clues in the log files. I have max_allowed_packet=64M and I can put big blobs from my own hibernate-based app to the same db.

Note that the limit is 8k, not 8M, and the blob is still say 15k but everything above the 8k limit is zero.

[bdaw]

as I replied to: http://www.jboss.com/index.html?module=bb&op=viewtopic&t=73336

The possible issue could be to weak sql column type for stroring blobs in schema created by hibernate.

Look at "slide_version_content" table and "content" column.
If you are using mysql and it's "BLOB" type it will store data up to 64K only.
Try altering column type with:

ALTER TABLE slide_version_content CHANGE content content longblob

(this is mysql specific command)

Could you try this and tell us if this was the issue?

[sverker]

Did the change of column type to longblob but that did not solve the problem.